When you try to run an openquery script against a local database, you received the following error:
Msg 7411, Level 16, State 1, Line 1
Server 'DHW01' is not configured for DATA ACCESS.
To rectify the issue, run the following script:
exec sp_serveroption 'DHW01', 'DATA ACCESS', 'TRUE'
No comments:
Post a Comment