2

I own a VPS server and I was told SQL Server 2008 R2 Express edition was installed on Windows OS 2008R2.

When I opened the SQL Server configuration manager I saw this:

enter image description here

  1. I thought I should see only the SQL Server Express but there is also SQL Server (MSSQLServer). Does that mean both SQL Server Express and SQL Server of different version are installed? If so how will I know which version of SQL Server and SQL Server Express are installed ?

  2. I also see SQL Server full text filter daemon service running which means full text is installed but unfortunately when I right click the table I see the full text index is disabled.

enter image description here

I am confused as to what is installed and what is not installed. Can some one throw a light on this one

When I connect to the default instance with servername as . I get :

Microsoft SQL Server 2008 R2 (SP2) - 10.50.4000.0 (X64) Jun 28 2012 08:36:30
Copyright (c) Microsoft Corporation
Express Edition (64-bit) on Windows NT 6.1
(Build 7601: Service Pack 1) (Hypervisor)

When I connect to the instance with servername as machinename\sqlexpress I get:

Microsoft SQL Server 2008 R2 (SP2) - 10.50.4000.0 (X64) Jun 28 2012 08:36:30
Copyright (c) Microsoft Corporation
Express Edition with Advanced Services (64-bit) on Windows NT 6.1
(Build 7601: Service Pack 1) (Hypervisor)

  • Yes both SQL Server default instance, which can be any version of SQL Server, and express instance are installed. – Shanky Mar 25 '15 at 7:57
  • 1
    you can check the version using SELECT @@VERSION after connecting to both default and express instance – ughai Mar 25 '15 at 8:38
3

The MSSQLSERVER name in the services does not mean anything other than SQL Server (any edition) was installed as the default (unnamed) instance. It does NOT give you any information as to what version or edition it is! This can be SQL Server Express!

You need to connect to that database instance and run

SELECT @@VERSION

to find out what exact version/edition it is.

Having the two SQL Server service entries just means you have two instances - which edition each instance is cannot be determined from their names alone. OK - SQLEXPRESS is the default name used for SQL Server Express - but you could install a Standard or Enterprise edition with that instance name - just for fun.

  • updated my answer. It looks both the versions are sql-epxress, One with advanced services and other which is not. – Venkat Mar 25 '15 at 8:55
  • 1
    install Standart and name it Express indeed sounds fun – RayofCommand Mar 25 '15 at 11:07
  • @RayofCommand: it might violate the Principle of Least Surprise - but it's possible ! :-) – marc_s Mar 25 '15 at 12:22

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.