January 20, 2003 at 1:39 pm
Anyone know how to create a linked server to a server that has a port other than 1433?
I keep getting "Sepcified Server not found."
Cannot find where to set the port in the code.
sp_addlinkedserver
@server=
@srvproduct=
@provider=
@datasrc=
Any ideas?
January 20, 2003 at 1:44 pm
I have not done it but may be
@server=123.456.789.012:9876
where 123.456.789.012 is the IP and 9876 is the port number?
January 20, 2003 at 1:53 pm
Try adding an alias in the client net library with the specified port
January 20, 2003 at 1:57 pm
neither one works.
January 20, 2003 at 2:22 pm
check that. The alias works.
Just had to configure it like below, where ServerA_Linked is the alias name.
EXEC sp_addlinkedserver
@server='ServerA_Linked',
@srvproduct='',
@provider='SQLOLEDB',
@datasrc='ServerA_Linked'
Thanks.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply