Couldnot connect ot SQL Server using Alias

Question

Couldnot connect ot SQL Server using Alias

varun_dba

SSC Journeyman

Points: 88
More actions
February 17, 2015 at 4:00 am

#304387

I had two servers, in which SQL Servers are installed. I created a alias for server
Server 1 : test1.sqlcloud.com (Alias name with port no other than 1433)
Server 2 : test2.sqlcloud.com (Alias name with port no other than 1433)
I can connect to the servers using the port. for ex server1 to server2 and viceversa using "test2.sqlcloud.com,port". But I could not connect to the server by only specifying the alias name ("test2.sqlcloud.com"). Any one had any clue? When I am connecting I am getting the following error.
"TITLE: Connect to Server
------------------------------
Cannot connect to test2.sqlcloud.com.
------------------------------
ADDITIONAL INFORMATION:
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=21020; handshake=0; (Microsoft SQL Server, Error: -2)
Any help is appreciated.

Viewing 2 posts - 1 through 2 (of 2 total)

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

Lowell SSC Guru Points: 323547 More actions · Answer 1

a connection without a port assumes the default port of 1433, OR that a SQL Browser service exists on port 1434, which in turn redirects the connection to the "right" alternate or dynamic port.

so connecting to an instace that does not have a SQL browser requires the port number, every time, unless the port is the default 1433.

Lowell

--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!