October 29, 2008 at 3:28 pm
Hi, new person here
My question is as follows:
I'm trying to create a linked server to another database, but they are not using the default port, but a static port. Where in linked server do i put that port number to see it.
If i do it thru microsoft access odbc connection i can see it no problem, but not when i do a sql server connection
Thanks
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 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply