Problems with upgrade from SQL 2000 to SQL 2005

paprita · ‎07-08-2009

I've upgrade SQL from 2000 to 2005 version using backup/restore procedure.
Then I've reinstalled lansweeperservice on a server and web site on another server (I've tryed both 3.5.1 and 3.5.2 beta versions).

Now situation is:
- db seems to run correctly;
- lsmanage.exe run correctly (I can see the db);
- lansweeperservice.exe can't start due to login error (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'.)
- web site doesn't work due to login problem too as follow:

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

What's the problem?

In attach web.config and Lansweeperservice.exe.config

paprita · ‎07-13-2009

After all we found a way to solve this problem:

- delete lansweeper schema (databases\lansweeperdb\security\schemas)
- delete lansweeperuser (databases\lansweeperdb\security\users)
- delete lansweeperuser (security\logins)
- create lansweeperuser (security\logins)
- create lansweeperuser (databases\lansweeperdb\security\users)
- create lansweeper schema (databases\lansweeperdb\security\schemas)

Now it seems to go properly but I'm not sure to see any improvement passing from SQL 2000 to 2005 ...

View solution in original post

Hemoco · ‎07-09-2009

Check if your Data source is correct.
Check the database name (lansweeperdb) (should be the same)
Check if user lansweeperuser exists and if it has access to the lansweeperdb
If not create the sql user and make him dbowner.

Data Source=Serv-ISRO-TEST;
Initial Catalog=lansweeperdb;
User ID=lansweeperuser;
Password=mysecretpassword0*

paprita · ‎07-10-2009

Lansweeper wrote:
Check if your Data source is correct.

Yes.

Lansweeper wrote:
Check the database name (lansweeperdb) (should be the same)

Yes.

Lansweeper wrote:
Check if user lansweeperuser exists and if it has access to the lansweeperdb

Yes.

What else?

Problems with upgrade from SQL 2000 to SQL 2005

New to Lansweeper?

Try Lansweeper For Free