As for the SQL Express, it is just an SQL Server 2005 database instance. So
if you have installed both SQL Express(by installing vs 2005) and SQL Serve
2005 server database instance, you can use either of them or remove either
of them. for other workstation tools (like management studio, configuration
tools ...), they can work for all those SQL Server 2005 instances, you do
not need to uninstall them. To uninstall the SQL Server Express instance,
you can follow the steps in the below BOL article:
#How to: Uninstall SQL Server Express
as it indicates, you can simply choose the "SQL Server 2005" in the
"control panel--->Add remove programs" panel and them it will let you
select which instance to remove. For your scenario, you should choose "SQL
BTW, after you remove SQL Express on your machine, you may need to adjust
some of the default .net framework 2.0 settings(in machine.config ) also
since some default database connection (for those default ASP.NET
providers) use SQL Express database file.
Hope this helps.
Microsoft MSDN Online Support Lead
This posting is provided "AS IS" with no warranties, and confers no rights.