Problemas posteriores al SP3

07/06/2004 - 16:55 por Ramon Zarza | Informe spam
Colegas..

Realice la actualización del SQL con SP3 y a partir de ese momento los
uusarios de un sistema no pueden ingresar a realizar un INSERT

Todos los usuariso son simples ususarios de la red de W2K

la seguridad del SP es por intregracion con el Windows.

personalmente asigno los permisos necesarios al grupo que puede realizar la
actividad.

pero me devuelve este error. Y ocuure desde la actualizacion del SP3.. antes
todo funcionaba muy bien

Alguien tiene idea de que puede pasar...

Agradezco su ayuda --
Les dejo el mensaje de error

Saludos
*********************************************

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

Server: Msg 229, Level 14, State 5, Procedure sp_OACreate, Line 27
EXECUTE permission denied on object 'sp_OACreate', database 'master', owner
'dbo'.
Server: Msg 229, Level 14, State 5, Procedure sp_OASetProperty, Line 33
EXECUTE permission denied on object 'sp_OASetProperty', database 'master',
owner 'dbo'.
Server: Msg 229, Level 14, State 5, Procedure sp_OASetProperty, Line 36
EXECUTE permission denied on object 'sp_OASetProperty', database 'master',
owner 'dbo'.
Server: Msg 229, Level 14, State 5, Procedure sp_OAMethod, Line 39
EXECUTE permission denied on object 'sp_OAMethod', database 'master', owner
'dbo'.
Server: Msg 229, Level 14, State 5, Procedure sp_OASetProperty, Line 42
EXECUTE permission denied on object 'sp_OASetProperty', database 'master',
owner 'dbo'.
Server: Msg 229, Level 14, State 5, Procedure sp_OASetProperty, Line 43
EXECUTE permission denied on object 'sp_OASetProperty', database 'master',
owner 'dbo'.
Server: Msg 229, Level 14, State 5, Procedure sp_OASetProperty, Line 44
EXECUTE permission denied on object 'sp_OASetProperty', database 'master',
owner 'dbo'.
Server: Msg 229, Level 14, State 5, Procedure sp_OASetProperty, Line 47
EXECUTE permission denied on object 'sp_OASetProperty', database 'master',
owner 'dbo'.
Server: Msg 229, Level 14, State 5, Procedure sp_OAMethod, Line 49
EXECUTE permission denied on object 'sp_OAMethod', database 'master', owner
'dbo'.

(1 row(s) affected)

Server: Msg 229, Level 14, State 5, Procedure sp_OAGetErrorInfo, Line 55
EXECUTE permission denied on object 'sp_OAGetErrorInfo', database 'master',
owner 'dbo'.
sp_OAGetErrorInfo failed.

(1 row(s) affected)


(1 row(s) affected)


(1 row(s) affected)

Server: Msg 229, Level 14, State 5, Procedure sp_OACreate, Line 27
EXECUTE permission denied on object 'sp_OACreate', database 'master', owner
'dbo'.
Server: Msg 229, Level 14, State 5, Procedure sp_OASetProperty, Line 33
EXECUTE permission denied on object 'sp_OASetProperty', database 'master',
owner 'dbo'.
Server: Msg 229, Level 14, State 5, Procedure sp_OASetProperty, Line 36
EXECUTE permission denied on object 'sp_OASetProperty', database 'master',
owner 'dbo'.
Server: Msg 229, Level 14, State 5, Procedure sp_OAMethod, Line 39
EXECUTE permission denied on object 'sp_OAMethod', database 'master', owner
'dbo'.
Server: Msg 229, Level 14, State 5, Procedure sp_OASetProperty, Line 42
EXECUTE permission denied on object 'sp_OASetProperty', database 'master',
owner 'dbo'.
Server: Msg 229, Level 14, State 5, Procedure sp_OASetProperty, Line 43
EXECUTE permission denied on object 'sp_OASetProperty', database 'master',
owner 'dbo'.
Server: Msg 229, Level 14, State 5, Procedure sp_OASetProperty, Line 44
EXECUTE permission denied on object 'sp_OASetProperty', database 'master',
owner 'dbo'.
Server: Msg 229, Level 14, State 5, Procedure sp_OASetProperty, Line 47
EXECUTE permission denied on object 'sp_OASetProperty', database 'master',
owner 'dbo'.
Server: Msg 229, Level 14, State 5, Procedure sp_OAMethod, Line 49
EXECUTE permission denied on object 'sp_OAMethod', database 'master', owner
'dbo'.

(1 row(s) affected)

Server: Msg 229, Level 14, State 5, Procedure sp_OAGetErrorInfo, Line 55
EXECUTE permission denied on object 'sp_OAGetErrorInfo', database 'master',
owner 'dbo'.
sp_OAGetErrorInfo failed.

(1 row(s) affected)


(1 row(s) affected)
 

Leer las respuestas

#1 Maxi
07/06/2004 - 17:11 | Informe spam
Hmmm y ese Store que hace?


Salu2
Maxi
Buenos Aires - Argentina
Desarrollador Microsoft 3 Estrellas .NET
Nunca consideres el estudio como una obligación sino como
una oportunidad para penetrar en el bello y maravillosos
mundo del saber.
- Albert Einstein



"Ramon Zarza" escribió en el mensaje
news:u%
Colegas..

Realice la actualización del SQL con SP3 y a partir de ese momento los
uusarios de un sistema no pueden ingresar a realizar un INSERT

Todos los usuariso son simples ususarios de la red de W2K

la seguridad del SP es por intregracion con el Windows.

personalmente asigno los permisos necesarios al grupo que puede realizar


la
actividad.

pero me devuelve este error. Y ocuure desde la actualizacion del SP3..


antes
todo funcionaba muy bien

Alguien tiene idea de que puede pasar...

Agradezco su ayuda --
Les dejo el mensaje de error

Saludos
*********************************************

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

Server: Msg 229, Level 14, State 5, Procedure sp_OACreate, Line 27
EXECUTE permission denied on object 'sp_OACreate', database 'master',


owner
'dbo'.
Server: Msg 229, Level 14, State 5, Procedure sp_OASetProperty, Line 33
EXECUTE permission denied on object 'sp_OASetProperty', database 'master',
owner 'dbo'.
Server: Msg 229, Level 14, State 5, Procedure sp_OASetProperty, Line 36
EXECUTE permission denied on object 'sp_OASetProperty', database 'master',
owner 'dbo'.
Server: Msg 229, Level 14, State 5, Procedure sp_OAMethod, Line 39
EXECUTE permission denied on object 'sp_OAMethod', database 'master',


owner
'dbo'.
Server: Msg 229, Level 14, State 5, Procedure sp_OASetProperty, Line 42
EXECUTE permission denied on object 'sp_OASetProperty', database 'master',
owner 'dbo'.
Server: Msg 229, Level 14, State 5, Procedure sp_OASetProperty, Line 43
EXECUTE permission denied on object 'sp_OASetProperty', database 'master',
owner 'dbo'.
Server: Msg 229, Level 14, State 5, Procedure sp_OASetProperty, Line 44
EXECUTE permission denied on object 'sp_OASetProperty', database 'master',
owner 'dbo'.
Server: Msg 229, Level 14, State 5, Procedure sp_OASetProperty, Line 47
EXECUTE permission denied on object 'sp_OASetProperty', database 'master',
owner 'dbo'.
Server: Msg 229, Level 14, State 5, Procedure sp_OAMethod, Line 49
EXECUTE permission denied on object 'sp_OAMethod', database 'master',


owner
'dbo'.

(1 row(s) affected)

Server: Msg 229, Level 14, State 5, Procedure sp_OAGetErrorInfo, Line 55
EXECUTE permission denied on object 'sp_OAGetErrorInfo', database


'master',
owner 'dbo'.
sp_OAGetErrorInfo failed.

(1 row(s) affected)


(1 row(s) affected)


(1 row(s) affected)

Server: Msg 229, Level 14, State 5, Procedure sp_OACreate, Line 27
EXECUTE permission denied on object 'sp_OACreate', database 'master',


owner
'dbo'.
Server: Msg 229, Level 14, State 5, Procedure sp_OASetProperty, Line 33
EXECUTE permission denied on object 'sp_OASetProperty', database 'master',
owner 'dbo'.
Server: Msg 229, Level 14, State 5, Procedure sp_OASetProperty, Line 36
EXECUTE permission denied on object 'sp_OASetProperty', database 'master',
owner 'dbo'.
Server: Msg 229, Level 14, State 5, Procedure sp_OAMethod, Line 39
EXECUTE permission denied on object 'sp_OAMethod', database 'master',


owner
'dbo'.
Server: Msg 229, Level 14, State 5, Procedure sp_OASetProperty, Line 42
EXECUTE permission denied on object 'sp_OASetProperty', database 'master',
owner 'dbo'.
Server: Msg 229, Level 14, State 5, Procedure sp_OASetProperty, Line 43
EXECUTE permission denied on object 'sp_OASetProperty', database 'master',
owner 'dbo'.
Server: Msg 229, Level 14, State 5, Procedure sp_OASetProperty, Line 44
EXECUTE permission denied on object 'sp_OASetProperty', database 'master',
owner 'dbo'.
Server: Msg 229, Level 14, State 5, Procedure sp_OASetProperty, Line 47
EXECUTE permission denied on object 'sp_OASetProperty', database 'master',
owner 'dbo'.
Server: Msg 229, Level 14, State 5, Procedure sp_OAMethod, Line 49
EXECUTE permission denied on object 'sp_OAMethod', database 'master',


owner
'dbo'.

(1 row(s) affected)

Server: Msg 229, Level 14, State 5, Procedure sp_OAGetErrorInfo, Line 55
EXECUTE permission denied on object 'sp_OAGetErrorInfo', database


'master',
owner 'dbo'.
sp_OAGetErrorInfo failed.

(1 row(s) affected)


(1 row(s) affected)







Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.698 / Virus Database: 455 - Release Date: 02/06/2004

Preguntas similares