May 18, 2010 at 5:08 pm
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!
May 18, 2010 at 5:41 pm
There are workarounds for it, but it is not directly supported.
Here is something that should prove useful in explaining it:
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
May 18, 2010 at 9:04 pm
You can use cliconfg.exe utility to create SQL Server alias MyServerInstanceOne.company.com on client computer.
May 19, 2010 at 10:00 am
The thing is that I don want to add anything on the client side, isn't any other way?
May 19, 2010 at 10:04 am
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
July 16, 2011 at 8:04 am
can you explain further about the login script method?
July 18, 2011 at 11:15 am
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
July 18, 2011 at 11:22 am
an easier solution is having two ip addreses on the server, one for each instance, that is already working for me
Viewing 8 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply