Re: How do people use SQL in Win authenticated mode only?
From: Krystian Zieja / mob (mob_at_pjwstk.edu.pl)
Date: 05/27/04
- Next message: Falko Schmidt: "Response time of the Enterprise of manager"
- Previous message: DaveK: "How do people use SQL in Win authenticated mode only?"
- In reply to: DaveK: "How do people use SQL in Win authenticated mode only?"
- Next in thread: Rand Boyd [MSFT]: "Re: How do people use SQL in Win authenticated mode only?"
- Reply: Rand Boyd [MSFT]: "Re: How do people use SQL in Win authenticated mode only?"
- Messages sorted by: [ date ] [ thread ]
Date: Thu, 27 May 2004 11:46:04 +0200
DaveK wrote:
> 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
>
you can try to set "sa" as the owner of your jobs - it should help.
regards krystian zieja / mob
- Next message: Falko Schmidt: "Response time of the Enterprise of manager"
- Previous message: DaveK: "How do people use SQL in Win authenticated mode only?"
- In reply to: DaveK: "How do people use SQL in Win authenticated mode only?"
- Next in thread: Rand Boyd [MSFT]: "Re: How do people use SQL in Win authenticated mode only?"
- Reply: Rand Boyd [MSFT]: "Re: How do people use SQL in Win authenticated mode only?"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
