Error 80004005 Sql Server Does Not Exist Or Access Denied
Contents |
here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss the workings and policies of this site About
Sql Server Does Not Exist Or Access Denied Sql Express 2012
Us Learn more about Stack Overflow the company Business Learn more about hiring sql server does not exist or access denied 17 developers or posting ads with us Stack Overflow Questions Jobs Documentation Tags Users Badges Ask Question x Dismiss Join the odbc sql server driver sql server does not exist or access denied Stack Overflow Community Stack Overflow is a community of 4.7 million programmers, just like you, helping each other. Join them; it only takes a minute: Sign up Microsoft OLE DB Provider for https://support.microsoft.com/en-us/kb/328306 SQL Server error '80004005' up vote 5 down vote favorite I have migrated a classic ASP site to a new server and am getting the following error, message. I have tried different connection strings but none of them work. I am not even sure if the connection string is the problem The new server is a Windows 2012 Server, SQL Server 2008 R2 Express machine. Microsoft http://stackoverflow.com/questions/15126625/microsoft-ole-db-provider-for-sql-server-error-80004005 OLE DB Provider for SQL Server error '80004005' [DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied. /scripts/dbcode.asp, line 31 Application("C2M_ConnectionString") = "Provider=SQLNCLI10;Server=(local);Database=mysite_live;Uid=mysitec_Live;Pwd=mypass;" sql sql-server sql-server-2008 asp-classic share|improve this question edited Feb 28 '13 at 3:42 Hiten004 1,710927 asked Feb 28 '13 at 2:52 Burt 4,5651251108 1 What is at scripts/dbcode.asp, line 31? –Mike C. Mar 4 '13 at 0:11 1 can it be 32/64 bit incompatibility? please look here:link –Dalex Mar 4 '13 at 20:19 @Dalex thanks for the help, I followed the instructions from your link but still no luck. Any other ideas? –Burt Mar 5 '13 at 1:58 1 Just curious, is the old server still running? Does it work on the old server / did it work? If so, what version of IIS was on the old server? Did you migrate SQL Server as well? What was the old SQL Server version it was using? –Mike C. Mar 5 '13 at 14:11 1 Have you looked in your SQL Server Error Logs? What do those logs say? Any login/authorization failures? –JodyT Mar 9 '13 at 23:06 | show 4 more comments 11 Answers 11 active olde
SQL Server experts to answer whatever question you can come up with. Our new SQL http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=187184 Server Forums are live! Come on over! We've restricted the ability to create new threads on these forums. SQL Server Forums Profile | ActiveTopics | Members | Search | ForumFAQ Register Now and get your question answered! Username: Password: Save Password Forgot your Password? All Forums SQL Server 2008 Forums SQL Server Administration (2008) SQL Server does sql server not exist or access denied. Reply to Topic Printer Friendly Next Page Author Topic Page: 1 2 of 2 astralis Yak Posting Veteran USA 62 Posts Posted-07/29/2013: 13:50:00 I have troubleshooted this for a while so I don't understand it.This 2008 Express DB has not changed for a while, then suddenly I am receiving this sql server does error and can't figure out what is wrong.I can still access the site via Management Studio, though, using the same username and password.Microsoft OLE DB Provider for SQL Server error '80004005'[DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied./inc_db_setup.asp, line 10Line 10 is the last line (fixed for clarity):strBFCon = "Provider=SQLOLEDB;Data Source=REDACTED IP,PORT;database=redacted;uid=redacted;pwd=redacted;"Set adoCon = Server.CreateObject("ADODB.Connection")adoCon.connectionstring = strBFConadoCon.Open 'LINE 101. The Firewall has not changed.2. TCP/IP and Named Pipes are enabled.3. The SQL Server events do not point to any issues.4. Windows events log does not point to any issues.Please advise. Edited by - astralis on 07/29/2013 14:07:18 tkizer Almighty SQL Goddess USA 38200 Posts Posted-07/29/2013: 14:02:45 Data Source should be ServerName,Port if you are specifying the SQL listening port in there.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/Subscribe to my blog Edited by - tkizer on 07/29/2013 14:02:57 astralis Yak Posting Veteran USA 62 Posts Posted-07/29/2013: 14:05:42 Yes, that's what I've been doing. I've used this same connection string for years