1
Vote

Migration Wizard crashed on last step (logging into SQL Azure)

description

Reason: Usage of ";" in logon password
 
Resolution: Change logon password
Can be done with SQL Server Management Studio
ALTER LOGIN [AdminName] WITH PASSWORD = '[1234567!]'
 
Use Characters That Do Not Conflict With ODBC Connection Strings.
To avoid errors you should not use these ODBC connection string characters []{}(),;?*!@ in Login Name and Password.
 
After that everything runs smoothly
Tool worked perfect - Many Thx!
 
Complete Stacktrace:
System.ArgumentException was unhandled
Message=Keyword not supported: 'XXX;encrypt'.
Source=System.Data
StackTrace:
   at System.Data.Common.DbConnectionOptions.ParseInternal(Hashtable parsetable, String connectionString, Boolean buildChain, Hashtable synonyms, Boolean firstKey)
   at System.Data.Common.DbConnectionOptions..ctor(String connectionString, Hashtable synonyms, Boolean useOdbcRules)
   at System.Data.SqlClient.SqlConnectionString..ctor(String connectionString)
   at System.Data.SqlClient.SqlConnectionFactory.CreateConnectionOptions(String connectionString, DbConnectionOptions previous)
   at System.Data.ProviderBase.DbConnectionFactory.GetConnectionPoolGroup(String connectionString, DbConnectionPoolGroupOptions poolOptions, DbConnectionOptions& userConnectionOptions)
   at System.Data.SqlClient.SqlConnection.ConnectionString_Set(String value)
   at System.Data.SqlClient.SqlConnection.set_ConnectionString(String value)
   at System.Data.SqlClient.SqlConnection..ctor(String connectionString)
   at SQLAzureMWUtils.TargetProcessor.ExecuteSQLonTarget(Server targetServer, String targetDatabase, String collation, String edition, Int32 dbSize, AsyncUpdateStatus updateStatus, AsyncQueueBCPJob queueBCPJob, String sqlToExecute, Boolean bDropDatabaseIfExists)
   at SQLAzureMW.ScriptWizard.ExecuteSQLonTarget()
   at System.Threading.ThreadHelper.ThreadStart_Context(Object state)
   at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state)
   at System.Threading.ThreadHelper.ThreadStart()
InnerException:

comments

ghuey wrote Jun 17, 2012 at 11:59 PM

Hi, thanks for the feedback. I will have to put a better catch in my code so that it does not crash and provide better feedback. I am glad you got it working though.

Thanks again,
George