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 '09 at 07:28 AM in Default

David 2 1 gravatar image

David 2 1
412 42 49 51

(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 '09 at 07:32 AM

Madhivanan gravatar image

Madhivanan
1.1k 1 3 6

The agent has been started and I am right clicking and selecting 'start job' however that is when my error appears.
Nov 13 '09 at 07:37 AM David 2 1
have you looked into the error message in the history? what's the error message?
Dec 11 '09 at 01:01 PM Rajib Bahar
(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 '09 at 11:39 AM

Kristen gravatar image

Kristen ♦
2.2k 6 7 10

Hi Kristen. The job has been set up to run as the sa user and I have logged on as the sa user to try to run it however that's when I get the error.
Nov 13 '09 at 11:54 AM David 2 1
Check the SQL Server (Error) log in case that sheds any light. Check that the Default Database for SA has not been DROPped or in some other way is no longer available
Nov 13 '09 at 03:37 PM Kristen ♦
Okay thanks. Default database is master and is available. Could it be some role/priv thing????
Nov 17 '09 at 01:41 PM David 2 1
Sounds like the user that SQL Agent is set up for is a user that has changed password, or default database missing. SQL Agent might not be set up to log in as SA.
Nov 17 '09 at 02:11 PM Kristen ♦
(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.

New code box

There's a new way to format code on the site - the red speech bubble logo will automatically format T-SQL for you. The original code box is still there for XML, etc. More details here.

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:

x472
x86
x85

asked: Nov 13 '09 at 07:28 AM

Seen: 1118 times

Last Updated: Nov 13 '09 at 07:28 AM