Post reply

SQL Server 2008 SP1/R2 Security Differences

  • January 31, 2011 at 2:40 pm

    #231186

    We recently built a SQL Server Enterprise 2008 R2 64 bit machine running on Windows 2008 R2 Enterprise 64 bit at the request of some of our developers. When they were ready to install their purchased application, the vendor said 'Oops, we meant SQL 2008 SP1, not R2'. They say their application will not run on 2008 R2 due to security differences between R2 and SP1. So far we have not been able to find out what these security differences are from the vendor. Searching the Microsoft web site and Google have not helped either. My question is this:

    Do any of you know about any security differences between SP1 and R2? If so, can you point me to an article or something?

    Thanks,

    Chris

  • February 1, 2011 at 2:08 pm

    #1281143

    Anybody have any ideas?

    Thanks

  • February 1, 2011 at 3:59 pm

    #1281179

    None that I know of. The majority of the changes in R2 were around BI. iirc there were something like 5 changes total in the database engine, I don't recall security being among them.

    Put the ball back into their court. "Could you please explain the details of those security changes?"

    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

  • February 2, 2011 at 8:41 am

    #1281489

    Thanks Gail. We have tried to get the specific errors from our vendor. Maybe they will come through some time soon. I'm just glad I wasn't missing something too obvious.

    Chris

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

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