Removing edit.

We ran into a similar problem when installing SQL 2012 on a Server 2012 VMWare ESXi 5.x host. The audit policy was our first thought and with enterprise GPOs...

The IE setting may have been locked down tight so that ActiveX controls cannot be installed. Win7 User Access Control could also be affecting that. You can try running...

Try the SQL Server Import/Export Wizard.

I've been running a trace for the deprecated announcement events.

http://msdn.microsoft.com/en-us/library/ms186302.aspx

Something else I did for the older 80 compatibility databases was trace T-SQL for signs of non-ansi joins like *= and...

Need to....maybe not. Should you....might make recovery easier.

http://msdn.microsoft.com/en-us/library/ms155814.aspx

The only reason to backup the reportservertempdb is to avoid having to recreate it if there is a hardware failure. In the...

Has there been any hardware changes recently?

I only ask since I had a similar issue come up once....and it was after I upgraded the memory on the server from 4GB...

It might be a permissions issue. Check to see what permissions the SSIS package executes with and compare that to the permissions that are used when running it manually.

Here is a script I tossed together based on something I read in the 70-432 book. It will reorganize indexes or rebuild indexes based on thresholds. The variables at...

I saw several posts about queries with Linked Servers and I thought I'd toss out another alternative if you have a SQL 2008 installation...Central Management Servers. I setup one with...

I would check the client protocols for both 64bit and 32bit. From what I've seen the protocols are enabled separately.

I've had mixed results when it comes to restoring system databases. Lately I've given up on that and used a few other methods to make migrating/consolidating servers easier.

I have used...

I really should have specified that our entire environment is virtual, and the licensing...