September 22, 2010 at 3:54 am
Hi All,
Does anyone know of any methods which I can configure an alias of the instance name ?
For example, if my instance name is SQLSERVER-CLUST\SQLSERVER1.
Will I be able to say point the name to an alias like SQLSERVER-CLUST\Server1 ?
And connecting via sqlcmd will be like: sqlcmd -S SQLSERVER-CLUST\Server1
Any ideas will be appreciated !
Thank You !
September 22, 2010 at 4:38 am
yes you can,
go in configuration manager-- go to client configuration--select alias.
you will have 4 option
alias name :- put what you want your server to be named as
pipe name/port number :- pipe name if named pipe selected and port number(1433) if tcp ip selected in protocol
protocol :- tcp ip if its enabled, else named pipe
server :- your original server for which you creating alias. So if your server have instance name then complete name as servername\instance name.
----------
Ashish
September 22, 2010 at 6:31 pm
Hi Ashish,
Thanks a lot for the help !
That is exactly what I need !
September 23, 2010 at 12:28 am
Thanks Ashish for the pointer. We can also use SQL Server Client Network utility for doing the same. Both approaches are detailed in the article http://www.mssqltips.com/tip.asp?tip=1620
September 23, 2010 at 1:10 am
My pleasure Dias.
Venky,
as mentioned in article:-
If you haven't installed the SQL Server 2005/2008 client tools, you can still create an alias using the SQL Server Client Network Utility.
----------
Ashish
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply