cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
SPAMHATER007
Engaged Sweeper III
I have setup a temporary server running 3.5.2.4, restored our production database on this temporary server, deleted all the computer accounts and performed upgrade to 4.0.

I now get this error when hitting the web page, how can I correct?

System.Data.SqlClient.SqlException: Cannot open database "lansweeperdb" requested by the login. The login failed.
Login failed for user 'lansweeperuser'.
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)

The main reason for upgrading, is to save all our custom reports, the upgrade fails after running for 12+ hours when all 3500+ computer accounts are in the DB.

I have verified the SQL account and the two config files match.
1 REPLY 1
Hemoco
Lansweeper Alumni
The problem can be caused by:
1) incorrect user/password (lansweeperuser) in config files or on database server.
2) incorrect database name/server name in the config files.
3) SQL server not configured for mixed authentication.
4) Lansweeperuser does not have rights to the database "lansweeperdb"
5) your database is not called "lansweeperdb"