March 4, 2005 at 2:49 am
How to specifiy Linked server using Ip,Port
It is the requirement of the application to specify access lnked server using IP,Port (172.16.12.2,1433)
can anybody help
subban
March 4, 2005 at 10:17 am
First you need to define a DSN using the correct port. Then you can setup the linked server to use that DSN. You can't just select "SQL Server" for the Server Type. You have to specify "other" then choose the appropriate type and specify the provider name you want to use.
Books online has plenty of examples on how to setup the various provider types. The key you need is just to properly define your DSN and then refer to it in you linked server definition.
/*****************
If most people are not willing to see the difficulty, this is mainly because, consciously or unconsciously, they assume that it will be they who will settle these questions for the others, and because they are convinced of their own capacity to do this. -Friedrich August von Hayek
*****************/
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply