Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Adding an alias name to a clustered instance of SQL Server Expand / Collapse
Author
Message
Posted Monday, October 29, 2012 2:09 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: 2 days ago @ 6:37 AM
Points: 253, Visits: 622
Hi there,

Does anyone know how to add an alias name to an clustered SQL Server instance?

I went onto the SQL Server Native Client Configuration on the SQL Server Configuration Manager. Entered all the relevant fields under aliases but it alias name does not work.

Any ideas?

Regards
IC
Post #1378150
Posted Monday, October 29, 2012 12:50 PM
Say Hey Kid

Say Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey Kid

Group: General Forum Members
Last Login: Today @ 6:16 AM
Points: 709, Visits: 1,418
What are you trying to accomplish?

A SQL alias is used for a client to connect to a server instance using a different instance name than what the server is configured for. It is not normally setup on the SQL server itself.

Setting up an alias for a cluster is the same process as setting up an alias for a stand-alone instance.


Joie Andrew
"Since 1982"
Post #1378417
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse