Problems with upgrade from SQL 2000 to SQL 2005

[paprita]

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]

Lansweeper wrote:
That's how it should be

Ok but I think that the precedent way to list O.S. was better and easier to read. Any way to change?

[Hemoco]

Is it the same as in the demo?
http://www.lansweeper.com/demo/

[paprita]

Lansweeper wrote:
Is it the same as in the demo?
http://www.lansweeper.com/demo/

Yes, very similar ...

[paprita]

With SQL 2000 the Operative System list (on digital dashboard) was by number, decreasing.
Now, with 2005, it seem to be mix, with no one rule ...
Can I come back to previous visualizated list?

[paprita · Accepted solution]

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 ...

[Hemoco]

paprita wrote:

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

Database should be a little faster depending on the hardware used.

[paprita]

Lansweeper wrote:

paprita wrote:

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

Database should be a little faster depending on the hardware used.

Until new servers arrival, db is on a single processor, dual core 3,0 Ghz, 4GB RAM ...

[Hemoco]

For the screenshots, please go into the sql configuration for the lansweeperuser and take some screenshots.

[Hemoco]

Is mixed authentication configured on the SQL server?
(there are some screenshots about this in the documentation)

Please also post a screenshot of the lansweeperuser having access to the lansweeperdb

[paprita]

Lansweeper wrote:
Is mixed authentication configured on the SQL server?
(there are some screenshots about this in the documentation)

Yes

Lansweeper wrote:
Please also post a screenshot of the lansweeperuser having access to the lansweeperdb

What do exactly mean?