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:
< xml version="1.0" >
<configuration xmlns=" http://www.hide-link.com/ ">
<connectionStrings>
<add name="MyConnectionString" connectionString="Data Source=MYSERVER;Initial Catalog=mydatabase;Integrated Security=SSPI"
providerName="System.Data.SqlClient"/>
</connectionStrings>
<system.web>
<customErrors mode="Off"/>
<compilation debug="true">
<assemblies>
<add assembly="System.Design, Version=2.0.0.0, Culture=neutral, PublicKeyToken=B03F5F7F11D50A3A"/>
<add assembly="System.Windows.Forms, Version=2.0.0.0, Culture=neutral, PublicKeyToken=B77A5C561934E089"/>
</assemblies>
</compilation>
<identity impersonate="true"/>
<authentication mode ="Windows"/>
<authorization>
<deny users=" "/>
</authorization>
</system.web>
</configuration>
Any comments or suggestions would be greatly appreciated.
Thank you,
Inti
.NET Development23
|