Removing a Server Name

SQL

Upgrading to VS05 Pro SP1/SqlExpress (from VS03 Pro/SQL MSDE)

Question 1) – is there a way to tell which version of the SQL Express was installed?I think it is “SQL Server 2005 Express Edition With Advance Services”, but don’t know how to confirm that.

Question 2) - SQL Server Management Studio Express, Registered Servers, it shows :

Database Engine

\sqlexpress (note the lower case)

If I right click and choose “Previously Registered Servers”, it shows a message that I will be displaying SQL Server 2000 (i.e. MSDE) server names, and it shows

SQL Server Group

\SQLEXPRESS (note the upper case)

\CSOLUTION

I wish to completely remove\CSOLUTION (in MSDE you would uninstall it from the Control Panel), but right clicking and choosing the delete option does nothing (it does not delete it).Deleting SQL Server Group also has no affect either. How do I remove \CSOLUTION ?

Question 3) - In the VS05 program, the SQL connection string includes “Data Source=.\SQLEXPRESS….” (NOTE UPPER CASE)Why do I have a lower case and an upper case listed above?Starting/stopping one sqlexpress/ SQLEXPRESS does the same to the other.Don’t I wan’t to complete delete anything under SQL Server Group since it represents SQL Server 2000 (i.e. MSDE) server names?SQL Server 2000 and \CSOLUTION have been uninstalled from this machine.

Thanks!

bob

hi Bob,

BobInIndy wrote:

SQL

Upgrading to VS05 Pro SP1/SqlExpress (from VS03 Pro/SQL MSDE)

Question 1) – is there a way to tell which version of the SQL Express was installed? I think it is “SQL Server 2005 Express Edition With Advance Services”, but don’t know how to confirm that.

executing

SELECT SERVERPROPERTY('Edition'); --< will return Express Edition with Advanced Services --< where a "standard" SQLExpress instance returns Express Edition

Question 2) - SQL Server Management Studio Express, Registered Servers, it shows :

Database Engine

\sqlexpress (note the lower case)

If I right click and choose “Previously Registered Servers”, it shows a message that I will be displaying SQL Server 2000 (i.e. MSDE) server names, and it shows

SQL Server Group

\SQLEXPRESS (note the upper case)

\CSOLUTION

I wish to completely remove \CSOLUTION (in MSDE you would uninstall it from the Control Panel), but right clicking and choosing the delete option does nothing (it does not delete it). Deleting SQL Server Group also has no affect either. How do I remove \CSOLUTION ?

you usually uninstall an instance accessing the control panel Add/Remove applet...

as last resource you can manually delete it as described in http://support.microsoft.com/kb/290991/en-us

Question 3) - In the VS05 program, the SQL connection string includes “Data Source=.\SQLEXPRESS….” (NOTE UPPER CASE) Why do I have a lower case and an upper case listed above? Starting/stopping one sqlexpress/ SQLEXPRESS does the same to the other. Don’t I wan’t to complete delete anything under SQL Server Group since it represents SQL Server 2000 (i.e. MSDE) server names? SQL Server 2000 and \CSOLUTION have been uninstalled from this machine.

Thanks!

bob

the upper/lower case is not actually a problem...

regards