Hi there Salam,
I’m getting the impression that your azure profile locally is likely corrupted. I’m assuming that this is the only machine that you’re experiencing the issue? You might want to look into whether running Clear-AzureProfile and then Get-AzurePublishSettingsFile to retrieve a new file and importing that to see if it resolves your issue.
Will, after writing my last response, I played with the following command as as test
New-AzureResourceGroup `
-hostingEnvironment AzureCloud `
-Name galleryARMdemo4-Rg `
-Location “North Europe” `
-serverLocation “North Europe” `
-GalleryTemplateIdentity Microsoft.WebSiteSQLDatabase.0.2.14-preview `
-siteName TestSiteDavidTesarCh9 `
-databaseName armffdb6 `
-administratorLogin myuser
-administratorLoginPassword mypassword
In spite of the fact that I got resource group created as well as the database, I had the 2 strange things, especially ther 2nd error for not recognizing -administratorLoginPassword parameter
ew-AzureResourceGroup : 2:44:01 PM - Resource Microsoft.Web/serverFarms ‘Default1’ failed with message ‘The specified location ‘“North Europe”’ is invalid. A
location must consist of characters, whitespace, digit, or following symbols ‘(,)’.’
Then
ResourceGroupName : galleryARMdemo4-Rg
Location : northeurope
ProvisioningState : Succeeded
Tags :
Permissions :
Actions NotActions
======= ==========
*
Resources :
Name Type Location
=================== =============================== ===========
ffarmdemoserverlive Microsoft.Sql/servers northeurope
armffdb6 Microsoft.Sql/servers/databases northeurope
ResourceId : /subscriptions/abcdesr0-5bd2-4205-8b89-57f6ab375a16/resourceGroups/galleryARMdemo4-Rg
Then
-administratorLoginPassword : The term ‘-administratorLoginPassword’ is not recognized as the name of a cmdlet, function, script file, or operable program.
Check the spelling of the name, or if a path was included, verify that the path is correct and try again.
At line:10 char:5
-administratorLoginPassword yazi*gopep1
~~~~~~~~~~~~~~~~~~~~~~~~~~~
Do you think I still need to do a clear Clear-AzureProfile ?
Hi there Salam,
I think we’re working on two (possibly three) issues in this thread. 
For your last post, I see backticks on all of the lines except the ones you’re having issues with. You might want to add the backticks so those lines are recognized as parameters and not separate commands.
As for the profile issue you’re having, if you feel the issue is resolved, then no. But if you’re still having problems importing the publish settings, then you may want to look into it.
Hi Salam,
Will Pinged me about your problems. You absolutely have to fix your cert problems before going on. The issues you’re seeing with them and the AzurePublishSettings file are huge warning signs.
I would delete your current certs and also remove your subscription, then reimport the settings. Use the Cmdlets Remove-AzureSubscription and then Import-AzurePublishSettingsFile again to see if this resolves some problems.
Ok, I will do this and let you know
Stephen, by "delete your current certs ", do you mean from local store as well as in Azure portal which is a valid cert
Stephen, following the command (on another machine)
Get-AzureSubscription -Subscriptionid and -SubscriptionName
to be sure that I am using the right value, I get a succesful response as follows
SubscriptionId : **********-5bd2-********-8b89-**********75att
SubscriptionName : Services de la plateforme Windows Azure pour Visual Studio Ultim
Environment : AzureCloud
SupportedModes : AzureServiceManagement,AzureResourceManager
…
…
I issue as per your recommandation the command Remove-AzureSubscription , I get
[blockquote]Remove-AzureSubscription : The subscription name Services de la plateforme Windows Azure pour Visual Studio Ultim doesn’t exist.
Parameter name: name
At line:1 char:1
+ CategoryInfo : CloseError: (:) [Remove-AzureSubscription], ArgumentException
+ FullyQualifiedErrorId : Microsoft.WindowsAzure.Commands.Profile.RemoveAzureSubscriptionCommand[/blockquote]
I issue Import-AzurePublishSettingsFile -PublishSettingsFile **************path to my publishingsettings, I get
[blockquote]Import-AzurePublishSettingsFile : There is an error in XML document (2, 2).
At line:1 char:1
+ CategoryInfo : CloseError: (:) [Import-AzurePublishSettingsFile], InvalidOperationException
+ FullyQualifiedErrorId : Microsoft.WindowsAzure.Commands.Profile.ImportAzurePublishSettingsCommand[/blockquote]I forgot to mention that I did not delete any certificate for the moment as I am waiting for your confirmation
Here some feedback.
In fact, the non-recognition of Azure commands in ISE was due to the fact that ISE 64 bit can not import the module Azure using “Import-Module Azure”. I discovered this after firing “Windows Azure Powershell” Shell and I was able to create a new Web site, new storage account, sql database, new firewall rules.
This thread helped me understand this
[blockquote]powershell - Import-Module Azure fails - Server Fault, I did
Import-Module “C:\Program Files [x86]\Microsoft SDKs\Azure\PowerShell\ServiceManagement\Azure\Azure.psd1”
[/blockquote]and I was able to do the same thing from ISE.
One note to Stephen, in my scripts, I am using thmbnails and the certificate as follows
[blockquote]$subscriptionID = $s.SubscriptionId
$testthumbprint = “tgfdvcfe4e52fc*********9bbf3b9230”
$cert = Get-ChildItem Cert:\CurrentUser\My$testthumbprint
Invoke-RestMethod -Method POST -Uri $queryString -Certificate $cert…
[/blockquote]
which works fine like a charm. So I am not sure if I have any issue with the certificate.
Still when I issue Import-AzurePublishSettingsFile, I get “Import-AzurePublishSettingsFile : There is an error in XML document (1, 1).”