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.