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.
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:
Post Comments (Atom)
No comments:
Post a Comment