[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 330
  • Last Modified:

SQL Server 2008 flipped to Evaluation Copy

I've been using SQL SERVER 2008 on a Windows 7 computer for over 6 months now without incident. Yesterday when I went to open it I received the following message: "Evaluation Period has expired. For information on how to upgrade your evaluation software. Please goto http://www.microsoft.com/sql/howtobuy"

I have no idea why this is happening. The program came from MSDN and is being used successfully by other members of our staff.

I uninstalled it, then re-installed it but the result was the same.

Ideas anyone?
0
SpaceCoastLife
Asked:
SpaceCoastLife
  • 8
  • 3
  • 2
  • +3
3 Solutions
 
Bill RossCommented:
Has you MSDN license expired?
0
 
Rich WeisslerProfessional Troublemaker^h^h^h^h^hshooterCommented:
The Evaluation SQL software doesn't go out of it's way to let you know that you are working with the evaluation software.  On the instances which are still running, you should be able to 'select @@version', and if it's the evaluation... it'll say so in the product description.  I suspect you have a 180 day evaluation and if other instances were installed using the same iso, they are facing the same fate.

Assuming the instance is being used for development, the good news is that a SQL development license is relatively inexpensive, and mirrors the functionality of Enterprise.  (Or Express is still free...)
0
 
Ryan McCauleyCommented:
The evaluation period is 180 days, and since you mention that it's been up for about six months, I suspect you initially installed an evaluation copy rather than a regular one.

Edition change is easy and is a quick run through setup - no data or settings are lost. Here's the process:

http://msdn.microsoft.com/en-us/library/cc707783(v=sql.100).aspx

As Razmus notes, you can use a development edition license if it's being used for development (no data moves to production, and no end users connect to it except for testing). If it's being used for production, you'll need to ensure that you have an appropriate license for it (MSDN doesn't allow production use).

Keep in mind that while MSDN gives you access to all the software you want and let's you download standard/enterprise versions of things, it doesn't include those licenses, so you'll often need to make an additional purchase to allow you to run something in production.
0
Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
Anthony PerkinsCommented:
The program came from MSDN and is being used successfully by other members of our staff.
If you are talking about the Microsoft Developer Network subscriber library, than you should know that the Evaluation Edition of SQL Server cannot be downloaded from here.
0
 
Ryan McCauleyCommented:
When you install a copy of SQL Server that you get from MSDN, I believe you can select the edition you're installing - though it defaults to whatever edition you've downloaded and has a key built in, you can still select to install an evaluation edition.

I was able to confirm this with a copy of SQL 2012 R2 Developer Edition that I had from MSDN - you can enter a product key for the edition you want (it defaults to the built-in developer key), or I could select a free edition (express or evaluation).
0
 
SpaceCoastLifeAuthor Commented:
At this point I did a full un-install from Program Manager, although I did have to manually delete some folders and registry entries.

The re-install went better (meaning no errors) but now I can't connect. I think the evaluation expiration issue is resolved but ,,,

Here's the message I now get when I attempt to connect to the server.

Hopefully, one of you have some ideas on this because I'm all out!
SQLServer-Connection-Failure.docx
0
 
Rich WeisslerProfessional Troublemaker^h^h^h^h^hshooterCommented:
(First, just nitpick... but be wary with Word Documents... this week's Microsoft patches included patch for Word.)

I'd tend to want to open the "SQL Server Configuration Manager" for your instance, and look through the Network Configuration to make certain the protocol you wish to use is enabled.  It appears, for example, that you're getting an error with Named Pipes.
You didn't have an instance of SQL Browser server survive from the previous install by any chance did you?
0
 
SpaceCoastLifeAuthor Commented:
Don't think so. I'll check the Configuration Manager (assuming I know where it is).
0
 
Anthony PerkinsCommented:
And the potentially stupid question, have you attempted to open SSMS on the server itself, as opposed to trying from a workstation.
0
 
SpaceCoastLifeAuthor Commented:
This is a local server. The named instance is DON2008R2 as you can see in the "Services" document (attached). The protocols for that instance are all enabled, however, when I go to Mgmt Studio (attached) or Mgmt Studio_Browse (also attached) there's nothing there.
I've included a snap-shot of Program Mgr also because I don't know why there's more than one instance being shown.
I stopped the service and deleted all but one but then couldn't start all the services I'd stopped so I restored them.
SQLServer-Services.docx
0
 
SpaceCoastLifeAuthor Commented:
0
 
SpaceCoastLifeAuthor Commented:
0
 
SpaceCoastLifeAuthor Commented:
0
 
Anthony PerkinsCommented:
Since this is a named instance you need to connect as ComputerName\DON2008R2
0
 
SpaceCoastLifeAuthor Commented:
I tried that already (unfortunately). Does anyone know of an online Mr. Fixit sql expert?
Someone that doesn't charge an arm and a leg because we all know this can be a very lengthy process. Even if they could end up with telling me exactly what the problem is and I fix it myself. I'm already a week behind schedule at work because of this.
0
 
Eugene ZCommented:
if you have SQL Server 2008 Evaluation Copy
and own valid sql server 2008 key


this will help:

How to upgrade an expired installation of SQL Server 2008 Evaluation Edition to a retail version of SQL Server 2008

http://support.microsoft.com/kb/2020443
and this one

SQL Server 2008 Evaluation Edition Upgrade
http://shahfaisalmuhammed.blogspot.com/2011/09/sql-server-2008-evaluation-edition.html
0
 
SpaceCoastLifeAuthor Commented:
I apologize for ignoring this for so long. In truth, it was difficult for me to decide how to award the points and while I tried many of the suggestions mentioned, none actually worked. I ended up reformatting my hard drive to resolve the issue. This is the second time I've experienced something like this with SQL Server. It's a great product as long as you never have to perform maintenance of any kind on it. Then it sucks.

Thanks everyone!
0

Featured Post

Nothing ever in the clear!

This technical paper will help you implement VMware’s VM encryption as well as implement Veeam encryption which together will achieve the nothing ever in the clear goal. If a bad guy steals VMs, backups or traffic they get nothing.

  • 8
  • 3
  • 2
  • +3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now