SQL Server Connectivity

Question

Post reply

SQL Server Connectivity

VastSQL

SSC-Dedicated

Points: 36097
More actions
May 17, 2016 at 4:56 am

#307820

Experts,
I am trying to access a server which is in company environment from my local laptop after connecting to VPN. The instance is a Named Instance and I have opened the UDF Port 1434, SQL Browser is Started, TCP\IP enabled, Remote connections are allowed.
Network team have made changes in firewall to allow this port.Still getting 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 that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server) (Microsoft SQL Server, Error: 53)
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft%20SQL%20Server&EvtSrc=MSSQLServer&EvtID=53&LinkId=20476
------------------------------
The network path was not found
TIA

Viewing 10 posts - 1 through 9 (of 9 total)

You must be logged in to reply to this topic. Login to reply

Welsh Corgi SSC Guru Points: 116520 More actions · Answer 1

Can you ping the Server?

Can you remote into that Server, launch SQL Server Configuration Manager and check the configuration settings?

For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/

For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

VastSQL SSC-Dedicated Points: 36097 More actions · Answer 2

Welsh Corgi (5/17/2016)
Can you ping the Server?
Can you remote into that Server, launch SQL Server Configuration Manager and check the configuration settings?

Cant ping to server.

RDP,yes. TCP\IP is enabled, Remote connections enabled, Browser running,Opened Port UDP Port 1434

Welsh Corgi SSC Guru Points: 116520 More actions · Answer 3

Did you try and execute IPCONFIG from the Server? Do you have the correct IP Address?

For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/

For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

Welsh Corgi SSC Guru Points: 116520 More actions · Answer 4

What happens if you Set the port to the default?

Eliminate the browser, non default port and go from there.

For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/

For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

Steve Jones - SSC Editor SSC Guru Points: 736212 More actions · Answer 5

Need TCP 1433.

You can explicitly connect to a server on a port. The first item below connects to the instance named "myserver" on port 1433 (TCP). The second item connects to the default instance on the IP, using TCP 55000.

myserver, 1433

192.168.1.200, 55000

VastSQL SSC-Dedicated Points: 36097 More actions · Answer 6

Welsh Corgi (5/17/2016)
Did you try and execute IPCONFIG from the Server? Do you have the correct IP Address?

Thanks Welshi,

Connecting using VPN which allocate dynamic IP in same range but.

VastSQL SSC-Dedicated Points: 36097 More actions · Answer 7

Steve Jones - SSC Editor (5/17/2016)
Need TCP 1433.
You can explicitly connect to a server on a port. The first item below connects to the instance named "myserver" on port 1433 (TCP). The second item connects to the default instance on the IP, using TCP 55000.
myserver, 1433
192.168.1.200, 55000

Thanks Steve.

I will open Port 1433 and will try. By the way i have made static port 51000 for the instance.

Welsh Corgi SSC Guru Points: 116520 More actions · Answer 8

Great. 🙂

For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/

For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

Steve Jones - SSC Editor SSC Guru Points: 736212 More actions · Answer 9

VastSQL (5/17/2016)
Steve Jones - SSC Editor (5/17/2016)
Need TCP 1433.
You can explicitly connect to a server on a port. The first item below connects to the instance named "myserver" on port 1433 (TCP). The second item connects to the default instance on the IP, using TCP 55000.
myserver, 1433
192.168.1.200, 55000
Thanks Steve.
I will open Port 1433 and will try. By the way i have made static port 51000 for the instance.

What do you mean static port for the instance? Did you change this in configuration manager? If so, then are you connecting with an alias or specifying the port?