By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,575 Members | 1,948 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,575 IT Pros & Developers. It's quick & easy.

SQL Server 2000 - OLE DB string connection

P: 9
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!
Oct 10 '08 #1
Share this question for a faster answer!
Share on Google+

Post your reply

Sign in to post your reply or Sign up for a free account.