• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 361
  • Last Modified:

SQL Versions

SQL Versions

I am kind of confused when I try to find the version of SQL server

I believe I need to check the properties of the instances instead of the "About" page of the of the Management Studio.

in the screenshots below I wonder if I am using sQL Server 2008 or SQL Express.

Any help will be very much appreciated.

Thanks


instanceAbout
0
jskfan
Asked:
jskfan
4 Solutions
 
Ryan LanhamCommented:
Your running Express. The topline of the first screen shot indicates that.

10.50.2500.0 Tells us you are running 2008 R2 SP1.

So you have SQL Express 2008 R2 SP1 installed.

http://www.microsoft.com/en-us/download/details.aspx?id=26729
0
 
jskfanAuthor Commented:
so to determine the edition of SQL server I need to go to the properties of the SQL instance
0
 
Anthony PerkinsCommented:
As indicated previously you have SQL Server 2008-R2 Express Edition installed and you are using SSMS version 2008 (not 2008-R2).
0
Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

 
Anthony PerkinsCommented:
so to determine the edition of SQL server I need to go to the properties of the SQL instance
You can.  It is just easier to query it from SSMS.
0
 
jskfanAuthor Commented:
the first screenshot I pasted was after I opened up SSMS the right-clicked on the instance name then properties….That's where It shows "Microsoft SQL Server Express Edition (64bits)"
0
 
Ramesh Babu VavillaCommented:
you are having SQL Server 2008 R2 installed on you server

buy you have sql server 2008 management studio installed in it

sql server management studio is simply a GUI tool used to connect the sqL Server and organise it
0
 
jskfanAuthor Commented:
Thanks
0

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now