Community FAQ
cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
ratiopharm
Engaged Sweeper
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
14 REPLIES 14
Hemoco
Lansweeper Alumni
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
Engaged Sweeper
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
Engaged Sweeper
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
Engaged Sweeper
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
Lansweeper Alumni
Login failed for user 'svc-lansweeper'

Check login/password for the sqluser and make sure mixed mode is enabled.
ratiopharm
Engaged Sweeper
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
Lansweeper Alumni
Could you post the errors from the errorlog file please
ratiopharm
Engaged Sweeper
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
Lansweeper Alumni
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)

Archive

This board contains archived posts from the retired Lansweeper Forum and Insiders Community.

New to Lansweeper?

Try Lansweeper For Free

Experience Lansweeper with your own data.
Sign up now for a 14-day free trial.

Try Now