Lansweeper logo
Home Download Features Demo Buy now Help Support forum
 
    Most requested support articles:
  Lansweeper troubleshooting guide.
  The RPC server is unavailable. (Exception from HRESULT: 0x800706BA)
  WMI Access is denied. (Exception from HRESULT: 0x80070005 (E_ACCESSDENIED))
  How to configure the windows firewall using group policies.
  Support:  
 support@lansweeper.com  
Skype: Lansweeper  
  Mo-Fri 9h-17h CET  
Welcome Guest Search | Active Topics | Log In | Register

Tag as favorite
Install/configure issues
Options
Previous Topic Next Topic
EvanSullivan
#1 Posted : Tuesday, February 17, 2009 5:20:37 PM
Rank: Freeware user

Groups: Member
Posts: 4
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

Quote:

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

Quote:

<?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
Back to top
| Edit by user
EvanSullivan
#2 Posted : Tuesday, February 17, 2009 5:52:46 PM
Rank: Freeware user

Groups: Member
Posts: 4
I get this when I go to the web console:

Quote:

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.
Back to top
Lansweeper
#3 Posted : Tuesday, February 17, 2009 7:29:05 PM

Rank: Administration

Groups: Administration, Premium Users
Posts: 10,378
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?
Back to top
EvanSullivan
#4 Posted : Tuesday, February 17, 2009 8:00:04 PM
Rank: Freeware user

Groups: Member
Posts: 4
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?
Back to top
| Edit by user
Lansweeper
#5 Posted : Tuesday, February 17, 2009 10:01:03 PM

Rank: Administration

Groups: Administration, Premium Users
Posts: 10,378
Try to change the authentication to "mixed authentication" first
The username : lssqluser32
password : mysecretpassword0*
Back to top
EvanSullivan
#6 Posted : Tuesday, February 17, 2009 10:08:39 PM
Rank: Freeware user

Groups: Member
Posts: 4
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.
Back to top
Users browsing this topic
Guest
Tag as favorite
Forum Jump  
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.

Contact: E-mail Lansweeper - Skype : Lansweeper
Copyright 2004 - 2011 © Hemoco bvba