Solved

Job failed for cannot connect to local server

Posted on 2011-02-15
4
352 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

How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

Join & Write a Comment

I wrote this interesting script that really help me find jobs or procedures when working in a huge environment. I could I have written it as a Procedure but then I would have to have it on each machine or have a link to a server-related search that …
This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function

705 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

Need Help in Real-Time?

Connect with top rated Experts

13 Experts available now in Live!

Get 1:1 Help Now