Solved

SQL Server 2008 flipped to Evaluation Copy

Posted on 2014-04-10
17
309 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 30

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
Optimizing Cloud Backup for Low Bandwidth

With cloud storage prices going down a growing number of SMBs start to use it for backup storage. Unfortunately, business data volume rarely fits the average Internet speed. This article provides an overview of main Internet speed challenges and reveals backup best practices.

 
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 30

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
 
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

VMware Disaster Recovery and Data Protection

In this expert guide, you’ll learn about the components of a Modern Data Center. You will use cases for the value-added capabilities of Veeam®, including combining backup and replication for VMware disaster recovery and using replication for data center migration.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Oracle DB monitor SW 21 48
what are the unique tables in SQL master database 5 59
Return 0 on SQL count 24 30
SQL view 2 27
Slowly Changing Dimension Transformation component in data task flow is very useful for us to manage and control how data changes in SSIS.
This article shows gives you an overview on SQL Server 2016 row level security. You will also get to know the usages of row-level-security and how it works
Familiarize people with the process of utilizing SQL Server functions from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Ac…
Viewers will learn how to use the SELECT statement in SQL to return specific rows and columns, with various degrees of sorting and limits in place.

773 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