VS2005: Beta2 install fails during Sql Server 2005 Express install

Beware if you are installing Visual Studio 2005 Beta2 on a PC with an existing SQL Server 2000 installation, because it will cause the setup to throw an error, eventhough it continues to successfully finish the setup.

The default component selection in Visual Studio.NET 2005 Beta2 includes Sql Server 20005 Express Edition and related tools which does not play well with previous installs of Sql Server.   As a result, it leaves your PC in a partially installed state that you must manually correct.

You will notice this the first time you try to connect to a SQL Server instance and receive the following error:

"Data source name not found and no default driver specified."

The obvious part is that you have to uninstall all of the newly added Sql Server 2005 related tools, including the "Sql Native Client".   This corrects most problems, but if you open Sql Enterprise Manager or similar tools, you may receive an error saying it cannot initialize SQL DMO. 

All you need to do is re-register the COM+ dll named SQLDMO.DLL and this will be fixed.

C:\regsvr32 sqldmo.dll

This isnt rocket science, but I ran into this again today and had to scratch my head for a while to remember how to fix this.  Hopefully this will save me (and maybe others) time in the future.

See also: http://support.microsoft.com/default.aspx?scid=kb;EN-US;248241 (re: sqldmo.dll issues)