November 12, 2008 at 4:55 pm
When I right-click on a Linked Server name and select "Test Connection", I get the following error message:
[font="Courier New"]Server 'LOGSHIPLINK_BP1XTXAP087\HOUSQLDEV02_-1281889294' is not configured for DATA ACCESS. (.Net SqlClient Data Provider)[/font]
I selected the Server Options page on the Linked Server Properties window and the Data Access option on is TRUE. Moreover, I ran the following statement and I still get the same error message:
EXEC sp_serveroption 'LOGSHIPLINK_BP1XTXAP087\HOUSQLDEV02_-1281889294', 'data access', 'true'
The Linked Server was created after I used the wizard to configure Log Shipping. I would appreciate any suggestions.
May 14, 2012 at 3:43 pm
This is a expected behaviour. Even though that is not working, is the meta data related to logshipping getting updated if they are then you can ignore this error.
Also if you expand the linked server are you able to see the catalogues and tables if yes, then you do not have to worry about this error. When you click test connection at the background it uses the sp_testlinkedserver stored procedure which expects a sysserver name. And the linked server name is actually not the sysserver name and hence it fails.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply