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
Posted Monday, April 14, 2014 8:40 AM



Group: General Forum Members
Last Login: Yesterday @ 4:28 AM
Points: 5,488, Visits: 10,339
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.

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



Group: General Forum Members
Last Login: 2 days ago @ 4:02 PM
Points: 492, Visits: 2,040
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.

Post #1561524
« Prev Topic | Next Topic »

Add to briefcase «««1234

Permissions Expand / Collapse