dbTalk Databases Forums  

Lost permission after restore of MSDB

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts


Discuss Lost permission after restore of MSDB in the microsoft.public.sqlserver.dts forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Lotta
 
Posts: n/a

Default Lost permission after restore of MSDB - 03-02-2004 , 07:41 AM






Hi

We restored several db's, including msdb and master, and now some users no longer have permission to run some DTS packages and backup jobs. We use Windows authentication and the login is a member of administrator group on the server
Anyone have any idea why and what to do about it? I ran sp_change_users_login whith no reported users

Thank
/Lotta

Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.