EVE-SECURE / evemarketmonitorapp

Automatically exported from code.google.com/p/evemarketmonitorapp
0 stars 0 forks source link

Cannot open user default database #36

Closed GoogleCodeExporter closed 9 years ago

GoogleCodeExporter commented 9 years ago
After update haven't been able to startup EMMA.  Tried to uninstall and 
reinstall.

I think this is a problem connecting to the SQL Express.  I did update to 2008 
R2 for vista and EMMA was working. 

I don't honestly know anything about SQL Express - just installed to get EMMA 
working - so I haven't altered anything deliberately with that program.  

My user account is the 'administrator' on this computer.

Exception log is as follows:

================================================================================
=====
                                   EXCEPTION REPORT
================================================================================
=====
26/06/2010 10:30:29 Critical - EveMarketMonitorApp.Common.EMMAException - Error 
during startup
    Inner Exception: Cannot open user default database. Login failed.
Login failed for user 'Alan-PC\Alan'.
    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.Update()
   at EveMarketMonitorApp.GUIElements.Main..ctor(Boolean checkForUpdates)

Original issue reported on code.google.com by ahwal...@hotmail.co.uk on 26 Jun 2010 at 9:41

GoogleCodeExporter commented 9 years ago
SQL seems to get itself into a mess like this fairly regularly. To resolve it, 
try deleting the following folder:

Windows Vista/7: C:\Users\[user]\AppData\Local\Microsoft\Microsoft SQL Server 
Data\SQLEXPRESS
Windows XP: c:\Documents and Settings\[user]\Local Settings\Application 
Data\Microsoft\Microsoft SQL Server Data\SQLEXPRESS

Original comment by Ambo.E...@gmail.com on 30 Jun 2010 at 12:25

GoogleCodeExporter commented 9 years ago

Original comment by SteveBal...@gmail.com on 9 Sep 2010 at 10:59