Problem with SQL Server 2005 and IIS 6.0

Hello,

I am having problems with my system configuration. I am trying to access a SQL Server 2005 database from a C# .NET web page, but I keep getting this error, "Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'".I am using windows authentication. The SQL Server resides on one server and my web server is on a different server. If I run the both the web server and SQL Database from within the same server it works fine, the problem comes when I separate the servers.

I am running Windows Server 2003 on both servers, MS SQL Server 2005, MS Visual Studios 2005, and IIS 6.0.

Here is my Web.Config file:

<?xmlversion="1.0"?>

<configurationxmlns="http://schemas.microsoft.com/.NetConfiguration/v2.0">

<connectionStrings>

<addname="MyConnectionString"connectionString="Data Source=MYSERVER;Initial Catalog=mydatabase;Integrated Security=SSPI"

providerName="System.Data.SqlClient"/>

</connectionStrings>

<system.web>

<customErrorsmode="Off"/>

<compilationdebug="true">

<assemblies>

<addassembly="System.Design, Version=2.0.0.0, Culture=neutral, PublicKeyToken=B03F5F7F11D50A3A"/>

<addassembly="System.Windows.Forms, Version=2.0.0.0, Culture=neutral, PublicKeyToken=B77A5C561934E089"/>

</assemblies>

</compilation>

<identityimpersonate="true"/>

<authenticationmode ="Windows"/>

<authorization>

<denyusers="?"/>

</authorization>

</system.web>

</configuration>

Any comments or suggestions would be greatly appreciated.

Thank you,

Inti

[9580 byte] By [inti] at [2007-12-25]