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
Sorry for the late reply, normally we reply within a day.
Don't know why this happened.

To make the service work:
There are 2 config files : Lansweeperservice.exe.config and web.config.
They both contain the connectionstring information to connect to the database. (server,databasename,username,password)

You can configure these config files how you like but the default values for version 3.5 are:
database: lansweeperdb
user: lansweeperuser
password: mysecretpassword0*

The service account for the service must be administrator on the scanned computers (typically a domain administrator)
ratiopharm
Engaged Sweeper
I guess I should thank you for answering the question. I have a maintenance window every 3rd sunday of the month to make changes . I don't expect you to know that but taking 4 days to answer a question that if I am not mistaken is not in your documentation is kind of a pissoff. Does the user have to be named lansweeperuser ?? can it be svc-lansweeper ( we have naming conventions )? are there any other secret parameters that I need to know to make this work ??
Hemoco
Lansweeper Alumni
If you use the latest installer your databasename should be "lansweeperdb"

If you moved the database to another server create a user : "lansweeperuser" with default password "mysecretpassword0*" (without the quotes) and make the user owner of the lansweeper database.
ratiopharm
Engaged Sweeper
I am installing on a new machine , I am attempting to link to the DB i have moved to another server. The DB names has not changed and the service account created is the DB owner , see attched doc foe error message
ratiopharm
Engaged Sweeper
Hello
I have moved the DB to another server, using the lansweeper managment console ( GUIConsole) to connect to the DB I get a failed connect message. what are the requierements for the mamngement console to be able to connect to the DB on another server
Thanks