search

EVE-SECURE / evemarketmonitorapp

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

Unable to detect SQL instance? #37

Closed GoogleCodeExporter closed 9 years ago

GoogleCodeExporter commented 9 years ago 
Report below. I'm assuming that the second two errors are ring down from the 
first error. Fresh install of SQL Express 2008 R2 and Emma. Been at it all day. 
Wiped R2 repeatedly and did default installation (also tried a named 
installation) but this is as far as I get.

Never run EMMA before, kind of disappointed that I can't now.

================================================================================
=====
                                   EXCEPTION REPORT
================================================================================
=====
7/11/2010 10:05:50 PM Critical - EveMarketMonitorApp.Common.EMMAException - 
Cannot start SQL Express service
    Inner Exception: Service MSSQL$SQLEXPRESS was not found on computer '.'.
    Stack Trace:    at System.ServiceProcess.ServiceController.GenerateNames()
   at System.ServiceProcess.ServiceController.get_ServiceName()
   at System.ServiceProcess.ServiceController.GenerateStatus()
   at System.ServiceProcess.ServiceController.get_Status()
   at EveMarketMonitorApp.GUIElements.Main.isSQLExpressRunning()
        Inner Exception: The specified service does not exist as an installed service
================================================================================
=====
                                   EXCEPTION REPORT
================================================================================
=====
7/11/2010 10:05:50 PM Critical - EveMarketMonitorApp.Common.EMMAException - 
Problem accessing SQL Express service
    Inner Exception: Cannot start SQL Express service
    Stack Trace:    at EveMarketMonitorApp.GUIElements.Main.isSQLExpressRunning()
        Inner Exception: Service MSSQL$SQLEXPRESS was not found on computer '.'.
        Stack Trace:    at System.ServiceProcess.ServiceController.GenerateNames()
   at System.ServiceProcess.ServiceController.get_ServiceName()
   at System.ServiceProcess.ServiceController.GenerateStatus()
   at System.ServiceProcess.ServiceController.get_Status()
   at EveMarketMonitorApp.GUIElements.Main.isSQLExpressRunning()
            Inner Exception: The specified service does not exist as an installed service
================================================================================
=====
                                   EXCEPTION REPORT
================================================================================
=====
7/11/2010 10:06:56 PM Critical - EveMarketMonitorApp.Common.EMMAException - 
Error during startup
    Inner Exception: A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)
    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.Connect(ServerInfo serverInfo, SqlInternalConnectionTds connHandler, Boolean ignoreSniOpenTimeout, Int64 timerExpire, Boolean encrypt, Boolean trustServerCert, Boolean integratedSecurity, SqlConnection owningObject)
   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 bigbearw...@gmail.com on 12 Jul 2010 at 5:09

GoogleCodeExporter commented 9 years ago 
Looks like SQL has not installed correctly or something. Can't really suggest 
much other that trying again but it sounds like you've tried that already.

Original comment by SteveBal...@gmail.com on 23 Jul 2010 at 12:32

GoogleCodeExporter commented 9 years ago 
I had a problem with this and found out that the problem could be cause by two 
things. First installing  SQL with default settings might not work. It will 
create a DBase called MSSQLSERVER. EMMA might expect a DBase called SQLEXPRESS 
as appears by default when installing.
Second problem might be the user account which might have to be 
NTAUTHORITY/SYSTEM.
Third the authentication should be Windows and not Mixed.

Original comment by battle.a...@gmail.com on 12 Aug 2010 at 11:24

GoogleCodeExporter commented 9 years ago

Original comment by SteveBal...@gmail.com on 9 Sep 2010 at 11:00