Adding an alias name to a clustered instance of SQL Server

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2005 » Administering » Adding an alias name to a clustered instance...

Adding an alias name to a clustered instance of SQL Server

Rate Topic

Display Mode

Topic Options

Author

Message

Imke Cronje

Posted Monday, October 29, 2012 2:09 AM

SSC Veteran

Group: General Forum Members
Last Login: Today @ 3:32 AM
Points: 252, Visits: 560

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

Joie Andrew

Posted Monday, October 29, 2012 12:50 PM

Mr or Mrs. 500

Group: General Forum Members
Last Login: Yesterday @ 5:01 AM
Points: 576, Visits: 1,103

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 »

Permissions