
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎07-08-2009 07:01 PM
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
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
Solved! Go to Solution.
Labels:
- Labels:
-
General Discussion
1 ACCEPTED SOLUTION

Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎07-13-2009 11:23 AM
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 ...
- 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 ...
21 REPLIES 21

Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎07-09-2009 03:52 PM
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*
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*

Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎07-10-2009 10:43 AM
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?
