Cannot Connect To Microsoft Sql Server Error 53
Contents |
here for a quick overview of the site Help Center Detailed answers to any questions you might have microsoft sql server error 53 2012 Meta Discuss the workings and policies of this site About Us Learn
Ms Sql Server Error 53
more about Stack Overflow the company Business Learn more about hiring developers or posting ads with us sql server error 53 could not open a connection Stack Overflow Questions Jobs Documentation Tags Users Badges Ask Question x Dismiss Join the Stack Overflow Community Stack Overflow is a community of 4.7 million programmers, just like microsoft sql server error 40 you, helping each other. Join them; it only takes a minute: Sign up Cannot connect to remote SQL Database with SQL Server Management Console (Error 53) up vote 3 down vote favorite I have opened up port 1433 on my firewall, but every time I try and connect to my remote SQL Database with SQL Server
Sql Server Error 53 And 17
Management Console I receive (Microsoft SQL Server, Error: 53) sql-server share|improve this question asked May 8 '13 at 16:05 e-zero 892514 1 is tcp/ip enabled in the db? it may be using named pipes only (or some other local-only con method). –Marc B May 8 '13 at 16:06 Would I have to contact my SQL Database provider to determine that? –e-zero May 8 '13 at 16:09 Where is your database hosted? –Abe Miessler May 8 '13 at 16:12 yes, and also make sure you're getting mssms to use tcp/ip as well. the other connection methods are NOT routeable/useable over remote network links. –Marc B May 8 '13 at 16:12 I am able to connect ok on my PC, but I receive Error 53 when trying to connect behind ISA 2004 on my SBS 2003 Server. –e-zero May 8 '13 at 16:14 | show 5 more comments 5 Answers 5 active oldest votes up vote 6 down vote https://social.technet.microsoft.com/wiki/contents/articles/2102.how-to-troubleshoot-connecting-to-the-sql-server-database-engine.aspx http://blog.sqlauthority.com/2009/05/21/sql-server-fix-erro
(Русский)ישראל (עברית)المملكة العربية السعودية (العربية)ไทย (ไทย)대한민국 (한국어)中华人民共和国 (中文)台灣 (中文)日本 (日本語) HomeLibraryLearnDownloadsTroubleshootingCommunityForums Ask a question Quick access Forums home Browse forums users FAQ Search related threads Remove From My Forums Answered by: Cannot connect to remote SQL Database with SQL Server Management Console (Error 53) SQL Server > Getting started with SQL Server sql server express remote connections Question 0 Sign in to vote I have opened up port 1433 on my firewall, sql server error 17 but every time I try and connect to my remote SQL Database with SQL Server Management Console I receive (Microsoft SQL Server,
Sql Server Properties "allow Remote Connections"
Error: 53) Wednesday, May 08, 2013 4:08 PM Reply | Quote Answers 3 Sign in to vote HI Mr. E.Zero There are few chances to get this error. Please provide exact error so that it will http://stackoverflow.com/questions/16445243/cannot-connect-to-remote-sql-database-with-sql-server-management-console-error be easy to fetch it . Few scenarios are : 1.May be the port is blocked from Firewall end. 2. Need to open port from ISP provide. 3. Ned to check for TCP/IP whether it is enabled or not in Configuration manager. 4. Whether MSSQL port is listening on your SBS server or not. 5. Whether named pipe is enabled or not. *** IF you specify exact error it is very much https://social.msdn.microsoft.com/Forums/sqlserver/en-US/26c72c98-dcf7-4816-b5f4-98cf0633281d/cannot-connect-to-remote-sql-database-with-sql-server-management-console-error-53?forum=sqlgetstarted easy to find out the exact solution. Proposed as answer by Ed Price - MSFTMicrosoft employee, Owner Friday, May 10, 2013 9:10 AM Marked as answer by Ed Price - MSFTMicrosoft employee, Owner Monday, June 03, 2013 7:18 AM Friday, May 10, 2013 5:56 AM Reply | Quote 1 Sign in to vote Hi, Probably, you will also need to check if you have allowed firewall port for inbound and outbound traffic at your server, ISA and on your machine for the port your SQL Server is listening to. Also, try to telnet your server on the port it listens to. For example, if your server name is srv1 and it listens on port 4949 use telnet srv1 4949 And, as mentioned in the above post, please post the exact error message from either windows event viewer or from SQL Server Logs that will help further troubleshooting.Hemantgiri S. Goswami | SQL Server Citation| Author of book - SQL Server 2008 High Availability Proposed as answer by Olaf HelperMVP, Moderator Sunday, May 12, 2013 5:16 AM Marked as answer by Ed Price - MSFTMicrosoft employee, Owner Monday, June 03, 2013 7:18 AM Friday, May 10, 2013 11:53 AM Reply | Quote Moderator 0 Sign in to vote I have solved this problem. Please refer to this thread:http://social.technet.microsoft.com/Forums
log in tour help Tour Start here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta http://dba.stackexchange.com/questions/104315/cant-connect-to-remote-sql-server-from-some-machines Discuss the workings and policies of this site About Us Learn more about Stack Overflow the company Business Learn more about hiring developers or posting ads with us Database Administrators Questions Tags Users Badges Unanswered Ask Question _ Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills sql server and learn from others in the community. Join them; it only takes a minute: Sign up Here's how it works: Anybody can ask a question Anybody can answer The best answers are voted up and rise to the top Can't connect to remote SQL server from some machines up vote 1 down vote favorite 1 Our web server sql server error uses SQL Server 2008 R2. I have one development machine that connects to it with the IP address through SSMS and when testing my aspx website. I have several other machines though that can't connect to the IP through SSMS. I'm getting this error: A Network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify the instance name is correct and the SQL Server is configured to allow remote connection. (provider: Named Pipes provider:40-could not open a connection to SQL Server) (Microsoft SQL Server, Error:53) I've got TCP/IP enabled, port 1433 open, all of that. Remember that I can connect from one development machine, but not others. sql-server sql-server-2008-r2 ssms connectivity share|improve this question edited Jun 17 '15 at 17:06 marc_s 5,41132743 asked Jun 17 '15 at 14:06 David Kroll 814 check connection properties in the connect to server dialog box in SSMS to make sure the network protocol is set to TCP/IP on machines that cant connect. you