Posted on Leave a comment

Server not configured for DATA ACCESS

Error: Server ‘SERVER_NAME‘ is not configured for DATA ACCESS.

Resolution:
exec sp_serveroption ‘SERVER_NAME‘, ‘data access’, ‘true’
go

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.