SQLSate 42000 Error 8198

[agianduso]

I'm running SQL 2000 on a Windows 2003 Server. I'm trying to access an Access table on a Windows 2000 server. I'm recieving the following error message:

The job failed. Unable to determine if the owner of job Copy xxxx table has server access. (reason: Could not obtain information about Windows NT group/user xxxxx)(SQLSate 42000) (Error 8198).

Please help.

Thank you,

Tony

 

[OrWolf]

I'm getting the exact same error and was wondering if you were able to find a solution?

Thanks,

Bill

 

[SQLSister]

At a guess I would think that the server the Access database on doesn't have the user in it that you are using to call for the information. This can happen when things are run as a job and the SQL Server Agent does not have rights on another server.

Questions about posting. See faq183-874

 

[SQLBill]

Quick check...what Login AS is shown for MSSQLServer and SQLServerAgent services? (If you are using a named instance, make sure you check the proper services - for named instances the services will have $instance_name at the end).

The accounts need to be domain accounts and have access to the computer with Access as SQLSister pointed out.

-SQLBill

 

[weigoldk]

I'm having a simular problem.

Here's my error:

The job failed. Unable to determine if the owner (mydomain\myadminuser) of job "jobname" backup has server access (reason: Could not obtain information about Windows NT group/user 'mydomain\myadminuser'. [SQLSTATE 42000] (Error 8198)).

I am trying to use a JOB to do a nightly backup.

I checked the following:
myadminuser is an administrator on the Win 2003 server where SQL 2000 is installed.
The logon for MSSQLServer and SQLServerAgent services is myadminuser.
myadminuser is a user on the database
under the rols for the database, myadminuser is a db_backupoperator

I'm logged into the server as myadminuser. I can do a backup from microsoft SQL Servers/SQL Server Group/Local/Management/Backup, but when I add in the option to schedule it as a job, it then fails.

I'm very new to SQL server and don't know where to look--so thanks in advance for your help.

 

[SQLBill]

Where are you backing up to? Does myadminuser have permissions to access that location?

(you really should have started your own thread, not reopened one from almost a year ago).

-SQLBill

Posting advice: FAQ481-4875

 

[weigoldk]

SQL Bill--I will open a new thread.

I'm backing up to the C drive on the same server--and yes myadminuser has right.