SQL Server 2000 - OLE DB string connection

[borisding]

Hi all,

I have recently migrated ASP application from Windows server 2000 to 2003. But failed to connect to SQL Server 2000. (Both sql server and application are on the same server)

I keep getting this error message when trying to connect to SQL Server 2000 from application:

Microsoft OLE DB Provider for SQL Server error '80004005'

[DBNETLIB][ConnectionOpen (Connect()).]Specified SQL server not found.

Basically i'm using OLE connection, and my connection string in my script looks something as follows:

Provider=SQLOLEDB.1;Password=xxxxx;Persist Security Info=True;User ID=xxxxx;Initial Catalog=xxxxx;Data Source=ServerName

I have tested the connection in .udl file, and the connection shows successfully.

And, I've checked there is no Firewall or Antivirus/Security program is blocking the port 1433.
Both TCP/IP and Named Pipes have been enabled for Client and Server Network Ultility as well.
Some more, I have checked with the SQL server log files, and it's listening to named pipes successfully during connection. I tried to put the server ip address for Data Source instead of servername, but still couldn't get it.

Can someone lets me know what would be the causes, I'm unable to connect to sql server and keep getting the error message as above? Pls help!

Thanks in advance!

[shweta123]

Hi,

Please refer this Article for solving the connection error you are getting in your application.

[DrBunchman]

Can you ping the SQL Server from the IIS server?

Dr B