Hi,
I'm having a problem running jobs. I can not get my test
backup job to work. The job history indicates that
Servername\Administrator can't be determined to have
server access. I recently changed from Windows
Authentication to SQL and Windows.
I'm going through the SQL Server 2000 Administration
Training Kit. I believe that the account that should have
been used is Domainname\Administrator. Also, when I setup
my server initially, which is a domain controller, I used
SelfPacedSQL.local rather than SelfPacedSQL.msft as
instructed, because I could get the .msft domain suffix.
I'm new to Active Directory. Please help.You may be running into a problem with Domain local groups.
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.
Showing posts with label history. Show all posts
Showing posts with label history. Show all posts
Tuesday, March 20, 2012
Permissions Issue Not Allowing Job Run
Labels:
administrator,
allowing,
database,
history,
indicates,
job,
jobs,
microsoft,
mysql,
oracle,
permissions,
run,
running,
server,
sql,
testbackup,
thatservername
Subscribe to:
Posts (Atom)