Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase ««12

Failed to Login to SQL Server - when using Litespeed Restore Wizard Expand / Collapse
Author
Message
Posted Monday, January 09, 2012 7:25 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Thursday, October 04, 2012 11:13 AM
Points: 257, Visits: 80
I had the same problem except that one database out of job with 12 restores and multiple other jobs with a total around 250 restores would fail.

While the job is owned by SA (helps avoids windows authentication issues) the Service account was a login on the server but not part of the SysAdmin role except through Administrators group permission.

I gave the service account SysAdmin role, and hopefully this will work from now on.

Post #1232409
« Prev Topic | Next Topic »

Add to briefcase ««12

Permissions Expand / Collapse