Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 


 
     
Recent Posts
   
Popular Topics
Home   
Search
    Members    Calendar    Who's On

Home » SQL Server 2008 » SQL Server 2008 - General » Named Instance and specified port not...
Add to briefcase
12 posts, Page 1 of 2
12»»

Named Instance and specified port not connecting Expand / Collapse
Rate Topic
Display Mode
Topic Options
Author
Message
Kwisatz78
Posted Thursday, February 14, 2013 3:23 AM
Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Yesterday @ 7:46 AM
Points: 542, Visits: 1,402
Hi all

I have opened up a port on a remote SQL instance and can see that the port is LISTENING when using the PortQry tool. I have also set the TCP port in the TCP/IP properties in the IPAll section for that instance, yet I am unable to connect and get an error of

Connection Timeout Expired. The timeout period elapsed while attempting to consume the pre-login handshake acknowledgement. This could be because the pre-login handshake failed or the server was unable to respond back in time. The duration spent while attempting to connect to this server was - [Pre-Login] initialization=1; handshake=14998; (.Net SqlClient Data Provider)

Does anyone have any suggestions on what could be wrong? I have done this on other instances, although they were default instances, and it has always worked fine.

Thanks
Post #1419922
Abu Dina
Posted Thursday, February 14, 2013 4:10 AM


SSC-Addicted

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

Group: General Forum Members
Last Login: Yesterday @ 10:34 AM
Points: 494, Visits: 2,158
Could be firewall issue?

-----------------------------------
http://www.SQL4n00bs.com
Post #1419948
anthony.green
Posted Thursday, February 14, 2013 4:12 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Friday, April 12, 2013 3:51 AM
Points: 5,075, Visits: 4,831
SQL browser started and listening on 1434.


Want an answer fast? Try here
How to post data/code for the best help - Jeff Moden
Need a string splitter, try this - Jeff Moden
How to post performance problems - Gail Shaw
CrossTabs-Part1 & Part2 - Jeff Moden
SQL Server Backup, Integrity Check, and Index and Statistics Maintenance - Ola Hallengren
Managing Transaction Logs - Gail Shaw
Troubleshooting SQL Server: A Guide for the Accidental DBA - Jonathan Kehayias and Ted Krueger
Post #1419951
Kwisatz78
Posted Thursday, February 14, 2013 5:24 AM
Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Yesterday @ 7:46 AM
Points: 542, Visits: 1,402
yeah browser service is started and UDP 1434 is open
Post #1419996
Kwisatz78
Posted Thursday, February 14, 2013 6:45 AM
Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Yesterday @ 7:46 AM
Points: 542, Visits: 1,402
Have tried from another server and the connection worked fine which would indicate the browser service is ok. I have no local firewall turned on am stumped at present!!
Post #1420027
anthony.green
Posted Thursday, February 14, 2013 6:47 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Friday, April 12, 2013 3:51 AM
Points: 5,075, Visits: 4,831
So server to server works, but server to workstation doesnt?

Do you have any firewalls controlled by IT which sit between the servers and the workstation VLANs?


Want an answer fast? Try here
How to post data/code for the best help - Jeff Moden
Need a string splitter, try this - Jeff Moden
How to post performance problems - Gail Shaw
CrossTabs-Part1 & Part2 - Jeff Moden
SQL Server Backup, Integrity Check, and Index and Statistics Maintenance - Ola Hallengren
Managing Transaction Logs - Gail Shaw
Troubleshooting SQL Server: A Guide for the Accidental DBA - Jonathan Kehayias and Ted Krueger
Post #1420028
Lowell
Posted Thursday, February 14, 2013 7:03 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 3:33 PM
Points: 11,648, Visits: 27,768
what does your connection string look like?
are you putting servername-comma-port in the connection string? i know it's common for people to use a semicolon by mistake.


for example
Private Const SqlConnectionFormat As String = "data source={0};initial catalog={1};user id={2};password={3};Trusted_Connection=False;Connect Timeout=600;Application Name=Stormrage.ReportGrid.exe;"

my datasource might look like this:

data source=DEV223\SQL2012,14430;initial catalog=SandBox;
data source=192.168.0.55,14430;initial catalog=SandBox;

Lowell

--There is no spoon, and there's no default ORDER BY in sql server either.
Actually, Common Sense is so rare, it should be considered a Superpower. --my son
Post #1420039
Kwisatz78
Posted Thursday, February 14, 2013 7:53 AM
Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Yesterday @ 7:46 AM
Points: 542, Visits: 1,402
Hi - I have got the networks guys to monitor blocked traffic on the firewalls and there is none for the defined port from my workstation. I know we are monitoring it as if I put in the incorrect port I can see its blocked.

I am trying to connect with SSMS and my string is ServerName\InstanceName,port - however with the broswer service running then I should be able to enter ServerName\InstanceName and it will resolve the port anyway correct?

This is an named SQL 2008 R2 install on the same box as as an existing 2008 SP1 default name install, although I can't see what different that makes.
Post #1420082
Lowell
Posted Thursday, February 14, 2013 8:12 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 3:33 PM
Points: 11,648, Visits: 27,768
Kwisatz78 (2/14/2013)
Hi - I have got the networks guys to monitor blocked traffic on the firewalls and there is none for the defined port from my workstation. I know we are monitoring it as if I put in the incorrect port I can see its blocked.

I am trying to connect with SSMS and my string is ServerName\InstanceName,port

This is an named SQL 2008 R2 install on the same box as as an existing 2008 SP1 default name install, although I can't see what different that makes.


well, by default, a express instance will not answer to anything except local connections. Standard or Enterprise installations will answer by default, I believe.

ins this enabled on your named instance?

Lowell

--There is no spoon, and there's no default ORDER BY in sql server either.
Actually, Common Sense is so rare, it should be considered a Superpower. --my son
Post #1420102
Abu Dina
Posted Thursday, February 14, 2013 8:19 AM


SSC-Addicted

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

Group: General Forum Members
Last Login: Yesterday @ 10:34 AM
Points: 494, Visits: 2,158
Not sure that's the issue as the OP said that he could connect to the instance from another server which would indicate that allow remote connections is enabled.

I'm guessing this is a firewall issue his IT need to investigate. Maybe they can check to see which group the server he could connect from is in and include his PC in the same group?

-----------------------------------
http://www.SQL4n00bs.com
Post #1420109
« Prev Topic | Next Topic »

Add to briefcase
12 posts, Page 1 of 2
12»»

Permissions Expand / Collapse

 
 
Copyright © 2002-2013 Simple Talk Publishing. All Rights Reserved. Privacy Policy. Terms of Use. Report Abuse.