Please start any new threads on our new site at We've got lots of great SQL Server experts to answer whatever question you can come up with.

Our new SQL Server Forums are live! Come on over! We've restricted the ability to create new threads on these forums.

SQL Server Forums
Profile | Active Topics | Members | Search | Forum FAQ
Save Password
Forgot your Password?

 All Forums
 SQL Server 2000 Forums
 Transact-SQL (2000)
 Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

Starting Member

1 Posts

Posted - 01/31/2012 :  22:23:04  Show Profile  Reply with Quote
Hi All.....How are you?

I am very new to SQL Server and I must say that your blog has helped me a lot in the past.

I am struggling with a problem and may be you could help me a little.

I have a problem whereby the JOBS Scheduled in SQLServer are failing with the error as below

Executed as user: SmartInfoApplication. error executing method [SQLSTATE 01000] (Message 0) SIReport [SQLSTATE 01000] (Message 0) The remote server machine does not exist or is unavailable [SQLSTATE 01000] (Message 0) Error Running Report [SQLSTATE 42000] (Error 50000). The step failed.

The version of SQLSERVER is

Microsoft SQL Server 2000 - 8.00.2039 (Intel X86) May 3 2005 23:18:38 Copyright (c) 1988-2003 Microsoft Corporation Enterprise Edition on Windows NT 5.2 (Build 3790: Service Pack 2)

The job definition is in the attached file......The first step of the job is a Transact SQL which is as follows

exec csp_CR_Run 2706883

The definition of SP is in the attached file and also on the link

When i run the step SQL Code manually in Query analyzer, i get this

error executing method
The remote server machine does not exist or is unavailable
Server: Msg 50000, Level 18, State 1, Line 3
Error Running Report

At times, i even get the error permission denied but interestingly the error disappears after a while.

Even this error that I indicated above is seen only intermittently and does not happen always. We are at a loss in trying to troubleshoot this as the behavior is quite random.

Appreciate if you could guide me with this one.

Very Important crosS Applying yaK Herder

52326 Posts

Posted - 02/01/2012 :  09:55:13  Show Profile  Reply with Quote
does query use a remote linked server connection? first check and see if connection is active and table/data is accesible

SQL Server MVP

Go to Top of Page
  Previous Topic Topic Next Topic  
 Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.02 seconds. Powered By: Snitz Forums 2000