ADO.NET connectivity problem with SQL Server !!!
I have a executable (C#) which connects to SQL server and retrieves some information.
There is one setup which has 2 servers. Both of them are Windows 2000 Server and one of them has IIS and the other is a database server (i.e. SQL Server 2000 SP4).
The IIS hosts some ASP pages and few ASP.NET pages. The IIS server also has the executable mentioned above. This executable and ASP.NET pages are NOT able to connect to the SQL Server 2000 however, the ASP pages are able to connect. The error returned is "System.Data.SqlClient.SqlException: SQL Server does not exist or access denied. at System.Data.SqlClient.SqlInternalConnection.OpenAn dLogin()"
The following is the connection string being used:
SERVER=10.10.1.1,1433;UID=xyz;PWD=;Database=NewPvr ;Network Library=dbmssocn;pooling=false;"
This executable and ASP.NET pages works perfectly fine with all the other machines but this one.
I have tried re-installing .Net Framework 1.1 but that too didnot rectify the problem.
Please write back in case any one has any clue on this issue.