SQL Authentification Settings not sticking for SQL Job

[WayneGretzky]

In any SQL Server 2005 job I create on my server, if I specify SQL Authentfication to run that job, put the information in, then click OK to close, it never sticks. I open back up the job and it resorts back to the Windows Authentification Setting again.

Is this a bug? Bad install? What?

 

[icemel]

I have scheduled many, many jobs in Enterprise Manager (SQL Server 2000), and I have *never* seen an option to select the type of authentication from within the job creation window. Are you sure you are talking about jobs?

 

[Catadmin]

Are you talking about "Run Job as"?

If so, it could be a windows permissions problem. First, make sure you have SysAdmin rights in SQL to be able to make the changes in SQL. If you do, verify you have Power User or Admin rights on the Server you're making the changes on.

If you have all the permissions on the above, then you'll need to delve into your Active Directory groups & "deep" permissions (the hidden Group Policy stuff) to find out if there's a Deny hidden somewhere in there which negates your ability to work on SQL Server or the actual box. Also, verify that you're not part of a group that's mapped to a SQL Login with Deny on anything.

Hope that helps.

Catadmin

Catadmin - MCDBA, MCSA
"If a person is Microsoft Certified, does that mean that Microsoft pays the bills for the funny white jackets that tie in the back???