October 29, 2008 at 3:43 pm
You don't need any port related information for configuring linked servers. Just mention the servername if its default installation or servername\instancename in case of named instance.
What error do you receive when you try to go for a sql connection?
MJ
October 29, 2008 at 3:48 pm
When i click on views it says 'Error 17: SQL Server does not exist or access denied'
If i click on tables it doesn't say anything just in the window it says ' There are no items to show in this view'
October 29, 2008 at 4:01 pm
Try connecting to the destination server using management studio and tell us what error do you receive? In case it doesn't work then try specifying protocol name in front of sqlservername(TCP:ServerName\instancename) while connecting thru management studio.
MJ
October 29, 2008 at 4:03 pm
servername, port number (hostname,XXXX) or
ip address, portnumber (x.x.x.x, xxxx).
Viewing 4 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply