Dynamics Community Forum Thread Details

Script [Pre Configured VM] failed execution against VM

Hi Guys,

I'm facing challenge in deployment of AX 2012 R3 on Azure with LCS in High Availability mode, Once witness is prepared, I'm getting error of Script [Pre Configured VM] failed execution against VM on First SQL VM.

----

[2015-12-24 06:08:40] Creating smoke test user as sysadmin
[2015-12-24 06:08:40] Microsoft.SqlServer.Management.PowerShell.SqlPowerShellSqlExecutionException: Incorrect syntax near '-'. ---> System.Data.SqlClient.SqlException: Incorrect syntax near '-'.
   at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
   at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
   at System.Data.SqlClient.SqlDataReader.TryConsumeMetaData()
   at System.Data.SqlClient.SqlDataReader.get_MetaData()
   at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)
   at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, SqlDataReader ds)
   at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean asyncWrite)
   at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)
   at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method)
   at System.Data.SqlClient.SqlCommand.ExecuteReader()
   at Microsoft.SqlServer.Management.PowerShell.ExecutionProcessor.ExecuteBatch(String batch)
   --- End of inner exception stack trace --- : At line:198 char:3
+         Invoke-SqlCmd -Query "GRANT VIEW SERVER STATE TO $smoketestuser" -ServerInstan ...

Unable to find why this error is coming.

More details.

I'm using existing domain, I'm only deploying SQL and AOS Servers with HA.

Quick Links

Leaderboard