Tuesday, February 15, 2011

How to : Solve " Server is not configured for DATA ACCESS " error in SQL Server 2005.

Execute the below query :

exec sp_serveroption 'SERVER NAME', 'data access', 'true'


And finally Restart the MSSQLSERVER Service.


Posted by at

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)