I made a mistake somewhere...

[mikepiet]

Dear sir,

I tried to follow the directions as best I could. Not the best with SQl so it took me a while but I can now get the Lansweeper page up, complete with iconology, but my fields all present me with the following...

System.Data.SqlClient.SqlException: Login failed for user 'lsuser'.
at System.Data.SqlClient.ConnectionPool.GetConnection(Boolean& isInTransaction)
at System.Data.SqlClient.SqlConnectionPoolManager.GetPooledConnection(SqlConnectionString
options, Boolean& isInTransaction)
at System.Data.SqlClient.SqlConnection.Open()
at DreamweaverCtrls.DataSet.DoInit()
--------------------------------------------------------------------------------
System.Data.SqlClient.SqlException: Login failed for user 'lsuser'.
at System.Data.SqlClient.ConnectionPool.GetConnection(Boolean& isInTransaction)
at System.Data.SqlClient.SqlConnectionPoolManager.GetPooledConnection(SqlConnectionString
options, Boolean& isInTransaction)
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 'lsuser'.
at System.Data.SqlClient.ConnectionPool.GetConnection(Boolean& isInTransaction)
at System.Data.SqlClient.SqlConnectionPoolManager.GetPooledConnection(SqlConnectionString
options, Boolean& isInTransaction)
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'm not to sure what I have going on here. Any help would be appreciated greatly.

Take care,

Michael

[Hemoco]

this lsuser, is it a sql user or a windows user?
I think it is a windows user.
You have to create a sql user called lsuser (or something others) or use the standard sa account.

[mikepiet]

Hi and thank you for the quick reply. I suppose I do not understand how I am to modify the web.config file. He are the contents of mine...

<configuration>
<appSettings>
<add key="MM_CONNECTION_HANDLER_Lansweeper" value="sqlserver.htm" />
<add key="MM_CONNECTION_STRING_Lansweeper" value="Persist Security Info=False;Data Source=127.0.0.1;Initial Catalog=Lansweeper;User ID=lsuser;Password=Just4now" />
<add key="MM_CONNECTION_DATABASETYPE_Lansweeper" value="SQLServer" />
<add key="MM_CONNECTION_SCHEMA_Lansweeper" value="" />
<add key="MM_CONNECTION_CATALOG_Lansweeper" value="" />
</appSettings>
</configuration>

As you can see, it is in it's original state except for adding in the username,lsuser and my password, Just4now

In regards to the sql authentication, I do have the server set to windows and sql.

Hmmm, sorry I am not getting it.

Michael

[Hemoco]

Have you changed your web.config file?
Is your sql server configured for "windows + sql authentication" or "windows only"?
Maybe you can post your configuration file and your web.config file.