Having difficulty once migrated to premium

[dennisatsub]

I had the FREE version of Lansweeper working...using LSCLIENT to scan for me but when I went through the pdf document word for word I came out scanning nothing on my network.


I can no longer get to the webconsole, I can't scan anything on my network and my error log looks like this:

A little help please

1/12/2009 1:12:43 PM : Cannot connect to database, check your config file, will try again in 1 minute
-------------------------------------------------------------------------
An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)
1/12/2009 1:14:04 PM : Cannot connect to database, check your config file, will try again in 1 minute
-------------------------------------------------------------------------
An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)
1/12/2009 1:15:24 PM : Cannot connect to database, check your config file, service will be stopped
-------------------------------------------------------------------------
An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)
1/12/2009 1:36:50 PM : Stopping service

1/12/2009 1:37:10 PM : Cannot connect to database, check your config file, will try again in 1 minute
-------------------------------------------------------------------------
An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)
1/12/2009 1:38:24 PM : Cannot connect to database, check your config file, will try again in 1 minute
-------------------------------------------------------------------------
An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)
1/12/2009 1:39:39 PM : Cannot connect to database, check your config file, service will be stopped
-------------------------------------------------------------------------
An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)

[dennisatsub]

To answer your question, I did add the active scan key.

My issue was that my SQL account was set to a default pwd and I had reset it.
Once I changed it in my config files to match my SQL account info (DUH!) and restarted the SQL and LS services---MAGIC happened. My network is being scanned as I type.

Thanks for the very quick response LS!!

Dennis

[Hemoco]

So you followed step 1 to 5 and not 6 correct?
Which error do you get when going to the webconsole?
Are you sure that your sqlserver is still running?

[dennisatsub]

I didn't change anything, I wanted to go with the defaults and make sure wverything worked before I went and changed anything.

[Hemoco]

So, did you actually change something to the lansweeperservice.exe.config file? (the only difference I see is the password)
Is the name of your config file correct?

[dennisatsub]

These are the steps I was given
Upgrade of the service
1. Make sure your lansweeper service is stopped
2. Delete the old errorlog.txt in the service folder
3. Copy the new lansweeperservice.exe to you service folder
4. Delete the old service file if it exists (lansweeper3x.exe)
5. Rename your config file to lansweeperservice.exe.config (instead of lansweeper3x.exe.config)
6. Add the following line to your lansweeperservice.exe.config file to enable active scanning
(after the line with listenport)
<add key="Activescanning" value="1" />
(change "0" to "1" to enable or disable)
A complete config file should look something like this:
<?xml version="1.0" encoding="utf-8"?>
<configuration>
<appSettings>
<add key="ConnectionString" value="Persist Security Info=False;Data Source=myserver\sqlexpress;
Initial Catalog=Lansweeper;User ID=lssqluser;Password=mysecretpassword" />
<add key="ConcurrentThreads" value="10" />
<add key="ListenPort" value="9524" />
<add key="Activescanning" value="1" />
</appSettings>
</configuration>


and here are the files
New config:

<?xml version="1.0" encoding="UTF-8"?>
<configuration><appSettings><add key="ConnectionString" value="Persist Security Info=False;Data Source=BOLIC01\SQLEXPRESS;Initial Catalog=Lansweeper32;User ID=lssqluser32;Password="/><add key="ConcurrentThreads" value="20"/><add key="ListenPort" value="9524"/><add key="Activescanning" value="1"/></appSettings></configuration>


old config:
<?xml version="1.0" encoding="UTF-8"?>
<configuration><appSettings><add key="ConnectionString" value="Persist Security Info=False;Data Source=BOLIC01\SQLEXPRESS;Initial Catalog=Lansweeper32;User ID=lssqluser32;Password=mysecretpassword0*"/><add key="ConcurrentThreads" value="20"/><add key="ListenPort" value="9524"/><add key="Activescanning" value="1"/></appSettings></configuration>

[Hemoco]

Which steps did you do for the upgrade?
Could you attach your old lansweeperservice.exe.config file and your changed one please.