x

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.

more ▼

asked Nov 13, 2009 at 07:28 AM in Default

avatar image

David 2 1
732 54 57 65

(comments are locked)
10|1200 characters needed characters left

2 answers: sort voted first

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

answered Nov 13, 2009 at 07:32 AM

avatar image

Madhivanan
1.1k 2 5 9

(comments are locked)
10|1200 characters needed characters left

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

more ▼

answered Nov 13, 2009 at 11:39 AM

avatar image

Kristen ♦
2.2k 7 11 14

(comments are locked)
10|1200 characters needed characters left
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.

Topics:

x501
x107
x98

asked: Nov 13, 2009 at 07:28 AM

Seen: 1523 times

Last Updated: Nov 13, 2009 at 07:28 AM

Copyright 2016 Redgate Software. Privacy Policy