Thursday, January 17, 2008

Server 'DHW01' is not configured for DATA ACCESS

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: