Tuesday, March 27, 2012

Alias of a Linked Server

I am using linked server with an IP address then want to user this server in query but using IP address gives error and I want to define an Alias for that linked server to use in query, Please help me.

Thanks in advance

Muhammad Hanif

Have you tried with the hostname?|||

You can create an alias using the Client Network Utility (on SQL 2000) or Configuration Manager (on SQL 2005). You can create whatever alias name and enter the IP address for the server.

-Sue

No comments:

Post a Comment