What steps will reproduce the problem?
1. Upgrade SQLEXPRESS w/SQL Server 2008 R2.
2. Run EMMA -- fails (can't connect)
3. Re-installed EMMA
4. Run EMMA -- fails (can't connect)
What is the expected output? What do you see instead?
Error log reads:
================================================================================
=====
EXCEPTION REPORT
================================================================================
=====
7/25/2011 2:11:53 PM Critical - EveMarketMonitorApp.Common.EMMAException - EMMA
is unable to connect to the database.
================================================================================
=====
EXCEPTION REPORT
================================================================================
=====
7/25/2011 2:15:30 PM Critical - EveMarketMonitorApp.Common.EMMAException -
Error connecting to database
Inner Exception: The user instance login flag is not supported on this version of SQL Server. The connection will be closed.
Stack Trace: at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
at System.Data.SqlClient.SqlInternalConnectionTds.CompleteLogin(Boolean enlistOK)
at System.Data.SqlClient.SqlInternalConnectionTds.AttemptOneLogin(ServerInfo serverInfo, String newPassword, Boolean ignoreSniOpenTimeout, Int64 timerExpire, SqlConnection owningObject)
at System.Data.SqlClient.SqlInternalConnectionTds.LoginNoFailover(String host, String newPassword, Boolean redirectedUserInstance, SqlConnection owningObject, SqlConnectionString connectionOptions, Int64 timerStart)
at System.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(SqlConnection owningObject, SqlConnectionString connectionOptions, String newPassword, Boolean redirectedUserInstance)
at System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, Object providerInfo, String newPassword, SqlConnection owningObject, Boolean redirectedUserInstance)
at System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection)
at System.Data.ProviderBase.DbConnectionFactory.CreateNonPooledConnection(DbConnection owningConnection, DbConnectionPoolGroup poolGroup)
at System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection)
at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory)
at System.Data.SqlClient.SqlConnection.Open()
at EveMarketMonitorApp.DatabaseClasses.Updater.WaitForAcknowledge()
at EveMarketMonitorApp.GUIElements.Main.waitForSQLAcknowledge()
What version of the product are you using? On what operating system?
Installed EMMA v1.4 via setup.exe. Under Windows 7.
Please provide any additional information below.
Prior to SQLEXPRESS upgrade, it worked, sort of. Was still learning.
Day 1 of evaluation.
Original issue reported on code.google.com by paulesim...@gmail.com on 25 Jul 2011 at 6:24
Original issue reported on code.google.com by
paulesim...@gmail.comon 25 Jul 2011 at 6:24Attachments: