Odbc Error 11004
Contents |
Recent PostsRecent Posts Popular TopicsPopular Topics Home Search Members Calendar Who's On Home » SQL Server 7,2000 » Administration » URGENT: Error 11004 When Connected Via VPN URGENT: Error 11004 When Connected Via VPN Rate sql state 08001 error 17 Topic Display Mode Topic Options Author Message garyjh00garyjh00 Posted Thursday, March 25, 2004 1:37 PM Forum odbc connection to sql server failed Newbie Group: General Forum Members Last Login: Friday, March 26, 2004 7:56 AM Points: 2, Visits: 1 Ihave a remote user connected to our sqlstate 01000 sql server error 2 server via VPN. Whenver he tries to create an ODBC connection to our SQL Server, he get this error:Connection failed: SQL State: '01000' SQL Server Error: 11004 [Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]ConnectionOpen (Connect()). Connection Failed: SQL State: '08001' SQL Server
Sqlstate 01000 Sql Server Error 53
Error: 6 [Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]Specified SQL server not found. He is using the IP address when referencing the server.Can anyone shed light on this problem?Thanks!! Post #108288 Rodrigo AcostaRodrigo Acosta Posted Thursday, March 25, 2004 1:49 PM SSCommitted Group: General Forum Members Last Login: Thursday, May 21, 2015 7:40 AM Points: 1,581, Visits: 8 Did you try creating an alias in the client pc,from the Client Network Utility?Specify the ip adress in the servername and in the alias connection failed sqlstate 01000 sql server error 10060 the real name of the server. Post #108291 garyjh00garyjh00 Posted Thursday, March 25, 2004 2:47 PM Forum Newbie Group: General Forum Members Last Login: Friday, March 26, 2004 7:56 AM Points: 2, Visits: 1 Yes... the client network utility is configured. Post #108299 John PfefferJohn Pfeffer Posted Thursday, March 25, 2004 6:20 PM SSC Rookie Group: General Forum Members Last Login: Wednesday, July 6, 2005 1:22 PM Points: 29, Visits: 1 not to ask a dumb question but is he using the true ip of the server? rathe than a NAT address? can he use enterprise manager or query analyzer ok? Post #108354 bjkramebjkrame Posted Friday, March 26, 2004 7:32 AM Old Hand Group: General Forum Members Last Login: Saturday, February 2, 2008 3:59 PM Points: 316, Visits: 10 Not 100% sure, but make sure your WAN administrator is allowing traffic on Port 1434 on the firewall. BK Post #108466 « Prev Topic | Next Topic » Permissions You cannot post new topics. You cannot post topic replies. You cannot post new polls. You cannot post replies to polls. You cannot edit your own topics. You cannot delete your own topics. You cannot edit other topics. You cannot delete other topics. You cannot edit your own posts. You cannot edit other posts. You cannot delete your own posts. You cannot delete other posts. You cannot post events. You cannot edit your own events. You cannot edit other events. Y
SQL Server experts to answer whatever question you can come up with. Our new SQL Server Forums are sql server error 14 live! Come on over! We've restricted the ability to create new threads
Sql Server Error 6
on these forums. SQL Server Forums Profile | ActiveTopics | Members | Search | ForumFAQ Register Now and
Sqlstate 08001 Sql Server Error 2
get your question answered! Username: Password: Save Password Forgot your Password? All Forums SQL Server 2005 Forums SQL Server Administration (2005) ODBC Connection Reply to Topic Printer Friendly Author Topic http://www.sqlservercentral.com/Forums/Topic108288-5-1.aspx petek Posting Yak Master United Kingdom 192 Posts Posted-01/22/2009: 08:17:08 Hi all,I cannot connect to my SQL Server. i need to create a ODBC connection but it fails.Microsoft SQL Server Login---------------------------Connection failed:SQLState: '01000'SQL Server Error: 11004[Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionOpen (Connect()).Connection failed:SQLState: '08001'SQL Server Error: 6[Microsoft][ODBC SQL Server Driver][DBNETLIB]Specified SQL server not found.Connection failed: SQL State: '01000' SQL http://www.sqlteam.com/forums/topic.asp?topic_id=118390 Server Error: 11004 [Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]ConnectionOpen (Connect()). Connection Failed: SQL State: '08001' SQL Server Error: 6 [Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]Specified SQL server not found. the server is there and i can connect to it locally but not from remote connections.i have checked surface area configuration and it allows remote connections.any ideas??Kind RegardsPete. petek Posting Yak Master United Kingdom 192 Posts Posted-01/22/2009: 08:49:52 SQL Browser was disabledKind RegardsPete. Topic Reply to Topic Printer Friendly Jump To: Select Forum General SQL Server Forums New to SQL Server Programming New to SQL Server Administration Script Library Data Corruption Issues Database Design and Application Architecture SQL Server 2012 Forums Transact-SQL (2012) SQL Server Administration (2012) SSIS and Import/Export (2012) Analysis Server and Reporting Services (2012) Replication (2012) Availability Groups and DR (2012) Other SQL Server 2012 Topics SQL Server 2008 Forums Transact-SQL (2008) SQL Server Administration (2008) SSIS and Import/Export (2008) High Availability (2008) Replication (2008) Analysis Server and Reporting Services (2008) Other SQL Server 2008 Topics SQL Server 2005 Forums Transact-SQL (2005) SQL Server
(Русский)ישראל (עברית)المملكة العربية السعودية (العربية)ไทย (ไทย)대한민국 (한국어)中华人民共和国 (中文)台灣 (中文)日本 (日本語) HomeLibraryLearnDownloadsTroubleshootingCommunityForums Ask a question Quick access Forums home Browse forums users FAQ https://social.msdn.microsoft.com/Forums/sqlserver/en-US/306f45ad-1e5a-4afd-8f57-222c4b686df0/the-specified-sql-server-could-not-be-found?forum=sqldatabaseengine Search related threads Remove From My Forums Answered by: The specified SQL Server could not be found? SQL Server > SQL Server http://www.apc.com/support/index?page=content&country=ITB&lang=en&locale=en_US&id=FA212127 Database Engine Question 0 Sign in to vote Ihave installedSQL Server 2005 , Nov RTM (from MSDN) on Win XP Pro sql server machine as a named instance.If I try to connect to it from a remote machine (either using Management Studio 2005 or by trying to create a DSN), it throws up the following message:--------------------------- Microsoft SQL Server Login --------------------------- Connection failed: SQLState: '01000' sql server error SQL Server Error: 11004 [Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionOpen (Connect()). Connection failed: SQLState: '08001' SQL Server Error: 6 [Microsoft][ODBC SQL Server Driver][DBNETLIB]Specified SQL server not found. --------------------------- OK --------------------------- Yes, I have checked that in SQL Server Configuration Manager, TCP/IP is enabled under both (Network configuration for the named instance ANDSql Native Client Configuration).SQL Server named instance is running under NETWORK SERVICE account.Please note that local connections work.Any help / pointers on this will be appreciated.Hereare the error.log contents:2005-11-09 09:27:35.81 Server Microsoft SQL Server 2005 - 9.00.1399.06 (Intel X86) Oct 14 2005 00:33:37 Copyright (c) 1988-2005 Microsoft CorporationDeveloper Edition on Windows NT 5.1 (Build 2600: Service Pack 2) 2005-11-09 09:27:35.84 Server (c) 2005 Microsoft Corporation.2005-11-09 09:27:35.84 Server All rights reserved.2005-11-09 09:27:35.84 Server Server process ID is 1400.2005-11-