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.

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 "login does not have acces to server"

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
Go to Top of Page

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!
Go to Top of Page

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
Go to Top of Page

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
Go to Top of Page

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!
Go to Top of Page
   

- Advertisement -