How To Execute Jobs From The SQL Server Enterprise Manager

Question

Hi there,

I am still new to SQL Server so apologies if this is a very simple question however I'd like to know how I can execute jobs from the SQL Server 2000 Enterprise Manager GUI as the 'sa' user. Whenever I am logged in as the sa, or any other user and try to run a job I have just created I receive the "sqlserver error 18456 login failed for user sa" error. There must be some sort of permission or privilege fault but can anyone tell me what exactly needs granted or changed?

Thanks in advance.

Answer 1

Answer by Madhivanan · Nov 13, 2009 at 07:32 AM

            
1 Check SQL Server Agent is started            
2 Right click on the job and select Run

1 · Share

Answer 2

Answer by Kristen · Nov 13, 2009 at 11:39 AM

Is the JOB set up to run as a particaulr user (and maybe their password has changed)?

0 · Share

First time here? Check out the FAQ.

How To Execute Jobs From The SQL Server Enterprise Manager

2 Replies

Your answer

Follow this Question

Related Questions

Want long-form discussion and articles? Try