Install/configure issues

[EvanSullivan]

I am installing and testing lansweeper on a test domain. I installed 2003 R2 with SQL 2008. I installed lansweeper, documention says to go to http://<servername>:9524 to test if the server is running, but I get page cannot be displayed. I looked in the error log and have this

2/17/2009 9:54:23 AM : Cannot connect to database, check your config file, will try again in 1 minute
-------------------------------------------------------------------------
Login failed for user 'lssqluser32'.
2/17/2009 9:55:23 AM : Cannot connect to database, check your config file, will try again in 1 minute
-------------------------------------------------------------------------
Login failed for user 'lssqluser32'.
2/17/2009 9:56:23 AM : Cannot connect to database, check your config file, service will be stopped
-------------------------------------------------------------------------
Login failed for user 'lssqluser32'.

Before you ask, I did enable remote connections by going into SQL Server Configuration Manager. I follow page 3 and 4 of the docs. Here is my config file

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

Thanks for any help

[Hemoco]

Try to change the authentication to "mixed authentication" first
The username : lssqluser32
password : mysecretpassword0*

[EvanSullivan]

Lansweeper wrote:
Try to change the authentication to "mixed authentication" first
The username : lssqluser32
password : mysecretpassword0*

Thanks, I just installed 2005 and it works awesome.

[Hemoco]

At this moment our installer doesn't support sql 2008 express.

When you open the sql management console, are you able to connect to "evanserver\SQLEXPRESS" with username lssqluser32?

[EvanSullivan]

Lansweeper wrote:
At this moment our installer doesn't support sql 2008 express.

When you open the sql management console, are you able to connect to "evanserver\SQLEXPRESS" with username lssqluser32?

Oh crap Im' sorry, didn't know that.

You mean the Lan Sweeper managemnet console? I can login ONLY if I "use integrated authentication".

I can just start over and use 2005, it's a VMWARE test domain. Unless you want to troubleshoot to help support 2008?

Also what is the default password for that user?

[EvanSullivan]

I get this when I go to the web console:

System.Data.SqlClient.SqlException: Login failed for user 'lssqluser32'.
at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
at System.Data.SqlClient.SqlInternalConnectionTds.CompleteLogin(Boolean enlistOK)
at System.Data.SqlClient.SqlInternalConnectionTds.AttemptOneLogin(ServerInfo serverInfo, String newPassword, Boolean ignoreSniOpenTimeout, Int64 timerExpire, SqlConnection owningObject)
at System.Data.SqlClient.SqlInternalConnectionTds.LoginNoFailover(String host, String newPassword, Boolean redirectedUserInstance, SqlConnection owningObject, SqlConnectionString connectionOptions, Int64 timerStart)
at System.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(SqlConnection owningObject, SqlConnectionString connectionOptions, String newPassword, Boolean redirectedUserInstance)
at System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, Object providerInfo, String newPassword, SqlConnection owningObject, Boolean redirectedUserInstance)
at System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection)
at System.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConnection owningConnection, DbConnectionPool pool, DbConnectionOptions options)
at System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection owningObject)
at System.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection owningObject)
at System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject)
at System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection)
at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory)
at System.Data.SqlClient.SqlConnection.Open()
at DreamweaverCtrls.DataSet.DoInit()
--------------------------------------------------------------------------------
System.Data.SqlClient.SqlException: Login failed for user 'lssqluser32'.
at System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject)
at System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection)
at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory)
at System.Data.SqlClient.SqlConnection.Open()
at DreamweaverCtrls.DataSet.DoInit()
--------------------------------------------------------------------------------
System.Data.SqlClient.SqlException: Login failed for user 'lssqluser32'.
at System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject)
at System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection)
at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory)
at System.Data.SqlClient.SqlConnection.Open()
at DreamweaverCtrls.DataSet.DoInit()
--------------------------------------------------------------------------------
System.Data.SqlClient.SqlException: Login failed for user 'lssqluser32'.
at System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject)
at System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection)
at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory)
at System.Data.SqlClient.SqlConnection.Open()
at DreamweaverCtrls.DataSet.DoInit()
--------------------------------------------------------------------------------
System.Exception: The DefaultView was requested but no tables yet exist.
at DreamweaverCtrls.DataSet.get_DefaultView()
--------------------------------------------------------------------------------
System.Data.SqlClient.SqlException: Login failed for user 'lssqluser32'.
at System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject)
at System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection)
at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory)
at System.Data.SqlClient.SqlConnection.Open()
at DreamweaverCtrls.DataSet.DoInit()
--------------------------------------------------------------------------------
System.Exception: The DefaultView was requested but no tables yet exist.
at DreamweaverCtrls.DataSet.get_DefaultView()

I figure its todo with not connecting to SQL, but not sure if there is info in here that might be helpful.