I don't get it - this just should not be happening. Please let me know, if you ever solve the problem - we have had this very frustrating error for over 1 year now!!! You should try forcing TCP/IP to be used with the Network Library attribute in your connection string.: Network Library=DBMSSOCN;" Bob Barrows Scott Ivey wrote: I changed the connect string to use If you must reply off-line, then remove the "NO SPAM" -- Microsoft MVP - ASP/ASP.NET Please reply to the newsgroup. navigate here

You cannot post or upload images. Also enable TCP/IP and Named Pipes protocols. The ODBC DSN's were system DSN's, and used the DB name, username, & password as above. This tool uses JavaScript and much of it will not work correctly without it enabled.

Ray at work "Savas Ates" wrote in message news:uQ**************@TK2MSFTNGP15.phx.gbl... I've done that. All rights reserved.

And/or using the shorter server name (not sure what you're gaining from revsql01.revonet.local, unless you're trying to practice your typing skills)? The servers are connected to the same Catalyst 2950 switch, and they all have hard wired hosts files - so I can't imagine that resolving the other server is a problem. If you have Windows Firewall enabled, please see the following article: http://technet.microsoft.com/en-us/library/ms175043.aspx Hope this helps. Sql State 08001 I had opened a support incident>>> before posting this, but had opened it with the Cluster group>>> (since the website is on 2 servers running NLBS), and they were>>> unable to

And/or>>>> using the shorter server name (not sure what you're gaining from>>>> revsql01.revonet.local, unless you're trying to practice your>>>> typing skills)? Error 27502 Could Not Connect To Microsoft Sql Server Report Abuse. What is way to eat rice with hands in front of westerners such that it doesn't appear to be yucky? Anyone have any ideas on which group should handle this?

Could not connect to Microsoft SQL Server 'server'. [DBNETLIB][ConnectionOpen(Connect()).]SQL Server does not exist or access denied.(17) This happens during the ISSQLServerValidate custom action of the "SQLLogin" dialog. Sql Server Error 53 And/or using the shorter server name (not sure what you're gaining from revsql01.revonet.local, unless you're trying to practice your typing skills)? And/or using the IP address in the connection string? -- http://www.aspfaq.com/ (Reverse address to reply.) "Scott Ivey" wrote in message news:et**************@TK2MSFTNGP12.phx.gbl...> I haven't changed anything from the default, so yes.>> If so, can your server resolve that name?

Error 27502 Could Not Connect To Microsoft Sql Server

Jul 21 '05 #4 P: n/a Scott Ivey I've tried the following connect strings... "Provider=SQLOLEDB;Data Source=revsql01;Initial Catalog=RPM;User ID=rpmuser;Password=xxxxx" "Provider=SQLOLEDB;Data Source=revsql01.revonet.local;Initial Catalog=RPM;User ID=rpmuser;Password=xxxxx" "Provider=SQLOLEDB;Data Source=revsql01;Initial Catalog=RPM;User ID=rpmuser;Password=xxxxx;Network Library=dbmssocn" "Provider=SQLOLEDB;Data Source=revsql01.revonet.local;Initial Catalog=RPM;User ID=rpmuser;Password=xxxxx;Network When I click ok and 'online help' the link is unresponsive.As I continue the install, the following error occurs:Error 27502. Dbnetlib Connectionopen (connect()). Sql Server Does Not Exist Or Access Denied. 2012 We have 100+ users on the app all day long, and only every once in a while the error happens. Dbnetlib Connectionopen (connect()). Specified Sql Server Not Found The SQL server is locally sitting on the same box so I don't know if firewall will come into play, but we have no control over it as it's locked by

I've also used the Client Network Utility to force TCP/IP, but that didn't help either. check over here If so, I would put an error trap around the open statement in a page, log the error to a text file when it happens and retry opening the connection after Join Now For immediate help use Live now! All I know is that every connection uses the same connect string (application variable in asp), and that the errors are sporadic, but continue to happen on a daily basis, no Error 27502 Could Not Connect To Microsoft Sql Server Login Failed

I had opened a support incident before posting this, but had opened it with the Cluster group (since the website is on 2 servers running NLBS), and they were unable to Error 27502. Scott Jul 22 '05 #33 P: n/a oj Have you looked at this kb: http://support.microsoft.com/default...b;en-us;328306 "Tony Fonager" wrote in message news:eT**************@TK2MSFTNGP09.phx.gbl... his comment is here If you choose to participate, the online survey will be presented to you when you leave the Msdn Web site.Would you like to participate?

This email account is my spam trap>> so I don't check it very often. Error 27502 Sql Server 2012 This email account is my spam trap so I don't check it very often. I had opened a support incident before posting this, but had opened it with the Cluster group (since the website is on 2 servers running NLBS), and they were unable to

Bob Barrows Scott Ivey wrote: anyone heard of this before? And/or using the IP address in the connection string? -- http://www.aspfaq.com/ (Reverse address to reply.) "Scott Ivey" wrote in message news:et**************@TK2MSFTNGP12.phx.gbl... Bob Barrows Scott Ivey wrote: I've tried that, but it didn't help. Cannot Connect To Sql Server A Network Related Or Instance-specific I had opened a support incident before posting this, but had opened it with the Cluster group (since the website is on 2 servers running NLBS), and they were unable to

It could also be the switch going down briefly, or some other network glitch. Scott "Bob Barrows [MVP]" wrote in message news:OQ**************@TK2MSFTNGP09.phx.gbl...> You should try forcing TCP/IP to be used with the Network Library> attribute in your connection string.:>> Network Library=DBMSSOCN;">> Bob Barrows>> Scott Connect with top rated Experts 15 Experts available now in Live! http://cloudbloggers.net/sql-server/sql-server-dbnetlib-error.php This email account is my spam trap so I don't check it very often.

http://support.microsoft.com/default...b;EN-US;328383 Scott "Scott Ivey" wrote in message news:eu**************@TK2MSFTNGP10.phx.gbl... However if I try to connect to the server via Query analyzer, odbc connection or my client software which uses ADO I get :"[Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL Server does not exist Thanks! You can not post a blank message.

Scott Jul 22 '05 #32 P: n/a Tony Fonager Scott, Yes, that is exactly the same way we have this error. And/or using the IP address in the connection string? -- http://www.aspfaq.com/ (Reverse address to reply.) "Scott Ivey" wrote in message news:et**************@TK2MSFTNGP12.phx.gbl... Bob Barrows Scott Ivey wrote: I've tried that, but it didn't help. Also made an ASP page that used the same connect string in a loop to open & close the connection 250k times, and can't reproduce the error.

Connection failed:sqlstate'08001'sqlserver error 17[Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL Server does not exist or access denied."I have checked the firewall is switched off, I can ping the server and I can remote desktop Ray at work "Savas Ates" wrote in message news:uQ**************@TK2MSFTNGP15.phx.gbl... When we moved to the new servers, we also changed the connect strings from using ODBC DSN's to OLEDB connect strings.