Yesterday is so suck for me that I just found my MSSQL is expired. I worked all day to fix this problem. Below is my solution for this problem.
Checking existing MSSQL 2012 edition from the old logs,
as I found in C:\Program Files\Microsoft SQL Server\110\Setup
Bootstrap\Log\yyyymmdd_hhmmss
Product features
discovered:
Product Instance Instance ID Feature Language Edition Version Clustered
SQL Server 2012 MSSQLSERVER MSSQL11.MSSQLSERVER Database Engine Services 1033 Enterprise Evaluation Edition
11.1.3000.0 No
SQL Server 2012 MSSQLSERVER MSSQL11.MSSQLSERVER SQL Server Replication 1033 Enterprise Evaluation Edition
11.1.3000.0 No
SQL Server 2012 MSSQLSERVER MSSQL11.MSSQLSERVER Full-Text and Semantic Extractions
for Search 1033
Enterprise Evaluation Edition 11.1.3000.0 No
SQL Server 2012 MSSQLSERVER MSSQL11.MSSQLSERVER Data Quality Services 1033 Enterprise Evaluation Edition
11.1.3000.0 No
SQL Server 2012 MSSQLSERVER MSAS11.MSSQLSERVER Analysis Services 1033 Enterprise Evaluation Edition
11.1.3000.0 No
SQL Server 2012 MSSQLSERVER MSRS11.MSSQLSERVER Reporting Services - Native 1033 Enterprise Evaluation Edition
11.1.3000.0 No
SQL Server 2012
Management Tools - Basic
1033 Enterprise
Evaluation Edition 11.1.3000.0 No
SQL Server 2012
Management Tools - Complete
1033 Enterprise
Evaluation Edition 11.1.3000.0
No
SQL Server 2012 Client Tools
Connectivity 1033 Enterprise Evaluation Edition
11.1.3000.0 No
SQL Server 2012
Client Tools Backwards Compatibility 1033 Enterprise Evaluation Edition
11.1.3000.0 No
SQL Server 2012
Client Tools SDK
1033 Enterprise
Evaluation Edition 11.1.3000.0
No
SQL Server 2012
Integration Services
1033 Enterprise
Evaluation Edition 11.1.3000.0
No
As you see, the installed MSSQL is enterprise evaluation
edition but I have already bought the standard edition. I can use this
evaluation edition for only 180 days. Once I have not upgraded it yet , when
the expired date is arrived I cannot access the database anymore.
The error message will be shown when you access the
database via MSSQL Management Studio (but I didn’t capture it. But, I found the
similar message in event log of windows log, as below.
Log Name: Application
Source: MSSQLSERVER
Date: 19/3/2557 19:26:19
Event ID: 17051
Task Category: Server
Level: Error
Keywords: Classic
User: N/A
Computer: saturn
Description:
SQL
Server evaluation period has expired.
Event Xml:
<Event
xmlns="http://schemas.microsoft.com/win/2004/08/events/event">
<System>
<Provider Name="MSSQLSERVER"
/>
<EventID
Qualifiers="49152">17051</EventID>
<Level>2</Level>
<Task>2</Task>
<Keywords>0x80000000000000</Keywords>
<TimeCreated
SystemTime="2014-03-19T12:26:19.000Z" />
<EventRecordID>56278</EventRecordID>
<Channel>Application</Channel>
<Computer>saturn</Computer>
<Security />
</System>
<EventData>
<Binary>9B4200001000000007000000530041005400550052004E00000000000000</Binary>
</EventData>
</Event>
The main error log must be shown as “SQL Server
evaluation period has expired.”
To fix this problem, you must have 2 things: installation
CD and CD-key.
In my solution, I have only standard edition key. So, I
have to download the standard edition install CD as well. These 2 things must
match together, if it mismatch, the upgrade cannot be done.
1. Insert the installation CD, launch the setup widows.
Select maintenance option in the left-hand panel. Then, select edition upgrade.
2. Next 2 windows will be shown as the setup support
rules. Click Next on both windows.
3. Enter your purchase product key, click next.
4. Accept the license term, click next. And click next
once again on selecting instance page.
5. Click next on edition upgrade rule page.
6. Then, it will show you the ready to upgrade edition,
click upgrade button, then wait for everything is completed.
7. Once the upgrade edition is completed, it will show
every feature as passed status. Click close button to exit this wizard.
8. Verify your upgraded edition via log file which
located at C:\Program Files\Microsoft SQL Server\110\Setup Bootstrap\Log\Summary.txt
Overall summary:
Final result: Passed
Exit code (Decimal): 0
Start time: 2014-03-19 19:18:41
End time: 2014-03-19 19:32:34
Requested action: EditionUpgrade
Machine Properties:
Machine name: SATURN
Machine processor count: 16
OS version: Windows Server 2008
OS service pack: Service Pack 2
OS region: United States
OS language: English (United States)
OS architecture: x86
Process architecture: 32 Bit
OS clustered: No
Product features
discovered:
Product Instance Instance ID Feature Language Edition Version Clustered
SQL Server 2012 MSSQLSERVER MSSQL11.MSSQLSERVER Database Engine Services 1033 Enterprise Evaluation Edition
11.1.3000.0 No
SQL Server 2012 MSSQLSERVER MSSQL11.MSSQLSERVER SQL Server Replication 1033 Enterprise Evaluation Edition
11.1.3000.0 No
SQL Server 2012 MSSQLSERVER MSSQL11.MSSQLSERVER Full-Text and Semantic Extractions
for Search 1033
Enterprise Evaluation Edition 11.1.3000.0 No
SQL Server 2012 MSSQLSERVER MSSQL11.MSSQLSERVER Data Quality Services 1033 Enterprise Evaluation Edition
11.1.3000.0 No
SQL Server 2012 MSSQLSERVER MSAS11.MSSQLSERVER Analysis Services 1033 Enterprise Evaluation Edition
11.1.3000.0 No
SQL Server 2012 MSSQLSERVER MSRS11.MSSQLSERVER Reporting Services - Native 1033 Enterprise Evaluation Edition
11.1.3000.0 No
SQL Server 2012
Management Tools - Basic
1033 Enterprise Evaluation Edition
11.0.2100.60 No
SQL Server 2012
Client Tools Connectivity
1033 Enterprise
Evaluation Edition 11.1.3000.0
No
SQL Server 2012
Client Tools Backwards Compatibility
1033 Enterprise
Evaluation Edition 11.1.3000.0
No
SQL Server 2012 Client Tools
SDK 1033 Enterprise Evaluation Edition
11.1.3000.0 No
SQL Server 2012
Integration Services 1033 Enterprise Evaluation Edition
11.1.3000.0 No
Package properties:
Description: Microsoft SQL Server 2012
Service Pack 1
ProductName: SQL Server 2012
Type: RTM
Version: 11
SPLevel: 0
Installation location: H:\x86\setup\
Installation
edition: Standard
Or you may check it via MSSQL Management Studio. Right
click at database instance, select server properties.
Check out in product field. It should be preferred edition. (in this
case, should be standard edition)
Hope this may be useful for anyone who stuck in the same problem as mine.
No comments:
Post a Comment