Re: Builtin\Administrator does not have server access
- From: "Dan Guzman" <guzmanda@xxxxxxxxxxxxxxxxxxxxxxxxxxx>
- Date: Sat, 3 May 2008 11:37:23 -0500
Try changing the job owner to 'sa'.
--
Hope this helps.
Dan Guzman
SQL Server MVP
http://weblogs.sqlteam.com/dang/
"A.W.E.S.O.M-O" <galois55@xxxxxxxxx> wrote in message news:15b13e66-197a-4504-85c4-aad960bb6e20@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
I have a stable job that was consistantly running without errors.
When my server was moved to a different IP addresss/location my job
stopped running giving me the following error
"The owner () of job LoadData does not have server access"
The owner is Builtin\Administrator but does not appear in the error
message above. I suspect it's an active directory problem. There is
no domain controller at the servers new site.
.
- References:
- Builtin\Administrator does not have server access
- From: A.W.E.S.O.M-O
- Builtin\Administrator does not have server access
- Prev by Date: Re: Permission issue?
- Next by Date: Re: SQL2005 non-administrator Service Account
- Previous by thread: Builtin\Administrator does not have server access
- Next by thread: Regarding migrate login/user infomation to new db in new server
- Index(es):
Relevant Pages
|
|
