RE: How do people use SQL in Win authenticated mode only?

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

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

Next message: C. Ming Lu: "How to alter a column name by using script"
Previous message: Rasmus: "Re: Programatically find out the SQL Server Version and SP via registry or WMI?"
In reply to: Ken Dutton: "RE: 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 06:06:06 -0700

Yes I fixed it by setting sa to own all jobs, but the question was about the number of times when I've had to use sql logins where I would have used NT logins because of issues like this and the double hop issue.

Thanks

DaveK

http://www.sqlporn.co.uk

Next message: C. Ming Lu: "How to alter a column name by using script"
Previous message: Rasmus: "Re: Programatically find out the SQL Server Version and SP via registry or WMI?"
In reply to: Ken Dutton: "RE: 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

Re: How do people use SQL in Win authenticated mode only?
... 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: ...
(microsoft.public.sqlserver.server)
Re: How do people use SQL in Win authenticated mode only?
... 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: ...
(microsoft.public.sqlserver.security)