Error 8198: Unable to determine if the owner has server access...

We recently converted our NT 4 domain to Active Directory, and jobs started
failing with messages like the following. Evidently, SQL Server is having
trouble verifying the credentials of the job owner:
The job failed. Unable to determine if the owner (<Domain>\<user> ) of job
<JobName> has server access (reason: Could not obtain information about
Windows NT group/user (<Domain>\<user> ) '. [SQLSTATE 42000] (Error 8198)
).
I see there are KB articles talking about pre-2000 compatibility, but both
the domain controller and the SQL Server machine are running Windows Server
2003. Does anyone know how to fix this?
(Yes, you can change the job owner as a workaround, but this won't keep
future jobs from being owned by Windows users unless we switch everyone over
to SQL authentication)
Thanks.Check this kb;
825042 FIX: SQL Server Jobs That Are Owned by Non-sysadmin Users May Not
Start
http://support.microsoft.com/?id=825042
Thanks,
Kevin McDonnell
Microsoft Corporation
This posting is provided AS IS with no warranties, and confers no rights.

error 3926 , server failed to resume transaction

In a high load asp.net environment, I am getting an error.

The transation active in this session has been committed or aborted by another session.

Here is the code , I am getting error.

1object returnObject =null;2 SqlTransaction sqlTrans =null;3try4 {5//Getting new SqlConnection6 comm.Connection = GetConnection();7//Opening connection8 OpenConn(comm.Connection);9//beginning transaction10 sqlTrans = comm.Connection.BeginTransaction( IsolationLevel.ReadCommitted );11//setting transaction to SqlCommand object12 comm.Transaction = sqlTrans;13//executing operation14 returnObject = comm.ExecuteScalar();15//trying to commit.16 sqlTrans.Commit();171819 }20catch (SqlException sex)21 {22if (sqlTrans !=null)23 {24 sqlTrans.Rollback();25 }26 }27finally28 {29 comm.Connection.Close();30 }

Could you please explain , am I doing smthg wrong ?

Check out this link: http://forums.microsoft.com/TechNet/ShowPost.aspx?PostID=2041937&SiteID=17

Good luck.

|||

Hi CS4Ever ,

Thanks for the reply, but as far as I understood , Thona just submitted the situation , not a solution and the 3rd reply belongs to me :)

What could I possibly do ? Submit a bug to Microsoft ?

Thanks in advance.

|||

Still no answers ?