SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 General SQL Server Forums
 New to SQL Server Administration
 Error 10060 connecting from remote host
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

Flaterik
Starting Member

Italy
26 Posts

Posted - 01/21/2012 :  08:03:20  Show Profile  Reply with Quote
Hi people i have a problem

I want to connect from an external host to my database.

I open the port on the firewall and the TCP/IP are active on my 2008 R2 database istance.

My database is SERVERNAME\DOMAIN

From eternal i try to connect with SERVERIP\DOMAIN where SERVERIP is the external ip of my server. THe routing on firewall redirect the call from 1433 to server IPADDRESS

Why doesn't work?

I have on the same server another istance of 2005 SERVER SQL and if i try the connection by SERVERIP with no istance, the connection are fully functional with this database. When i try adding the istnace name to connect to other db , always 10060 error

Wher's the problem?



************************************************
the world is strange but people are crazy

sunitabeck
Flowing Fount of Yak Knowledge

5152 Posts

Posted - 01/21/2012 :  09:01:21  Show Profile  Reply with Quote
Check if remote connections are enabled for the server. You can do it from SQL Server Management studio - right click on server name in object explorer, select Properties and look under Connections.

Edited by - sunitabeck on 01/21/2012 09:01:45
Go to Top of Page

biswajitdas
Starting Member

USA
44 Posts

Posted - 01/22/2012 :  18:04:40  Show Profile  Reply with Quote
1) is the new SQL server was set to Windows Authentication Only?

The below link can help you .
http://msdn.microsoft.com/en-us/library/bb326282.aspx

Sr Sql server DBA/Artitech
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.03 seconds. Powered By: Snitz Forums 2000