How do people use SQL in Win authenticated mode only?

From: DaveK (anonymous_at_discussions.microsoft.com)
Date: 05/27/04

  • Next message: Krystian Zieja / mob: "Re: How do people use SQL in Win authenticated mode only?" 
    Date: Thu, 27 May 2004 02:41:02 -0700

    Excuse the naive question but how do people use SQL without allowing SQL logins? I ask because I've hit a problem today with all of my jobs failing with:

    "Unable to determine if the owner (domain\username) of job testjob has server access (reason: Could not obtain information about Windows NT group/user 'domain\username'"

    I looked at the KB article http://support.microsoft.com/default.aspx?scid=kb;en-us;241643 and it says set them a SQL user. They were running as my user (NT login member of sysadmin group). So how could I get around this is if I didn't have any SQL logins. I've never tried Win Auth only so not sure I'm probably missing something obvious. Also, isn't the double hop authentication issue a pain in the backside if you only have NT logins?

    Ta
    DaveK

    http://www.sqlporn.co.uk
     

  • Next message: Krystian Zieja / mob: "Re: How do people use SQL in Win authenticated mode only?"

    Relevant Pages