Mssql management studio issues – DB in general

Error while opening Mssql 2005 management studio

MMC could not create the snap-in.
MMC could not create the snap-in. The snap-in might not have been installed correctly.
Name: Microsoft SQL Enterprise Manager
CLSID: {00100100-1816-11D0-8EF5-00AA0062C58F}

Fix

Run the following command as shown to fix this. Make sure you have installed the Msql in the path as shown or change it accordingly.
Run -> C:\Program Files\Microsoft SQL Server\80\Tools\binn>regsvr32 sqldmo.dll

Database showing ’0 items’ in MsSQL mgmt studio

If a working database shows no items then

1.  MsSQL mgmt studio -> Right click the database -> Bring it to offline

2. Now bring it back to online after some time. the database will show all the items.
Problem in connecting database using Microsoft SQL server management studio.

1.  In connection dialog box -> Connection properties -> Connect to database -> Change to “master”

2.  Once this is performed, try connecting to the database again.