August 2, 2010 at 2:25 pm
What would be the purpose of a linked server that is "Not configured for Data Access"?
I dont recall creating this linked server. Perhaps it was created by sql server.
The link is on a sql 2005 server to a sql 2008 server. We have set up snapshot replication from a 2005 database to the 2008 server. We also attemped to set up log shipping from a 2005 database to the 2008 server but it did now work. I was wondering if that might be where the link came from and more importantly if it was used by something.
Now we have removed the replicated databases on the 2008 server and put them on a 2005 server using log shipping instead of snapshot replication. The new secondary server does not have a link pointing at it from the primary server.
I was just wondering where that other link might have came from and what use would a linked server have if it is not configured for data access.
August 2, 2010 at 11:32 pm
I think the Linked Server is using an obsolete name (which was changed after adding the linked server) or it is configured for loopback. If needed you may configure that Linked Server for Data Access using the below query.
EXEC sp_serveroption 'LinkedServerName', 'DATA ACCESS', TRUE
Pradeep Adiga
Blog: sqldbadiaries.com
Twitter: @pradeepadiga
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply