Which version of SQL do I have

We have a DVD labeled SQL Server 2008 R2 and copied it contents to the server drive.  However after I installed it it comes up in SSMS saying just SQL Server 2008. On the setup.exe the version listed is 2007.100.1600.22. Is the setup program for SQL Server 2008 or SQL Server 2008 R2?
rwheeler23Asked:
Who is Participating?
 
Steven HarrisConnect With a Mentor PresidentCommented:
All I can see is that when I right-click on the setup.exe on the DVD the version that is returned is 2007.100.1600.22. I am wondering if we were given a pirated copy of SQL.

The version you number you gave is SQL Server 2008 RTM which is a MSDN/TechNet download version.  This is not SQL 2008 R2, so if the media says otherwise, the copy is most likely altered.
0
 
Kent DyerIT Security Analyst SeniorCommented:
Gooogle version of SQL Server - there is a MSFT page of SQL server versions.
0
 
Steven HarrisPresidentCommented:
SQL Server 2008 RTM (release to manufacture)

This would be the MSDN/TechNet download version.

2008 R2 is a 10.50 variation.
0
Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

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.

 
Steve WalesSenior Database AdministratorCommented:
You can, from SSMS do this:

select @@version

With what's returned, refer here:

http://sqlserverbuilds.blogspot.com/

Referring there and seeing what you've posted, I'm thinking SQL Server 2008
0
 
rwheeler23Author Commented:
My question here is not what version is installed but what version is the DVD? The DVD says SQL Server 2008 R2 but the SQL installed on the server is SQL Server 2008. Is there any way to tell from the install media which version of SQL is on the DVD? All I can see is that when I right-click on the setup.exe on the DVD the version that is returned is 2007.100.1600.22. I am wondering if we were given a pirated copy of SQL.
0
 
rwheeler23Author Commented:
Great. Thanks. No one has any idea from where it came. I will let legal deal with this.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.