Post reply

Windows authentication only allows login with sysadmin role

  • April 14, 2014 at 8:40 am

    #1705780

    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

  • April 14, 2014 at 9:26 am

    #1705794

    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

Viewing 2 posts - 31 through 31 (of 31 total)

You must be logged in to reply to this topic. Login to reply