Tuesday, 6 April 2010

Msg 7411, Level 16, State 1, Line 1

Problem or Error Messages in SQL Server 2008:
Msg 7411, Level 16, State 1, Line 1
Server 'ServerName' is not configured for DATA ACCESS.

Executing the below message gives the below error and followed by solution:
select * from openquery ([ServerName],'set fmtonly off; exec master..xp_fixeddrives')
GO
Msg 7411, Level 16, State 1, Line 1
Server 'ServerName' is not configured for DATA ACCESS
GO

SELECT @@SERVERNAME -- To retrieve your server name
GO
-- Executing this below query will sort it out the problem.
Exec sp_serveroption @server = 'ServerName'
,@optname = 'DATA ACCESS'
,@optvalue = 'TRUE'

No comments:

Post a Comment