question

David 2 1 avatar image
David 2 1 asked

How To Execute Jobs From The SQL Server Enterprise Manager

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.

sql-server-2000sql-agentjob
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

2 Answers

·
Madhivanan avatar image
Madhivanan answered 
            
1 Check SQL Server Agent is started            
2 Right click on the job and select Run
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Kristen avatar image
Kristen answered

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

10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.