webconfig Windows authentication settings

[kickboxer]

Hi

I'm trying to configure 3.5 to use Windows Authentication (had it working on version 3.1). The SQL database is on a different server to the web server. This used to work,
<configuration>
<system.web>
<customErrors mode="Off"/>
<compilation debug="true"/>
</system.web>
<appSettings>
<add key="MM_CONNECTION_HANDLER_Lansweeper" value="sqlserver.htm"/>
<add key="MM_CONNECTION_STRING_Lansweeper" value="Integrated Security=SSPI;Persist Security Info=False;Data Source=mrsdoyle;Initial Catalog=Lansweeper"/>
<add key="MM_CONNECTION_DATABASETYPE_Lansweeper" value="SQLServer"/>
<add key="MM_CONNECTION_SCHEMA_Lansweeper" value=""/>
<add key="MM_CONNECTION_CATALOG_Lansweeper" value=""/>
</appSettings>
</configuration>

We only have 1 web site running on the web server, PC clients can attach to the database ok. We are using Windows Integrated security on the website but get the following error,


System.Data.SqlClient.SqlException: Cannot open database "lansweeperdb" requested by the login. The login failed.
Login failed for user 'NT AUTHORITY\NETWORK SERVICE'.
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()

thanks
kickboxer

[Hemoco]

Give the 'NT AUTHORITY\NETWORK SERVICE' account access to the database, or run the website using another account and give this account access to the DB