Noel - thanks for the suggestion.

The Distributed Transaction Coordinator service is set for Auto-start on all of the SQL Servers and I did verify that the service is currently running on...

The configuration for "target SQL Server" (the server having the DBA dataqbase/tables being read/updated remotely) is: 1 instance of SQL Server 2000 and 1 instance of SQL 2005.

I've been able...

Well - I had already tried the 'remote login time' (in the original post) - which didn't work. I just tried Alex's 'remote query timeout' - which also did not...

As I mentioned... I did successfully try a linked server. However, my preference is to use the opendatasource. One reason is for using the opendatasource and/or openrowset (imho) is that...

As another attempt:

I deleted the remote SQL Server ReportServer and ReportServerTempDb databases and uninstalled/re-installed the SSRS (SQL) Components from the Report Server. When I reconfigured the Database connection I now...

Thanks Serqiy - that will work just fine!

Glenn

Thanks for the great postings!

I'm in the process of developing a Stored Procedure that will create an expanded/enumerated list of all Schdeul points for SQL Jobs on a server. I'm...

Since I'm planning to record the job execution status (success, fail, and "did not run") in a database table - I'll plan to write some SQL Reporting Service reports to...

I was going to look at SQL Sentry today also. The problem that I've found with some of these tools is that you pay on a SQL instance or server and...

Thanks for the suggestions. However, we're currently using three monitoring tools: Idera's Diagnostic Manager (very nice/expensive tool), SQL Stripes (outstanding tool for full enterprise monitoring - bery inexpensive), and MOM...

Mohammed -

Interesting articles... thanks! They appear however to relate specifically to the windows performance counters versus the SQL Server counters. Since the windows performance counters are currently in place...

Colin the aritcle to which you refer:

http://www.extremeexperts.com/SQL/FAQ/EnablingPerCounters.aspx

Also suggests registry settings...

In my case I checked the registry and found the MSSQLSERVER/Performance settings to be DWORD-identical to another server which...

John - could be... but as this is a core/critical database server... If there's an "easy out" - like installing the performance counters, fixing a dll, etc. It's worth the...

On a test box:

I've installed SQL 2000 (without the performance counters). This simulates the existing scenario. Then I went back and tried to install (update) SQL - hoping to...

I had read the posting which John (above) had referenced and worked through the registry changes. The DWORD doesn't exist and the MS doc doesn't indicate where in the registry...