Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

MSSQLFUN

I, Rohit Garg, am working as Consultant in IT Company. I am having an around 5 years of experience in MSSQL server & other Microsoft technologies. I am working as DBA in Microsoft SQL Server from last 5 years in e-Commerce, Telecom, Finance domain. In this tenure, I got a chance of working as Database administrator, Developer and trainer on SQL server 2000 to SQL Server 2012. I am holding Master’s degree in Computer Science along with certification in SQL Server & .Net. I like to learn new things by hand-on experience on regular basis. This journey is so far is delightful & valuable with the addition of wonderful friends.

Is Instance name SQLEXPRESS is fixed for Express edition only ?

A Question “SQLEXPRESS instance name is fixed for Express edition only ?” is running in my mind. SO I have decide to test it.

First I have tried to install SQL server Evolution Enterprise edition with instance name “SQLEXPRESS” & it worked.

Now I tried to install SQL Server Express edition & It allows me install Express edition with different edition name.

You can see that I am having SQLEXPRESS instance name with Enterprise Evolution edition & SQLEXPRESS2008 (different name) instance with Express edition.

But it’s good to use default things & install Express edition with SQLEXPRESS instance name. It’s easy to understand.


Comments

Leave a comment on the original post [mssqlfun.com, opens in a new window]

Loading comments...