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 «««1234

Windows authentication only allows login with sysadmin role Expand / Collapse
Author
Message
Posted Monday, April 14, 2014 8:40 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 9:10 AM
Points: 5,437, Visits: 10,129
It's for your consumption rather than mine. You stated that all logins have master as the default database - I just wanted you to check that that is indeed the case by running the query. If it doesn't return any rows, you're right. If it does, you need to check whether the default database for the logins returned exist and that the logins have permissions on them.

John
Post #1561500
Posted Monday, April 14, 2014 9:26 AM


SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Today @ 6:04 AM
Points: 488, Visits: 1,993
Hi John,

The three rows it returns aren't really of any concern. The logins are for running client specific SSIS packages, and have the appropriate DB as their default.

Thanks
Post #1561524
« Prev Topic | Next Topic »

Add to briefcase «««1234

Permissions Expand / Collapse