Post reply

Is SQL Server 2008 and 2008 R2 completely separate versions?

  • January 9, 2017 at 10:24 am

    #401339

    Hello,

    Is SQL Server 2008 and 2008 R2 completely separate versions?

    I currently have the "out of the box" SQL Server 2008 installed on my machine but need to utilize functionality that is part of BIDS that comes in 2008 R2. However, when I attempt to install, the only option I get is for SQL Express and while the R2 installs "successfully", my SQL Server and BIDS does not take effect.

    I am curious to know if they are 2 separate products???

  • January 9, 2017 at 10:52 am

    #1921455

    2008 and 2008R2 are two different products. Each of them have different releases and version numbers. They're very similar, but are different enough not to have been considered a Service Pack.

    I'm not sure what's happening with your installation, but you should have 2 versions installed if you fully installed 2008R2. If you only were able to install Express, you might have only the 2008 tools with two instances, one 2008 and one of 2008R2 Express edition.

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

  • January 10, 2017 at 2:04 pm

    #1921764

    Thank you for your reply. I have 2008 installed and was trying to apply SQL Server 2008 R2 Service Pack. I am thinking what I need to do is get a copy of the SQL Server 2008 R2 release first, then apply the Service Pack. I am going to try using the SQL Server 2008 R2 Express version. What I am really trying to do is get some BIDS SSRS lookupset functionality that starts in SQL Server 2008 R2, so I am not sure if downloading Express will solve the problem or not.

  • January 10, 2017 at 11:17 pm

    This was removed by the editor as SPAM

  • January 11, 2017 at 2:14 am

    #1921841

    rjjh78 (1/10/2017)

    Thank you for your reply. I have 2008 installed and was trying to apply SQL Server 2008 R2 Service Pack.

    That'll work about as well as trying to apply the SQL 2016 SP1 to SQL 2014.

    Separate versions, different installations, completely separate instances.

    I don't believe SSRS or BIDS are included in SQL Express, so installing express probably won't help you.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply