October 31, 2008 at 2:25 pm
HI
I am trying to add linked server from sql server 2000 to sql server 2005. My destination machine is having sql server 2005 ( named instance ) . Somehow after creating the linked server whenever i am clicking on tables it is throwing error :
Error: 17 SQL Server doesnot exist or access denied.
The login from which iam trying to add linked server exists on both the servers with sysadmin priviliges.
Can anyone please tell me how do i go about this ?????
October 31, 2008 at 2:35 pm
Check linked server properties and check security context.
Most probably this would be an issue and if you have access on both server then select this option - Be made using the login's current security context.
SQL DBA.
October 31, 2008 at 2:39 pm
what is the linked server name you are using?
October 31, 2008 at 4:11 pm
my servername is : chovavdb01fage
so i am creating Linked server with this name
October 31, 2008 at 4:28 pm
What provider did you chose under other data source while configuring linked server to sql server 2005 instance?
MJ
October 31, 2008 at 4:45 pm
I clicked the first option (Sql server). Didnt selected the second option (Other data source)
October 31, 2008 at 4:51 pm
Okie thats fine. Have you checked using logins current security context under security options?
MJ
October 31, 2008 at 8:03 pm
Are you trying to connect to sql server2005 Express?
Viewing 8 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply