Avatar of walid97
walid97

asked on 

SQL Server 2005 Enterprise - Evaluation period has expired

Hello,

I installed SQL Server 2005 Enterprise Evaluation edition on my server, now I got following error...Evaluation period has expired. As a result, my program using SQL Enterprise Evaluation can no longer start! (CA Unicenter Service Desk).

I got a licensed SQL Server Standard edition from Microsoft. How can I "upgrade" from the evaluation period to the licensed one? I need to keep Service Desk database (mdb) intact, without any change.

I read that can copy the files: mdb.mdf and mdb_log.LDF from: c:\program files\Microsoft SQL Server\MSSQL.1\MSSQL\Data" to the C Drive, then uninstall the evaluation version, then re-install the licensed version of SQL, then attach these 2 files to it.

Here's the Microsoft Tech document concerning this:
http://support.microsoft.com/kb/914158

Is that the only solution? Will this solve my problem? Do these 2 files contain everything needed (Will I be able to take over as if nothing happened?), please advice.

Thank you.

image003.jpg
image004.jpg
Microsoft SQL Server 2005Microsoft SQL Server

Avatar of undefined
Last Comment
EugeneZ
Avatar of Anthony Perkins
Anthony Perkins
Flag of United States of America image

If Logins are unimportant and you don't mind recreating them that is an option.
Another option is to restore from a backup.
Avatar of walid97
walid97

ASKER

Yes, login is important. If I attach the 2 files, and use the same username and pasword that I used in my evaluation installation, will it work?

And if I have a backup (a little old!), how do I restore it?

Thanks.
ASKER CERTIFIED SOLUTION
Avatar of Anthony Perkins
Anthony Perkins
Flag of United States of America image

Blurred text
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
Avatar of walid97
walid97

ASKER

WHat if I backup the WHOLE database files in the "c:\program files\Microsoft SQL Server\MSSQL.1\MSSQL\Data" folder?

Will that include the master database?

Thank you.
SOLUTION
Avatar of EugeneZ
EugeneZ
Flag of United States of America image

Blurred text
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
Microsoft SQL Server
Microsoft SQL Server

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.

171K
Questions
--
Followers
--
Top Experts
Get a personalized solution from industry experts
Ask the experts
Read over 600 more reviews

TRUSTED BY

IBM logoIntel logoMicrosoft logoUbisoft logoSAP logo
Qualcomm logoCitrix Systems logoWorkday logoErnst & Young logo
High performer badgeUsers love us badge
LinkedIn logoFacebook logoX logoInstagram logoTikTok logoYouTube logo