Lansweeper Service Running - 9254 not listening on netstat

[MatthewNos]

I've used netstat -a to see if 9254 was listening , it is not. I've checked services and the lansweeper service is running.
I did the upgrade properly from freeware to premium with no problems.
My error log reads as follows :

1/22/2009 1:15:57 PM : Database connection successful, starting up service

1/22/2009 1:30:35 PM : Cannot connect to database, check your config file, will try again in 1 minute
-------------------------------------------------------------------------
Cannot open database "Lansweeper32" requested by the login. The login failed.
Login failed for user 'lssqluser32'.
1/22/2009 1:31:36 PM : Database connection successful, starting up service

1/22/2009 1:54:42 PM : Stopping service

1/22/2009 2:02:18 PM : Cannot connect to database, check your config file, will try again in 1 minute
-------------------------------------------------------------------------
A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)
1/22/2009 2:03:33 PM : Cannot connect to database, check your config file, will try again in 1 minute
-------------------------------------------------------------------------
A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)
1/22/2009 2:04:47 PM : Cannot connect to database, check your config file, service will be stopped
-------------------------------------------------------------------------
A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)

I have pipes enabled as well as TCP/IP
I can log into the GUI using integrated login,
The connection Tester works :
Ping test OK
-----------------------------------------------
Remote registry test OK
-----------------------------------------------
Remote WMI access test OK
-----------------------------------------------
Remote \\127.0.0.1\c$ access test OK

Here is my command line :
C:\Program Files\lansweeper32\lslcient>lsclient server
Lansweeper client
-----------------
Connecting...
Failed

C:\Program Files\lansweeper32\lslcient>lsclient IP
Lansweeper client
-----------------
Connecting...
Failed

C:\Program Files\lansweeper32\lslcient>lsclient server.domain.com
-----------------
Connecting...
Failed

I can log into the web browser using
http://server/lansweeper32/

What am I doing wrong? I can't seem to find the answer in the forum that fits.
I am using SQL Express 2005.
I have tried 2008 and had more problems, so i reverted to 2005.
Suggestions?

[Hemoco]

Could you check the following.

Login to your sql server "nike\sqlexpress"
Verify that you have a database called Lansweeper32
Verify that you have a user called lssqluser32
Verify that this user is owner of the lansweeper32 database.

(Post screenshots if possible)

[MatthewNos]

1/26/2009 10:07:22 AM : Cannot connect to database, check your config file, will try again in 1 minute
-------------------------------------------------------------------------
Login failed for user 'lssqluser32'.
1/26/2009 10:08:17 AM : Cannot connect to database, check your config file, will try again in 1 minute
-------------------------------------------------------------------------
Login failed for user 'lssqluser32'.
1/26/2009 10:09:11 AM : Cannot connect to database, check your config file, service will be stopped
-------------------------------------------------------------------------
Login failed for user 'lssqluser32'.

[Hemoco]

Could you please post your errorlog.txt file please after restarting the service.

[MatthewNos]

I've got the new config file in place and restarted the server.
It still fails upon lsclient. Would it be prudent to reinstall from scratch using your config file?

[Hemoco]

Please use this config file, that should do the trick

[MatthewNos]

No i didn't blank it, this was what came default. i didn't change anything, set everything to default.
However, I have progressively been making changes as you suggest them and retrying.
Here is my web.config file
added password to config file.

[Hemoco]

Did you blank out the password in this config file?

Could you please also attach your web.config file please.

[MatthewNos]

127.0.0.1\SQLEXPRESS is the proper name for the database.
I don't know why it says that either.
I am re-attaching the zip file.

[Hemoco]

I'm trying to understand why the database is called "Lansweeper" in your config file.
Was this something that you changed for testing?

Did you download the installer from our website?

What is the exact database server name (127.0.0.1\SQLEXPRESS) ?
Did you make any changes in the config file for this?

When you connect to the database server, what is the correct name of your database?

You can zip the config file and then attach it.