none
SQL Server Management Studio prompting for license key

    Question

  • I have an MSDN subscription through my employer and I was successfully using SQL Server 2012. One morning it stopped working, claiming my license had expired, so I uninstalled it. I then installed SQL Server 2014 and on the MSDN download page it specifically states that no key is required. Once installed, I tried to launch Management Studio I get the same prompt saying "Your Microsoft SQL Server Management Studio evaluation period has expired" and will not open unless I input a key. I don't have a key since it told me a key is not required on the MSDN site.

    Is this some leftover junk in the registry from the 2012 install?

    Thursday, December 8, 2016 12:05 AM

Answers

  • If i were you i would stop messing with licenses and go with the free and fully functional version that they separated from the SQL Server installation package starting with SQL Server 2016, which happens to be backwards compatible with 2008 R2, 2012, and 2014. Not to mention you will regularly receive updates too...

    https://msdn.microsoft.com/en-us/library/mt238290.aspx?f=255&MSPPError=-2147217396


    Thursday, December 8, 2016 8:36 PM

All replies

  • It looks like somehow you installed the evaluation version of SQL Server and it has expired.

    From:

    https://support.microsoft.com/en-us/kb/971268

    The recommendation is to run setup and change your edition of SQL Server. This is for SQL 2008 r2. It is worth a try. You must ensure that you have correct licensing to cover your installation.

    Thursday, December 8, 2016 1:38 AM
  • I've installed SQL Server 2014 Standard Edition which I downloaded from the MSDN site. It is a FULL, LICENSED version.
    Thursday, December 8, 2016 2:32 AM
  • Is it possible that you started the old SSMS 2012 instead of new SSMS 2014?

    Olaf Helper

    [ Blog] [ Xing] [ MVP]

    Thursday, December 8, 2016 7:14 AM
  • The startup banner says SQL Server 2014
    Thursday, December 8, 2016 7:37 PM
  • Please see "Case 3 - Option 2":

    https://support.microsoft.com/en-us/kb/971268

    Make sure to run SETUP for the SQL 2014 version.

    Thursday, December 8, 2016 7:58 PM
  • If i were you i would stop messing with licenses and go with the free and fully functional version that they separated from the SQL Server installation package starting with SQL Server 2016, which happens to be backwards compatible with 2008 R2, 2012, and 2014. Not to mention you will regularly receive updates too...

    https://msdn.microsoft.com/en-us/library/mt238290.aspx?f=255&MSPPError=-2147217396


    Thursday, December 8, 2016 8:36 PM