Removing the \SQLEXPRESS instance name on Dell laptops

I am installing SQL 2005 Express on several laptops (IBM Thinkpads and Dell latitudes) and I've noticed that doing the exact came configuration options with the exact same file, the IBM thinkpads just take the Machine name for SQL Server, while the Dells take Machinename\SQLEXPRESS. I am wondering how I can get it to just take the machine name on the Dells.

Thanks a lot

You might want to take a look at what's already installed on those laptops before you install SQL Express. I know that on our Dell servers there's an application called IT Assist, which uses a local SQL Server database. Dell may have already installed SQL Express on those laptops for this application, and it's using the default instance. Then, when you install SQL Express, the default instance is already used, so it installs the named installed you've identified.|||I believe I have removed all traces of anything SQL Server related that I could find as far as the add or remove programs, but I will take a look at the IT assist as well. Thanks a lot.

Removing the \SQLEXPRESS instance name on Dell laptops

I am installing SQL 2005 Express on several laptops (IBM Thinkpads and Dell latitudes) and I've noticed that doing the exact came configuration options with the exact same file, the IBM thinkpads just take the Machine name for SQL Server, while the Dells take Machinename\SQLEXPRESS. I am wondering how I can get it to just take the machine name on the Dells.

Thanks a lot

You might want to take a look at what's already installed on those laptops before you install SQL Express. I know that on our Dell servers there's an application called IT Assist, which uses a local SQL Server database. Dell may have already installed SQL Express on those laptops for this application, and it's using the default instance. Then, when you install SQL Express, the default instance is already used, so it installs the named installed you've identified.|||I believe I have removed all traces of anything SQL Server related that I could find as far as the add or remove programs, but I will take a look at the IT assist as well. Thanks a lot.

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