Help: SQL Server

Sharing my knowlege about SQL Server Troubleshooting Skills

  • Blog Stats

    • 2,156,897 hits

  • Select GETDATE()

    March 2026
    M T W T F S S
     1
    2345678
    9101112131415
    16171819202122
    23242526272829
    3031  

Archive for the ‘SQL Server’ Category

Next Entries »

Help : Can I Upgrade SQL Edition without reinstall?

Posted by blakhani on June 3, 2011


And answer is “it depends”. Well, I have seen posts in forum asking steps to upgrade SQL Standard to SQL Enterprise OR SQL Developer to SQL Standard etc. So I am writing this blog to bring some clarity in steps to be performed.
First of all, refer below matrix to know if in place edition upgrade is possible or not.

http://msdn.microsoft.com/en-us/library/ms143393.aspx (SQL Server 2008 R2)
http://msdn.microsoft.com/en-us/library/ms143393(v=SQL.100).aspx (SQL Server 2008)
http://msdn.microsoft.com/en-us/library/ms143393(v=SQL.90).aspx (SQL Server 2005)

Above links are for version upgrade as well as edition upgrade. Now, if matrix says you can upgrade from edition X to edition Y then steps are pretty simple.
For SQL 2008 and SQL 2008 R2:

  • Run setup.exe from media.
    • If you have SQL already installed then you can also launch “Installation Center” by going to Start->Programs ->Microsoft SQL Server 2008[R2]->Configuration Tools-> SQL Server Installation Center[(64-bit)].
  • You would get below screen titled “SQL Server Installation Center”
  • Go to “Maintenance” and click on “Edition Upgrade”

  • Go through the Wizard and choose the Instance you want to upgrade.

It would hardly take few minutes to upgrade and I have done with many customer.

One question which was asked many times is where the hell is the key which i should enter. If you have media, look for DefaultSetup.ini file and you would find PID there.

For SQL 2005:
I would update this post once I take screenshot from SQL 2005 setup.

Cheers,
Balmukund Lakhani

Posted in Edition Upgrade, SQL Server, Upgrade | 5 Comments »

Help: SQL Server Evaluation Edition Expired!

Posted by blakhani on June 1, 2011


Many time in forums, I have seen question about Enterprise Evaluation Edition expiration. So idea of this blog post is to avoid repetitive screenshots (which i love to put in my replies as they are more powerful). So here we go…

If you have SQL Server 2005/2008/2008 R2 Enterprise Evaluation edition and its already expired then you may see below error message when you open SQL Server Management Studio.

Here is the text of the message for better search.

Microsoft SQL Server Management Studio:
Evaluation period has expired. For information on how to upgrade your evaluation software please go to http://www.microsoft.com/sql/howtobuy

There could be two possibilities.

  • SQL Server is really really expired (This is most common question in forum)
  • SQL Server 2008 has been upgraded to full version but tools are not working. This is a known issue which i have blogged here

Now, if SQL 2005 is expired then you have no choice other than uninstall/reinstall SQL Server (of course you can reuse mdf and ldf files). In this blog I am not going to cover SQL 2005 upgrade (come on, its 6 years old product when I was writing this post). If SQL 2005 is not expired then you can perform edition upgrade by putting CD/DVD of new edition and choosing proper instance .

From SQL 2008 onwards, you can perform edition upgrade even if its expired. Cool! Isn’t it? Well, this feature was introduced by hearing feedback from customers. Here are the steps to do it.

  • Launch the Setup.exe from the DVD/Shared Location. You would get below screen titled “SQL Server Installation Center” .
    • If you have SQL already installed then you can also launch “Installation Center” by going to Start->Programs ->Microsoft SQL Server 2008[R2]->Configuration Tools-> SQL Server Installation Center[(64-bit)].

image

  • Click on “Maintenance” and choose “Edition Upgrade”
  • Go through the Wizard and choose the Instance you want to upgrade.

Simple, huh?

Fewer times I have been asked if I need to download mount/extract complete ISO to run edition upgrade? Well, here is the trick. Media for all the edition is same. Its the PID which decides which edition to be installed. PID is picked from a file called DefaultSetup.Ini (DVD\x86 or x64 or ia64 folder). It essentially means that you can extract that file from ISO image, run setup of Evaluation media and in below screen type the PID manually.

image

Hope this helped someone today!

Cheers,
Balmukund Lakhani

Posted in Evaluation, Expired, SQL Server | 21 Comments »

Next Entries »