moving Lansweeper application and db to new servers

[googoo]

current setup: LS 3.52 and DB (SQLexpress 2005) running on SERVER1 (Win2k3R2)

desired setup: LS 3.52 running on SERVER2 (virtual Win2k8R2), DB running on SERVER3 (virtual Win2k8R2, full SQL 2k8)

I've installed the app on SERVER2 and let it create the default DB on SERVER3. I then stopped the LS service and restored the DB from SERVER1 onto SERVER3.

I can access the LS config utility without issue, but when I try to access the web console, I get the following errors:

System.Data.SqlClient.SqlException: Login failed for user 'lansweeperuser'.
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 DreamweaverCtrls.DataSet.DoInit()
--------------------------------------------------------------------------------
System.Data.SqlClient.SqlException: Login failed for user 'lansweeperuser'.
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 DreamweaverCtrls.DataSet.DoInit()

How do I fix this login?

[googoo]

thanks....the group that was added to local admins did not include the account i was trying to use. nothing like banging your head against the wall for so long only to find the answer was so simple.

[Hemoco]

Do you see something in the errorlog.txt file?

You can try to go into services/lansweeper service and retype the login/password.

[googoo]

Apparently, I have bigger issues. I cannot keep the LS server running. I've been through multiple installs on both the application and db server. the LS install log indicates no errors. However, the application event log indicates that the LS server stops as soon as it starts. if I then try to start manually, I get:

"windows could not start the lansweeper service on SERVER2. Error 1067: process terminated unexpectedly."

Help...

[Hemoco]

Do you have the SQL management tools installed on the database server?
If you right click on the database you will see "users", it's easy to create a new one with the gui.

[googoo]

I found the username/password before posting. Both web.config files (from SERVER1 and SERVER2) show the same username/password, so i'm not sure why the login is failing. However, I'm no SQL expert--how do I change the password of the SQL user 'lansweeperuser'?

[Hemoco]

In the web.config file you will find the username and password.
In sql server make sure that the password for this user is the same (if the user doesn't exist, create it) and make it owner of lansweeperdb.