Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

I am not able to connect to sql server database engine from my machine to server having different networks. Expand / Collapse
Author
Message
Posted Monday, November 25, 2013 4:42 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Monday, April 14, 2014 3:53 AM
Points: 23, Visits: 33
TITLE: Connect to Server
------------------------------

Cannot connect to server.trainingcloudz.com.

------------------------------
ADDITIONAL INFORMATION:

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)


Post #1517193
Posted Monday, November 25, 2013 2:16 PM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Yesterday @ 12:44 PM
Points: 133, Visits: 250
Start by making sure you can ping the SQL Server.
If you can ping it, check to make sure the SQL Server service is running.
If it is, check to make sure the instance is configured to listen for TCP connections (SQL Express by default does not)
If it is, check to make sure that the local firewalls are not dropping the communication. This applies to both client and server.
Post #1517463
Posted Monday, November 25, 2013 10:10 PM


SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: 2 days ago @ 2:36 AM
Points: 431, Visits: 911
If you can ping the server from your machine then probably it will not be a firewall issue. Also try to access through IP and make sure that server is configured on default port. In case of customized port number also include the port number in connection string.

=============================================================
Atif Shehzad
DBA
Zin Technologies
Post #1517525
Posted Friday, November 29, 2013 7:00 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Yesterday @ 11:51 AM
Points: 5,958, Visits: 12,839
AShehzad (11/25/2013)
If you can ping the server from your machine then probably it will not be a firewall issue.

Correct, ICMP traffic is the first traffic a firewall usually blocks. If you can ping the server you likely have no firewall in place unless your admins explicitly opened the firewall for ICMP (highly unlikely ).


-----------------------------------------------------------------------------------------------------------

"Ya can't make an omelette without breaking just a few eggs"
Post #1518546
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse