Post reply

Urgent help needed. MS SQL Server 2012

  • December 19, 2021 at 6:13 pm

    #3965316

    Hi, I've just got a call (6pm on a Friday!) from a customer who has had  his line-of-business application provider sell him a solution which required SQL Server 2012 Standard, yet the supplier (joyfully) installed the evaluation version of SQL Server 2012 Enterprise. This has now ticked over and expired. My problem is that (a) I can't now get into the Management Studio to back up the database and move it to a new instance, (b) The only licensing I have available is SPLA licensing for SQL which doesn't require a license key (so I can't just stick a volume license key in the existing SQ https://speedtest.vet/L instance), and ( https://showbox.tools/c) The customer needs to have this working for Monday morning since it's core to the business (and I already told him it was fixed, before realising my junior had extended the licensing grace period of Windows 2012 not SQL 2012). Anyway, as i'm not really SQL-savvy, can someone explain how to either extend the license grace period for the SQL instance, or how to remedy the issue with the SPLA version of SQL Server 2012 Standard? Thanks!

    • This topic was modified 2 years, 11 months ago by  ishitweni.

  • December 19, 2021 at 6:52 pm

    #3965320

    You're probably going to have to buy a Standard license online from MS and then follow the instructions to migrate to the updated version.  Since everything is offline right now, I'd be making copies of all the server databases files (MDF/LDF/NDF) to store in a safe place so it you blow the migration, you have a place to start over.

    Personally, I'd have that bloody "line-of-business application provider " on the phone to help, expecially since you're "not really SQL-savvy".

    Either way, someone is going to need to pay for that Standard License TODAY! 😉

    There might also be the problem that someone screwed up and used some "Enterprise Only" functionality, which means the purchase of the more expensive "Enterprise Edition" instead of the "Standard Edition".

    My disclaimer here is that I've never had to do a migration from the Evaluation Edition to the Standard Edition.  Hopefully, someone with more knowledge of this type of problem will jump on soon.

     

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

  • December 20, 2021 at 2:56 pm

    #3965548

    SQL 2012 is end of life in 7 months.  Sounds like it's time for another vendor.

    Michael L John
    If you assassinate a DBA, would you pull a trigger?
    To properly post on a forum:
    http://www.sqlservercentral.com/articles/61537/

  • December 20, 2021 at 7:29 pm

    #3965661

    Michael L John wrote:

    SQL 2012 is end of life in 7 months.  Sounds like it's time for another vendor.

     

    Then there's that... installing on the Evaluation Edition was bad enough but lordy.  This vendor needs a serious high-velocity pork chop dinner.

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

  • December 20, 2021 at 7:57 pm

    #3965672

    Frozen pork chop.

  • December 20, 2021 at 10:18 pm

    #3965696

    ratbak wrote:

    Frozen pork chop.

    That would be the main course!  😀  Served at high velocity at point blank range from a 3 banded wrist rocket!  😀

    Heh... I guess that story has made it's rounds, eh?

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

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

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