This happened to me as well, and it happened because the AD password changed.

By going into Enterprise Manager > Server > Security > Credentials, and opening up the proxy account...

I just had this problem and figured it out.

Delete the bin\ directory and rebuild.

A bin\ dir from a foreign machine seems to give it fits.

HTH,

Jason

gk-411903 (8/9/2010)

---

The following is what i do in my setup.

When the Report URL is clicked, username/password will be prompted as part of Authentication (in the absence of customer authentication such...

Thank you -

Glad I could help.

TempDB is just one aspect of it, however.

I don't know of one, all-encompasing SQL Server Checklist.

This is a "performance" checklist, but it...

Best choice would be for the net admin to create a new partition on the SAN, and put all TempDB files there.

Next best choice...that's tough. If your performance is...

What is your db size?

Checklists would vary, depending on whether you're running a 500MB database, a 10GB database, or a 1 TB database.

http://searchsqlserver.techtarget.com/tip/0,289483,sid87_gci1180698,00.html

This article, combined with my own experiences, forms the basis of my above post.

Can you replicate it at will? (On a development server, of course?)

If so...turn on SQL Profiler - it is a tricky and complex tool, however you should be...

There is an option to select "All Databases" on a server.

So, if new databases are added later, your Rebuild Indexes task will automatically cover it.

Create a new Maintenance Plan on each server.

Use the Rebuild Index feature.

You get free logging thrown in.

Very easy to set up.

Isolate the activity, if you can.

Do you have a Beta/QA environment?

Find out what processes are blocking each other.

Usually things are going in conflicting order.

Rewrite one so it harmonizes with the...

Tune the TempDB.

TempDB is so much more important in SQL 2005 than it was in earlier versions.

And the default settings of 8MB / 1MB with 10% growth is a recipe...

Thank you others, as well.

I've never used the WMI before.....so many technologies......

thanks again.

This is the stored proc I wrote to analyze the PerfMon counter stats:

/****** Object: StoredProcedure [dbo].[spSelectFreeDiskSpace] Script Date: 09/18/2008 11:41:17 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

-- =============================================

--...

Also, I can run Reporting Services reports on this, set up a subscription to email them out, etc.

Very useful stuff.