Webconfig

[mattgbarnes]

I tried to follow this guide to lock down security to domain admins only:

http://www.lansweeper.com/kb/restrict.aspx

Now I'm unable to get in to the site:

System.Data.SqlClient.SqlException: Login failed for user 'lansweeperuser'.
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()

This is my web.config file

<configuration>
<appSettings>
<add key="MM_CONNECTION_HANDLER_Lansweeper" value="sqlserver.htm"/>
<add key="MM_CONNECTION_STRING_Lansweeper" value="Persist Security Info=False;Data Source=069-sql;Initial Catalog=lansweeperdb;User ID=lansweeperuser;Password=*****;Connect Timeout=120"/>
<add key="MM_CONNECTION_DATABASETYPE_Lansweeper" value="SQLServer"/>
<add key="MM_CONNECTION_SCHEMA_Lansweeper" value=""/>
<add key="MM_CONNECTION_CATALOG_Lansweeper" value=""/>
</appSettings>
<system.web>
<compilation debug="true" strict="false" explicit="true"/>
</system.web>
</configuration>

Please help.

[NeilL]

mattgbarnes wrote:
I tried to follow this guide to lock down security to domain admins only:

http://www.lansweeper.com/kb/restrict.aspx

<configuration>
<appSettings>
<add key="MM_CONNECTION_HANDLER_Lansweeper" value="sqlserver.htm"/>
<add key="MM_CONNECTION_STRING_Lansweeper" value="Persist Security Info=False;Data Source=069-sql;Initial Catalog=lansweeperdb;User ID=lansweeperuser;Password=*****;Connect Timeout=120"/>
<add key="MM_CONNECTION_DATABASETYPE_Lansweeper" value="SQLServer"/>
<add key="MM_CONNECTION_SCHEMA_Lansweeper" value=""/>
<add key="MM_CONNECTION_CATALOG_Lansweeper" value=""/>
</appSettings>
<system.web>
<compilation debug="true" strict="false" explicit="true"/>
</system.web>
</configuration>

Please help.

Your missing this

</appSettings>
<system.web>
<authentication mode="Windows"/>
<identity impersonate="true" />
<authorization>
<allow roles="domain\allowed group" />
<deny users="*" />
</authorization>