Solved

Job failed for cannot connect to local server

Posted on 2011-02-15
4
389 Views
Last Modified: 2012-05-11
Expert,

I have one job run in SQL server 2005 EE, one of job failed the error is:

Unable to connect to SQL Server '(local)'.  The step failed.

I used my windows login with sysAdmin permission. I am not know what is the meanning for this error.  Can you tell?

Thank you,

Lynn
0
Comment
Question by:yrcdba7
  • 2
4 Comments
 
LVL 13

Accepted Solution

by:
devlab2012 earned 167 total points
ID: 34898175
Maybe SQL server service was not running at that point or check the instance name of SQL server.
0
 
LVL 15

Assisted Solution

by:Aaron Shilo
Aaron Shilo earned 333 total points
ID: 34898877
is this a one time thing?
do you have other jobs that do work ?
0
 

Author Comment

by:yrcdba7
ID: 34899324
yes, other job works
0
 
LVL 15

Assisted Solution

by:Aaron Shilo
Aaron Shilo earned 333 total points
ID: 34899368
did this specific job ever work ?

if so then some times when the server is outofresources the SQLSERVER rejects sql agent connections and jobs fail.
0

Featured Post

Free Tool: Postgres Monitoring System

A PHP and Perl based system to collect and display usage statistics from PostgreSQL databases.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Find unused columns in a table 12 74
Need help with a query 14 39
Running Total Using new MS SQL Function 21 50
SQL query 7 17
I have a large data set and a SSIS package. How can I load this file in multi threading?
In this article we will learn how to fix  “Cannot install SQL Server 2014 Service Pack 2: Unable to install windows installer msi file” error ?
Via a live example, show how to shrink a transaction log file down to a reasonable size.
Viewers will learn how to use the SELECT statement in SQL to return specific rows and columns, with various degrees of sorting and limits in place.

749 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question