Featured post
Error while connecting to external SQL Server with an IP using SQL Management Studio 2005 -
error while connecting external sql server ip using sql management studio 2005 address
title: connect server
cannot connect 1.2.3.4\sqlexpress.
additional information:
a network-related or instance-specific error occurred while establishing connection sql server. server not found or not accessible. verify instance name correct , sql server configured 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
make sure remote server allows connection port 1433/tcp
, e.g.:
using telnet client (in windows 7 isn't installed default, install use turn windows features
):
telnet 1.2.3.4 1433
or using nmap (port scanner)
nmap -st -r -n -vv -p1433 1.2.3.4
if doesn't allow - check inbound firewall rules.
- Get link
- X
- Other Apps
Comments
Post a Comment