Accessing Named instance without specifying port number

Question

Post reply

Accessing Named instance without specifying port number

ricardo_chicas

SSCertifiable

Points: 5024
More actions
May 18, 2010 at 5:08 pm

#219029

Hi all,
I have one server with four named instances, I manage to access those from the cliente using server\instancename, but I want to use something like MyServerInstanceOne.company.com, is this possible? I've been reading other posts but I didn't see any final conclusion about this topic.
Thanks in advance!

Viewing 8 posts - 1 through 7 (of 7 total)

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

SQLRNNR SSC Guru Points: 281334 More actions · Answer 1

There are workarounds for it, but it is not directly supported.

Here is something that should prove useful in explaining it:

http://sqlblog.com/blogs/merrill_aldrich/archive/2009/09/22/config-points-are-h-e-double-hockeysticks.aspx

Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events

magasvs SSCertifiable Points: 7660 More actions · Answer 2

You can use cliconfg.exe utility to create SQL Server alias MyServerInstanceOne.company.com on client computer.

ricardo_chicas SSCertifiable Points: 5024 More actions · Answer 3

The thing is that I don want to add anything on the client side, isn't any other way?

SQLRNNR SSC Guru Points: 281334 More actions · Answer 4

No.

The easiest way to get this done without the end-user knowing is through a logon script.

Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events

@STLSQLGuy Default port Points: 1476 More actions · Answer 5

can you explain further about the login script method?

thanks, ERH

SQLRNNR SSC Guru Points: 281334 More actions · Answer 6

ERH (7/16/2011)
can you explain further about the login script method?

This logon script is through the domain logon script. You can set drive mappings and such.

Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events

ricardo_chicas SSCertifiable Points: 5024 More actions · Answer 7

an easier solution is having two ip addreses on the server, one for each instance, that is already working for me

Accessing Named instance without specifying port number

Cookies on SQLServerCentral