Hi All,

I am Trying to create a SQL DB in Azure using powershell and my script is working fine from powershell console...I wanted to execute the commands in command line console and i don't want to execute the script as a .ps1 file...

I set my subscription and publish setting files and connected to azure...

Now, when i trying to execute the command New-AzureSqlDatabaseServer -AdministratorLogin "MyServerLogin" -AdministratorLoginPassword "MyPassw0rd" -Location East US in command line i am executing the command as below...

PowerShell -Command " & {New-AzureSqlDatabaseServer -AdministratorLogin "MyServerLogin" -AdministratorLoginPassword "MyPassw0rd" -Location "East US"}"

And i am getting the below error...

New-AzureSqlDatabaseServer : A positional parameter cannot be found that
accepts argument 'US'.
At line:1 char:1
+ New-AzureSqlDatabaseServer -AdministratorLogin MyServerLogin
-AdministratorLogin ...
+ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
~~~
    + CategoryInfo          : InvalidArgument: (:) [New-AzureSqlDatabaseServer
   ], ParameterBindingException
    + FullyQualifiedErrorId : PositionalParameterNotFound,Microsoft.WindowsAzu
   re.Commands.SqlDatabase.Server.Cmdlet.NewAzureSqlDatabaseServer

Can someone help me to resolve this issue...

Thanks in advance for your help...

Regards,

Sudheesh M A

• Edited by Sudheesh M A Monday, April 28, 2014 1:54 PM