May 5, 2005 at 7:05 pm
Hello everybody, regards!
It happens that we have SQL SERVER 2000 and we have problems with the SQL SERVER AGENT, we have defined some jobs for running at night and making the database backups, but sometimes they don't run, so we have to do the backup manually. I'm not sure but I think it may be something related with the windows account is defined in the SQL SERVER AGENT.
There are 2 accounts, ADMINISTRATOR (windows obviously) and SQLADMIN (which the site administrator created for me), previously the SQL SERVER AGENT had the ADMINISTRATOR account, and I had no problems usually, but now I have the problems, at this very moment it has the LOCAL ACCOUNT, sometimes I change it to SQLADMIN, I have problems!!! sometimes it runs, sometimes it doesn't, and something else: sometimes my partner, the site administrator, log on as ADMINISTRATOR into the server, sometimes I log on as SQLADMIN.
I got confused so I want to know how it has to be, how should I log on into the server when I need it?, how should my partner log on into the server when he needs? does it affect when he logs on as ADMINISTRATOR? which is the account that has to be set up in the SQL SERVER AGENT?
I'd appreciate a lot if any of you could help me a little with this matter...ok???
Thanks a lot everyboy,
Amaury, regards
L.I. Amaury C.R.
May 9, 2005 at 8:00 am
This was removed by the editor as SPAM
May 9, 2005 at 8:25 am
Hello, thanks for this message, I'd appreciate if anyone could tell me, what kind of privileges does the windows account need, I mean the windows account that is defined foe the SQL SERVER AGENT,
Thanks a lot,
L.I. Amaury C.R.
May 10, 2005 at 12:48 am
Why u are posting the same problem in every section?????????.And this is already answered in general section.Try to keep following the post in the same section.
http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=9&messageid=180407
May 10, 2005 at 1:03 am
It must be a member of Administrator group on local computer and there for it must be member of the sysadmin role Within sql server
May 10, 2005 at 1:50 am
Can u clarify the following.
1. The job u are running has any need to access resources across network?
2.What is the service start up A/c of sql server agent . ie System a/c or this a/c.?
3. Whether the above a/c has sysadmin role on the local sql server instance u are running?
Rafi-
May 11, 2005 at 12:43 am
You have to create the job directly at the Database Maintenance and not at the SQL Server Agent for the job to function regularly and consistently. I have experienced the same problem when I was a new user of SQL Server 2000. The same is true when you want to edit or make some changes in your maintenance plans.Changes will automatically be effected in the SQL Server Agent
May 16, 2005 at 11:36 am
Thank you very much, your answer was very helpful,
Regards,
Amaury
L.I. Amaury C.R.
May 16, 2005 at 10:26 pm
Welcome,nice to hear that it was helpful.
Regds
Rafi-
Viewing 9 posts - 1 through 8 (of 8 total)
You must be logged in to reply to this topic. Login to reply