Solved

SQL Server 2008 flipped to Evaluation Copy

Posted on 2014-04-10
17
307 Views
Last Modified: 2014-05-15
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
Comment
Question by:SpaceCoastLife
  • 8
  • 3
  • 2
  • +3
17 Comments
 
LVL 14

Expert Comment

by:Bill Ross
ID: 39994030
Has you MSDN license expired?
0
 
LVL 29

Expert Comment

by:Rich Weissler
ID: 39994044
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
 
LVL 28

Assisted Solution

by:Ryan McCauley
Ryan McCauley earned 500 total points
ID: 39994348
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
 
LVL 75

Expert Comment

by:Anthony Perkins
ID: 39994506
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
 
LVL 28

Assisted Solution

by:Ryan McCauley
Ryan McCauley earned 500 total points
ID: 39994569
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
 

Author Comment

by:SpaceCoastLife
ID: 39995198
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
 
LVL 29

Expert Comment

by:Rich Weissler
ID: 39995211
(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
 

Accepted Solution

by:
SpaceCoastLife earned 0 total points
ID: 39995313
Don't think so. I'll check the Configuration Manager (assuming I know where it is).
0
What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

 
LVL 75

Expert Comment

by:Anthony Perkins
ID: 39995542
And the potentially stupid question, have you attempted to open SSMS on the server itself, as opposed to trying from a workstation.
0
 

Author Comment

by:SpaceCoastLife
ID: 39995998
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
 

Author Comment

by:SpaceCoastLife
ID: 39996001
0
 

Author Comment

by:SpaceCoastLife
ID: 39996003
0
 

Author Comment

by:SpaceCoastLife
ID: 39996004
0
 
LVL 75

Expert Comment

by:Anthony Perkins
ID: 39996441
Since this is a named instance you need to connect as ComputerName\DON2008R2
0
 

Author Comment

by:SpaceCoastLife
ID: 39996784
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
 
LVL 42

Expert Comment

by:EugeneZ
ID: 39996834
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
 

Author Closing Comment

by:SpaceCoastLife
ID: 40066719
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

6 Surprising Benefits of Threat Intelligence

All sorts of threat intelligence is available on the web. Intelligence you can learn from, and use to anticipate and prepare for future attacks.

Join & Write a Comment

Suggested Solutions

Title # Comments Views Activity
MS SQL Backup 24 70
how to fix this error 14 46
How to select Week Start and Week End dates 5 26
SQL Server 2012 Row Selection 2 30
Nowadays, some of developer are too much worried about data. Who is using data, who is updating it etc. etc. Because, data is more costlier in term of money and information. So security of data is focusing concern in days. Lets' understand the Au…
This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
Via a live example, show how to extract information from SQL Server on Database, Connection and Server properties
Using examples as well as descriptions, and references to Books Online, show the different Recovery Models available in SQL Server and explain, as well as show how full, differential and transaction log backups are performed

758 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

16 Experts available now in Live!

Get 1:1 Help Now