Solved

Job failed for cannot connect to local server

Posted on 2011-02-15
4
400 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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

NEW Veeam Agent for Microsoft Windows

Backup and recover physical and cloud-based servers and workstations, as well as endpoint devices that belong to remote users. Avoid downtime and data loss quickly and easily for Windows-based physical or public cloud-based workloads!

Question has a verified solution.

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

International Data Corporation (IDC) prognosticates that before the current the year gets over disbursing on IT framework products to be sent in cloud environs will be $37.1B.
I have a large data set and a SSIS package. How can I load this file in multi threading?
Via a live example, show how to set up a backup for SQL Server using a Maintenance Plan and how to schedule the job into SQL Server Agent.
Via a live example, show how to shrink a transaction log file down to a reasonable size.

688 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