Migrate application and DB to new server

[ratiopharm]

Hello
I wish to move the Lansweeper DB on a PC to server , the server will have a connection to a back end SQL 2005 server. When the application is installed on the new server I need to be able to insure that the application will run with sufficient credentials to be able to scan PC's and servers and that users accesing the web application will be able to use the tools on the action screen without having to use additional credentials. What type of permissions are required by the account on the SQL server.
Thanks in advance

[Hemoco]

Hi,

The account your reference in the config files "svc-lansweeper" is not a windows user but a user on sql server.

You need to create an sql user called svc-lansweeper, give the user the approriate password and enable mixed authentication on your database.

[ratiopharm]

There is a problem with the installer. Please see attched doc , the app is describing that the svc account I am using has no admin priveldge and you can see that it is domain admin account

[ratiopharm]

while trying to add svc-lansweeper to the domain credentials I received this error message and now I cannot delert the user. I am still receiving the

4/22/2009 8:08:44 AM: Cannot connect to database, check your config file, will try again in 1 minute
Login failed for user 'svc-lansweeper'.
4/22/2009 8:09:44 AM: Cannot connect to database, check your config file, will try again in 1 minute
Login failed for user 'svc-lansweeper'.
4/22/2009 8:10:44 AM: Cannot connect to database, check your config file, service will be stopped
Login failed for user 'svc-lansweeper'.


this account is now a domain admin , can I please get an answer as to why this process of connecting the application to another DB server is becoming something of a mess. The user name and password are correct , the service does list that it is started in the services.msc applet. I am able to connect to the DB using the lansweeper configuration application
please see attched doc for error message

[ratiopharm]

I have activated NT authentication on this account in SQL, I am still getting this error


4/21/2009 3:56:59 PM: Cannot connect to database, check your config file, will try again in 1 minute
Login failed for user 'svc-lansweeper'.
4/21/2009 3:57:59 PM: Cannot connect to database, check your config file, will try again in 1 minute
Login failed for user 'svc-lansweeper'.
4/21/2009 3:58:59 PM: Cannot connect to database, check your config file, service will be stopped
Login failed for user 'svc-lansweeper'.


Does the SVC-lansweeper account have to be admin of the SQL server ?? it is already admin on the DB
Thanks

[Hemoco]

Login failed for user 'svc-lansweeper'

Check login/password for the sqluser and make sure mixed mode is enabled.

[ratiopharm]

4/21/2009 9:57:52 AM: Cannot connect to database, check your config file, will try again in 1 minute
Login failed for user 'lansweeperuser'.
4/21/2009 9:58:52 AM: Cannot connect to database, check your config file, will try again in 1 minute
Login failed for user 'lansweeperuser'.
4/21/2009 9:59:52 AM: Cannot connect to database, check your config file, service will be stopped
Login failed for user 'lansweeperuser'.
4/21/2009 10:02:02 AM: Stopping service

4/21/2009 10:03:32 AM: Cannot connect to database, check your config file, will try again in 1 minute
Login failed for user 'svc-lansweeper'.
4/21/2009 10:04:32 AM: Cannot connect to database, check your config file, will try again in 1 minute
Login failed for user 'svc-lansweeper'.
4/21/2009 10:05:32 AM: Cannot connect to database, check your config file, service will be stopped
Login failed for user 'svc-lansweeper'.
4/21/2009 10:09:27 AM: Stopping service

4/21/2009 10:09:33 AM: Cannot connect to database, check your config file, will try again in 1 minute
Login failed for user 'svc-lansweeper'.
4/21/2009 10:10:33 AM: Cannot connect to database, check your config file, will try again in 1 minute
Login failed for user 'svc-lansweeper'.
4/21/2009 10:11:33 AM: Cannot connect to database, check your config file, service will be stopped
Login failed for user 'svc-lansweeper'.

[Hemoco]

Could you post the errors from the errorlog file please

[ratiopharm]

Thanks for the info, the SQL server has these configuration changes , I have modified the lansweepeer.exe.config file as below, the service is not starting

<?xml version="1.0" encoding="UTF-8"?>
<configuration>
<appSettings>
<add key="ConnectionString" value="Persist Security Info=False;Data Source=CA-MIR-SQL01\APPS;Initial Catalog=lansweeperdb;User ID=svc-lansweeper;Password=********;Connect Timeout=120"/>
</appSettings>
</configuration>

[Hemoco]

On page 3 and 4 are the requirements for sql 2005.

You need to start the services and enable the protocols. (shared memory,named pipes,tcp/ip)

You also need to configure the server for mixed authentication (this is not in the documentation because the installer does this)