Named instance - Client config entry

Question

Named instance - Client config entry

sqlcool

SSC Eights!

Points: 967
More actions
December 3, 2008 at 6:13 pm

#154981

Hi there,
I am new to SQL i am filling in the shoes of my DBA who went for holidays. Pls help me with this
I need to connect to my hosting server but i am facing issues. Normally i connect to VPN and then use IP address and username and password in the SQL-Server DB and connect to that particular DB server.
but my hosting company set up new DR(Disaster recovery) server but i could not able to connect can u pls help me.
This is what my hosting company sent me to connect to DR
"The DR SQL Server 2005 instance is listening on IP address 9.500.12.02, port 6737,
Also, it is a named instance, so SQLDR02\SQL2005 by name or 9.500.12.02\SQL2005 by IP address. Because it is a named instance it may also require a client config entry on your workstation or laptop"
i used
Server name : - 9.500.12.02
Authentication :- SQL server authentication
Login :- (same as other servers)
password :- ******* (same password as other servers)
is there anything else i need to do?
Cheers
GB

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

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

RBarryYoung SSC Guru Points: 143329 More actions · Answer 1

What error are you getting?

Also, I don't think that "9.500.12.02" is a valid IP address, each segment should be in the range 0-255. "500" is a little bit over that. Maybe they meant "9.50.12.02"?

[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung [font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]

Jonathan Kehayias One Orange Chip Points: 26778 More actions · Answer 2

sqlcool (12/3/2008)
"The DR SQL Server 2005 instance is listening on IP address 9.500.12.02, port 6737,
Also, it is a named instance, so SQLDR02\SQL2005 by name or 9.500.12.02\SQL2005 by IP address. Because it is a named instance it may also require a client config entry on your workstation or laptop"

You need to know if this instance is hard locked to port 6737 or is it on Dynamic port assignment. If it is permanently on this port, you can use the cliconfg tool and create a alias to the instance. Just click start==>run and type in cliconfg and click ok. It will open a tool with tabs in it. Click the Aliases tab, and then fill out the form. You need to select TCP/IP as the protocol. If the port is permanent, you can just put the IP Address in remove dynamic Port assignment checkbox and put the provided port into the text box. Then give it an alias, and save it, and try to connect.

If it is using dynamic port assignment, and the Hosting company would be the only one who could tell you, you can put in IP\InstanceName for the server name, and make a friendly alias, but it doesn't do much more than that.

sqlcool SSC Eights! Points: 967 More actions · Answer 3

sqlcool

SSC Eights!

Points: 967

December 3, 2008 at 7:40 pm

#907303

ta John,

Worked like a gem

Cheers

Jonathan Kehayias One Orange Chip Points: 26778 More actions · Answer 4

We do similar things with our DMZ Servers, so the topic is very familiar. I have to setup a PC every month or so for one reason or another.