Small Business Server 2003 + Lansweeper

[da_Michael]

I have a trouble with configuring webconsole (web.config) for access my MSSQL2005EE. On this machine also running 3 instances of MSDE2000

there is my web.config

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

there is what IE says

System.Data.SqlClient.SqlException: Недопустимое соединение.
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()

Any ideas?

[da_Michael]

2 Smikkel:

Bingo! Yep, there was a 100% right answer, TNX.

[Hemoco]

Yep, your probably running a named instance of MSDE/SQL, so you should specify the correct name as your datasource

Wrong : Data Source=192.168.0.109 (this would work if you didn't have named instances)

Correct : Data Source=192.168.0.109\name_of_your_instance