SQL Server blocked access to procedure 'sys.sp_OACreate'

11/07/2007 - 10:06 por Pedro | Informe spam
Estoy exportado a excel y me encuentro con unos errores saben por que puede
ser?
Os dajunto los erreres con un pequeño detalle:

Created OLE ADODB.Connection object
Mens 15281, Nivel 16, Estado 1, Procedimiento sp_OACreate, Línea 1
SQL Server blocked access to procedure 'sys.sp_OACreate' of component 'Ole
Automation Procedures' because this component is turned off as part of the
security configuration for this server. A system administrator can enable the
use of 'Ole Automation Procedures' by using sp_configure. For more
information about enabling 'Ole Automation Procedures', see "Surface Area
Configuration" in SQL Server Books Online.
Assigned ConnectionString property
Mens 15281, Nivel 16, Estado 1, Procedimiento sp_OASetProperty, Línea 1
SQL Server blocked access to procedure 'sys.sp_OASetProperty' of component
'Ole Automation Procedures' because this component is turned off as part of
the security configuration for this server. A system administrator can enable
the use of 'Ole Automation Procedures' by using sp_configure. For more
information about enabling 'Ole Automation Procedures', see "Surface Area
Configuration" in SQL Server Books Online.
Open Connection to XLS, for file Create or Append
Mens 15281, Nivel 16, Estado 1, Procedimiento sp_OAMethod, Línea 1
SQL Server blocked access to procedure 'sys.sp_OAMethod' of component 'Ole
Automation Procedures' because this component is turned off as part of the
security configuration for this server. A system administrator can enable the
use of 'Ole Automation Procedures' by using sp_configure. For more
information about enabling 'Ole Automation Procedures', see "Surface Area
Configuration" in SQL Server Books Online.
Execute DDL to create 'EXCELSQL' worksheet
Mens 15281, Nivel 16, Estado 1, Procedimiento sp_OAMethod, Línea 1
SQL Server blocked access to procedure 'sys.sp_OAMethod' of component 'Ole
Automation Procedures' because this component is turned off as part of the
security configuration for this server. A system administrator can enable the
use of 'Ole Automation Procedures' by using sp_configure. For more
information about enabling 'Ole Automation Procedures', see "Surface Area
Configuration" in SQL Server Books Online.
Destroyed OLE ADODB.Connection object
Mens 15281, Nivel 16, Estado 1, Procedimiento sp_OADestroy, Línea 1
SQL Server blocked access to procedure 'sys.sp_OADestroy' of component 'Ole
Automation Procedures' because this component is turned off as part of the
security configuration for this server. A system administrator can enable the
use of 'Ole Automation Procedures' by using sp_configure. For more
information about enabling 'Ole Automation Procedures', see "Surface Area
Configuration" in SQL Server Books Online.
Created Linked Server 'EXCEL_TEST' and Login
Mens. 121, Nivel 15, Estado 1, Línea 1
The select list for the INSERT statement contains more items than the insert
list. The number of SELECT values must match the number of INSERT columns.
Populated 'EXCELSQL' table with 1 Rows
Deleted Linked Server 'EXCEL_TEST' and Login

Preguntas similare

Leer las respuestas

#6 Maxi
11/07/2007 - 14:13 | Informe spam
Hola, y como estas exportando a excel?

Microsoft MVP en SQL Server
Mentor asociado en SQLTotalConsulting
(excelencia en servicios y consultoria SQLServer)
Orador Culminis - Microsoft Influencier
www.sqltotalconsulting.com


"Pedro" wrote in message
news:
Estoy exportado a excel y me encuentro con unos errores saben por que
puede
ser?
Os dajunto los erreres con un pequeño detalle:

Created OLE ADODB.Connection object
Mens 15281, Nivel 16, Estado 1, Procedimiento sp_OACreate, Línea 1
SQL Server blocked access to procedure 'sys.sp_OACreate' of component 'Ole
Automation Procedures' because this component is turned off as part of the
security configuration for this server. A system administrator can enable
the
use of 'Ole Automation Procedures' by using sp_configure. For more
information about enabling 'Ole Automation Procedures', see "Surface Area
Configuration" in SQL Server Books Online.
Assigned ConnectionString property
Mens 15281, Nivel 16, Estado 1, Procedimiento sp_OASetProperty, Línea 1
SQL Server blocked access to procedure 'sys.sp_OASetProperty' of component
'Ole Automation Procedures' because this component is turned off as part
of
the security configuration for this server. A system administrator can
enable
the use of 'Ole Automation Procedures' by using sp_configure. For more
information about enabling 'Ole Automation Procedures', see "Surface Area
Configuration" in SQL Server Books Online.
Open Connection to XLS, for file Create or Append
Mens 15281, Nivel 16, Estado 1, Procedimiento sp_OAMethod, Línea 1
SQL Server blocked access to procedure 'sys.sp_OAMethod' of component 'Ole
Automation Procedures' because this component is turned off as part of the
security configuration for this server. A system administrator can enable
the
use of 'Ole Automation Procedures' by using sp_configure. For more
information about enabling 'Ole Automation Procedures', see "Surface Area
Configuration" in SQL Server Books Online.
Execute DDL to create 'EXCELSQL' worksheet
Mens 15281, Nivel 16, Estado 1, Procedimiento sp_OAMethod, Línea 1
SQL Server blocked access to procedure 'sys.sp_OAMethod' of component 'Ole
Automation Procedures' because this component is turned off as part of the
security configuration for this server. A system administrator can enable
the
use of 'Ole Automation Procedures' by using sp_configure. For more
information about enabling 'Ole Automation Procedures', see "Surface Area
Configuration" in SQL Server Books Online.
Destroyed OLE ADODB.Connection object
Mens 15281, Nivel 16, Estado 1, Procedimiento sp_OADestroy, Línea 1
SQL Server blocked access to procedure 'sys.sp_OADestroy' of component
'Ole
Automation Procedures' because this component is turned off as part of the
security configuration for this server. A system administrator can enable
the
use of 'Ole Automation Procedures' by using sp_configure. For more
information about enabling 'Ole Automation Procedures', see "Surface Area
Configuration" in SQL Server Books Online.
Created Linked Server 'EXCEL_TEST' and Login
Mens. 121, Nivel 15, Estado 1, Línea 1
The select list for the INSERT statement contains more items than the
insert
list. The number of SELECT values must match the number of INSERT columns.
Populated 'EXCELSQL' table with 1 Rows
Deleted Linked Server 'EXCEL_TEST' and Login
Respuesta Responder a este mensaje
#7 Gustavo Larriera (MVP)
11/07/2007 - 20:50 | Informe spam
Usa el Surface Area Configuration y configura que vas a permitir la ejecución
de objetos OLE Automation.

Gustavo Larriera, Microsoft MVP
https://mvp.support.microsoft.com/p...o.Larriera
Este mensaje se proporciona tal como es, sin garantías de ninguna clase.



"Pedro" wrote:

Estoy exportado a excel y me encuentro con unos errores saben por que puede
ser?
Os dajunto los erreres con un pequeño detalle:

Created OLE ADODB.Connection object
Mens 15281, Nivel 16, Estado 1, Procedimiento sp_OACreate, Línea 1
SQL Server blocked access to procedure 'sys.sp_OACreate' of component 'Ole
Automation Procedures' because this component is turned off as part of the
security configuration for this server. A system administrator can enable the
use of 'Ole Automation Procedures' by using sp_configure. For more
information about enabling 'Ole Automation Procedures', see "Surface Area
Configuration" in SQL Server Books Online.
Assigned ConnectionString property
Mens 15281, Nivel 16, Estado 1, Procedimiento sp_OASetProperty, Línea 1
SQL Server blocked access to procedure 'sys.sp_OASetProperty' of component
'Ole Automation Procedures' because this component is turned off as part of
the security configuration for this server. A system administrator can enable
the use of 'Ole Automation Procedures' by using sp_configure. For more
information about enabling 'Ole Automation Procedures', see "Surface Area
Configuration" in SQL Server Books Online.
Open Connection to XLS, for file Create or Append
Mens 15281, Nivel 16, Estado 1, Procedimiento sp_OAMethod, Línea 1
SQL Server blocked access to procedure 'sys.sp_OAMethod' of component 'Ole
Automation Procedures' because this component is turned off as part of the
security configuration for this server. A system administrator can enable the
use of 'Ole Automation Procedures' by using sp_configure. For more
information about enabling 'Ole Automation Procedures', see "Surface Area
Configuration" in SQL Server Books Online.
Execute DDL to create 'EXCELSQL' worksheet
Mens 15281, Nivel 16, Estado 1, Procedimiento sp_OAMethod, Línea 1
SQL Server blocked access to procedure 'sys.sp_OAMethod' of component 'Ole
Automation Procedures' because this component is turned off as part of the
security configuration for this server. A system administrator can enable the
use of 'Ole Automation Procedures' by using sp_configure. For more
information about enabling 'Ole Automation Procedures', see "Surface Area
Configuration" in SQL Server Books Online.
Destroyed OLE ADODB.Connection object
Mens 15281, Nivel 16, Estado 1, Procedimiento sp_OADestroy, Línea 1
SQL Server blocked access to procedure 'sys.sp_OADestroy' of component 'Ole
Automation Procedures' because this component is turned off as part of the
security configuration for this server. A system administrator can enable the
use of 'Ole Automation Procedures' by using sp_configure. For more
information about enabling 'Ole Automation Procedures', see "Surface Area
Configuration" in SQL Server Books Online.
Created Linked Server 'EXCEL_TEST' and Login
Mens. 121, Nivel 15, Estado 1, Línea 1
The select list for the INSERT statement contains more items than the insert
list. The number of SELECT values must match the number of INSERT columns.
Populated 'EXCELSQL' table with 1 Rows
Deleted Linked Server 'EXCEL_TEST' and Login
email Siga el debate Respuesta Responder a este mensaje
Ads by Google
Help Hacer una pregunta AnteriorRespuesta Tengo una respuesta
Search Busqueda sugerida