Problems when I install SQL Express SP1 (CTP)

Hi All,

I have installed "SQL Server 2005 180 days evaluation" on Windows XP as default instance one month before. It runs fine.

However, today I try to install "SQL Express SP1 (CTP) - SQLEXPR_ADV.EXE" as a new instance name "SQLExpress", It prompt me that it could not install "SQL Server 2005 Management Studio Express" as existing "SQL Server 2005 Management Studio" already installed. So I have to install "SQLEXPR_ADV.EXE" but uncheck "SQL Server 2005 Management Studio Express". When setup has completed, I found the original "SQL Server 2005 Management Studio" is missing.

I try to re-install "SQL Server 2005 180 days evaluation" but it prompt me it is already installed, and cannot find "SSMS" option. Then I try to use "Add/Remove Programs" as control panel to Change "Microsoft SQL Server 2005", I still cannot find "SSMS" option.

Also, there is no another Start Menu folder for "SQL Express", but "Microsoft SQL Server 2005".

From the "SQL Server Configuration Manager" --> SQL Server 2005 Services, I found following instance running properly,

SQL Server Integration Services

SQL Server FullText Search (MSSQLSERVER)

SQL Server FullText Search (SQLEXPRESS)

SQL Server (SQLEXPRESS)

SQL Server (MSSQLSERVER)

SQL Server Analysis Services (MSSQLSERVER)

SQL Server Reporting Services (MSSQLSERVER)

SQL Server Reporting Services (SQLEXPRESS)

SQL Server Browser

SQL Server Agent (MSSQLSERVER)

When I install "SQL Express SP1 (CTP)", I have not change installation path, so it is default to the same path as "SQL Server 2005" at "%windir%\Program Files\Microsoft SQL Server\".

It seems that "SQL Server 2005 Express" overwrite the previous installation of "SQL Server 2005".

My question is how to install the previous "SQL Server 2005 Management Studio" rather than "SSMS Express".

I will be very appreciated to Any idea to my problem.

cheers,

Stanley Qian

Hi Stanley,

It is expected that SSMS and SSMSE do not run on the same computer. The problem here is related to SQL Server's Upgrade logic with regards to common tools such as SSMS and the fact that you are using Eval and Express Advanced.

I'm going to move this to the Setup forum since the Upgrade logic is their area. Go ahead and file an issue on this in the MSDN Product Feedback Center at http://go.microsoft.com/fwlink/?LinkId=51684.

Regards,

Mike Wachal
SQL Express team