How to reset username/password that lansweeper uses to connect to SQL?

[mform]

How to reset username/password that lansweeper uses to connect to SQL?


I get the following eerors:

System.Data.SqlClient.SqlException: Login failed for user 'lansweeperuser'.
at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)



thanks

[Hemoco]

This can only be caused by:

1) username/password wrong on the database.
2) username/password wrong in the config files.
3) sql user locked out.
4) database not configured for mixed authentication.

[mform]

Thanks, I did all that, but its still logs the erros of invalid password.

everytime I restart teh service I get the following:

6/21/2010 9:31:16 AM: Cannot connect to database, check your config file, service will be stopped
Cannot open database "lansweeperdb" requested by the login. The login failed.
Login failed for user 'lansweeperuser'.


Also the website shows this: see attachment

Thanks

[Hemoco]

To reset the password on the database you need sql server management studio (which is a free download if you use sql express)

You also need to change the password in web.config and lansweeperservice.exe.config