sql server 2005 sqlncli

12/04/2006 - 13:17 por gorka | Informe spam
Alguien ha podido solucionar este error?? he podido ver que tiene algo q ver
con el sqlncl.1 pero no he coseguido dar con la solución correcta:
SQL Server blocked access to STATEMENT 'OpenRowset/OpenDatasource' of
component 'Ad Hoc Distributed Queries' because this component is turned off
as part of the security configuration for this server. A system administrator
can enable the use of 'Ad Hoc Distributed Queries' by using sp_configure. For
more information about enabling 'Ad Hoc Distributed Queries', see "Surface
Area Configuration" in SQL Server Books Online.
 

Leer las respuestas

#1 Maxi
12/04/2006 - 13:33 | Informe spam
Hola, has seguido los pasos que indica el mensaje?


Salu2
Maxi [MVP SQL SERVER]
www.sqlgurus.org


"gorka" escribió en el mensaje
news:
Alguien ha podido solucionar este error?? he podido ver que tiene algo q
ver
con el sqlncl.1 pero no he coseguido dar con la solución correcta:
SQL Server blocked access to STATEMENT 'OpenRowset/OpenDatasource' of
component 'Ad Hoc Distributed Queries' because this component is turned
off
as part of the security configuration for this server. A system
administrator
can enable the use of 'Ad Hoc Distributed Queries' by using sp_configure.
For
more information about enabling 'Ad Hoc Distributed Queries', see "Surface
Area Configuration" in SQL Server Books Online.

Preguntas similares