Please check the Registry keys mentioned in that article thoroughly. Some old key in the registry is causing this issue

Please go through the article that Alex has posted and make sure to clean up the registry and left over files from the previous installation.

Looks like there is some issue with the Hidden Snapshot that SQL Server creates while running DBCC CHECKDB. Read Paul's article here

To ensure that the database is clean, create...

Hi Nic,

I have not encountered any issues with running SQL Server 2008 & SQL Server 2008 R2 side by side. Please go through this article which has the details of...

Did you try running DBCC UPDATEUSAGE?

Since this is SQL Server 2005, it would be Run --> sqlwb

Check if Client components got uninstalled by chance. If so, you reinstall Client Tools by launching SQL Server setup and selecting "Client Components".

The sql server was working fine until one day, the management studio, analysis services disappeared.

I can see only configuration tools.

I went into it and checked sql 2005 services.

it shows, ssis,...

They don't shrink the database, instead they monitor the databases for the defined criteria and alert...

The process that you killed executes a stored procedure which executes the "Demo" alerts to check if they are working. If this process is causing issues, then you can delete...

SSMS --> Database --> User Properties --> Securables --> Search

In the "Permissions" tab select the permissions that needs to be granted on the object

If you browse through "Y:\Microsoft SQL Server\MSSQL.1\MSSQL\LOG\SQLDump0001.txt" file you would get an idea which query triggered this mdmp file. It is better to get in touch with Microsoft PSS because...

The user needs to have view definition permission on the stored procedures.

GRANT VIEW DEFINITION ON SCHEMA::dbo TO UserName

As mentioned earlier, please let us know which Edition of SQL Server 2005 are you trying to install. The issue is due to incompatible edition.

Using the above mentioned examples, please try to figure out which processes are getting dead locked. Also try to find if it is a one time occurring or a recurring...