467,917 Members | 1,319 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 467,917 developers. It's quick & easy.

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!
Oct 10 '08 #1
  • viewed: 952
Share:

Post your reply

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

Similar topics

5 posts views Thread by Dave Dudley | last post: by
3 posts views Thread by sammyloo | last post: by
5 posts views Thread by Mitya Mitriev | last post: by
6 posts views Thread by Todd Brewer | last post: by
3 posts views Thread by Me LK | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.