Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
Author |
Topic |
harshal_in
Aged Yak Warrior
633 Posts |
Posted - 2004-01-09 : 00:15:52
|
hi all,yesterday our onsite dba changed the logins from domain to work group and after that the backup jobs on all the database failed with the following error:"login does not have access to server"please help,harshal.He is a fool for five minutes who asks , but who does not ask remains a fool for life! |
|
raymondpeacock
Constraint Violating Yak Guru
367 Posts |
Posted - 2004-01-09 : 05:37:44
|
What account does the SQL Server agent run under? Is this account still valid on the server?Raymond |
|
|
harshal_in
Aged Yak Warrior
633 Posts |
Posted - 2004-01-09 : 06:35:20
|
quote: Originally posted by raymondpeacock What account does the SQL Server agent run under? Is this account still valid on the server?Raymond
it is running under local user account.The person on site says that it is a valid account on the server.He is a fool for five minutes who asks , but who does not ask remains a fool for life! |
|
|
raymondpeacock
Constraint Violating Yak Guru
367 Posts |
Posted - 2004-01-09 : 07:13:58
|
Well SQL Server seems to disagree that it's valid account on the server! When you say 'local user account' do you mean the Local System Account or is it a specific user name?Raymond |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-01-09 : 12:07:46
|
You need to check the policy of the account. Also try logging into the database with the account (from the console). You should see the same error, which means that the problem is with the account.Tara |
|
|
harshal_in
Aged Yak Warrior
633 Posts |
Posted - 2004-01-12 : 05:26:20
|
changed the owner of the job to sa.the server is logged on as local admin.it seems to work now.thanks for the help.regrads,harshal.He is a fool for five minutes who asks , but who does not ask remains a fool for life! |
|
|
|
|
|