Problem Service SQL Connection

[ahandler]

If i start server - i get this error in errorlog. Clients cannot get connection so server.

#####################################################

28.02.2008 09:16:56
System.Data.SqlClient.SqlException: Cannot open database "Lansweeper" requested by the login. The login failed.
Login failed for user 'lssqluser'.
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.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.CreatePooledConnection(DbConnection owningConnection, DbConnectionPool pool, DbConnectionOptions options)
at System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection owningObject)
at System.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection owningObject)
at System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject)
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 Lansweeper30.starter.startsweeper()

#####################################################

If i stopp service and start it again, there is no error.

Looking forward for an answer.

Regards Andreas

[annym]

I have expereinced the same thing. Lansweeper service starts faster than the SQL-service. I have tried this simple solution. Make LansweeperPRO depend on the SQL-service. That way the LansweeperPro service won't start until the SQL-service is running.

Check out http://support.microsoft.com/kb/193888 for more information how to make a service depend on another

[ahandler]

I also think so, sql is starting, but lansweepPro is faster - so the login fails! May be you will find a solution

Regards Andy

[Hemoco]

My guess is that the sql service is still starting when the lansweeper service starts, but this shouldn't be a problem.

[ahandler]

I tryed now to set service on manual start - and added a sheduled task with net start LanSweeperPRO - on computer startup. And it works.

Is that a hint, to find the right way to a solution?

Regards Andreas

[ahandler]

VMWare workstation is good for development - of a system - on desktop PC's - and later i put in on VMWARE Server on real Server.

I hope you can send a solution to me!

Regards Andreas

[Hemoco]

I tested everything on:
-physical server
-vmware esx
-virtual pc

Without any problems, but I have never tried it with vmware workstation.

[ahandler]

Thanks a lot - if it will be working, we think of buying premium support of Lansweeper, i already have been talking to my boss!

[Hemoco]

VMWare workstation - is there a problem?

Just trying to pinpoint the problem.

[ahandler]

VMWare workstation - is there a problem?

Should be on a VMWare Server if VMWare Server 2.0 is released