Share via

Not able to connect to SQL DB (SSMS) by using IP address. If Mention Machine/Instance Name able to connect?

  • Article
  • 01/23/2013

Question

Wednesday, January 23, 2013 11:27 PM

Hi Guys,

Today suddenly got issue. We are not able to connect to SSMS If I give IP address (10.1.27.89\ETL). If I connect by mentioning Machine/Intance (PRODSUPORT\ETL)

I pinged the Server & it returened same IP address (10.1.27.89). I am getting below Error message:

"

TITLE: Connect to Server

Cannot connect to 10.1.27.89\ETL.

ADDITIONAL INFORMATION:

An error has occurred while establishing a connection to the server.  When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified) (Microsoft SQL Server, Error: -1)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&EvtSrc=MSSQLServer&EvtID=-1&LinkId=20476

BUTTONS:

OK

"

Thanks Shiven:) If Answer is Helpful, Please Vote

All replies (5)

Thursday, January 24, 2013 5:58 AM

Cannot connect to 10.1.27.89**\ETL.**

Hello,

Have you checked if the "SQL Server" as well as the "SQL Server-Browser" service is running? The Browser is responsable to resolve the intance name "ETL" to the used ip port.

Olaf Helper

Blog Xing

Thursday, January 24, 2013 6:08 AM

Can you check IP address used by TCP/IP is same as machine IP. By default, SQL Server only listens to the IP allocated to host while installing SQL Server on it. Available IP address can change, when assigned IP is expired and DHCP allocates new IP or network structure is reconfigured. Correct the IP address, it should work.

Steps to check/ edit IP used by TCP/ IP protocol of SQL Instance-

1. Open SQL Server Configuration Manager 

2. Click on "SQL Server Network Configuration", click on Protocals for <Instance Name>

3. From right panel, right click TCP/IP and click on "Properties" tab. Go to "IP Address" tab and check current IP. 

4. Edit the IP address if it's different from your machine's IP. Refer BOL to understand why there are multiple IP Addresses sections.

5. Make sure you restart SQL Server once any configuration is changed.

Also, check your domain AD whether host name and IP address are correctly mapped.

 - Thanks  

Thursday, January 24, 2013 6:11 AM

Hi,

1.Check SQL Server is Running

2.Check If firewall is blocking the Port

3.Check If you able to ping that server from your machine.

Please use Marked as Answer if my post solved your problem and use Vote As Helpful if a post was useful.

Thursday, January 24, 2013 6:39 AM

Possible solution in your link

  • A specified SQL Server instance name is not valid.

  • The TCP, or named pipes protocols are not enabled.

  • The firewall on the server has refused the connection.

  • The SQL Server Browser service (sqlbrowser) is not started.

    --Common Problems with SQL Browser service and and server service,Port Number and Ip Address

Firewall on then exception of port of 1433,1434

--Allow remote connection in SQL Server.

Telnet the server from client

telnet ip adress 1433

-- Bhavesh Thakkar

Sr.Database Administrator
My Blog
Linked In Profile

Tuesday, January 29, 2013 7:55 AM

Hi,

To solve check following and enable if not enabled

  • Check  TCP, or named pipes protocols are not enabled, if not enable them

  • Check system or hardware firewall on the server has refused the connection, enable IP connectivity

  • Check SQL Server Browser service is not started or not, if not started start

  • Check instance name is valid or not

Please help and appreciate others by using these features: "Propose As Answer", "Vote As Helpful" and "Mark As Answer"

Waqas

MS(SPM), MS(E&F),M.Engg, MCP, MCT, MCTS, MCITP, MCSE, MCPD, MCSD, MCDBA , Author
Twitter: @waqas8777
Linked In: http://www.linkedin.com/in/waqasm1