INF: How to Upgrade SQL Server 7.0 Evaluation Edition to Retail Version

Article translations Article translations
Article ID: 237303 - View products that this article applies to.
This article was previously published under Q237303
This article has been archived. It is offered "as is" and will no longer be updated.
Expand all | Collapse all

Summary

When the 120-day evaluation period for your SQL Server evaluation version has expired, you will see the following message when you start SQL Server:
The evaluation period has expired for this evaluation version of SQL Server.
In the Microsoft Windows NT application event log and in the SQL Server error log, you will see the following message:
SQL Server evaluation period has expired.
Event ID: 17052
If you want to continue using the product after this period, you must purchase and install the fully licensed version of SQL Server 7.0.

After purchasing a license for SQL Server, you cannot simply upgrade from the evaluation edition to the licensed version by running SQL Setup. This article describes how to uninstall the evaluation edition and install a licensed version without losing any data that is stored in the databases you created in the evaluation edition.

More information

This process will work with an evaluation version that has exceeded the 120-day limit (time-bombed) or one that has not yet expired. The instructions assume that you have installed SQL Server 7.0 to the C:\Mssql7 directory. If your SQL Server is installed to a different directory, substitute the correct directory name where appropriate.
  1. Make a backup of all *.mdf, *.ndf, and *.ldf files. If you are not sure where all of your database files reside, the following stored procedure can be used to return a list of all files:
        CREATE PROCEDURE sp_list_db_files AS
       DECLARE @dbname sysname
       DECLARE @dbstatus INT
    
       SET NOCOUNT ON
       CREATE TABLE #db_files (dbname sysname, phys_name NVARCHAR(520))
       DECLARE db_curs INSENSITIVE CURSOR FOR 
         SELECT name, status FROM master.dbo.sysdatabases
       OPEN db_curs
       FETCH NEXT FROM db_curs INTO @dbname, @dbstatus
       WHILE (@@FETCH_STATUS = 0)
       BEGIN
         IF (@dbstatus&32 + @dbstatus&64 + @dbstatus&128 
           + @dbstatus&256 + @dbstatus&512 = 0) 
           INSERT INTO #db_files 
           EXEC ('SELECT ''' + @dbname + ''', filename FROM ' + @dbname 
             + '.dbo.sysfiles')
         ELSE 
           PRINT 'WARNING: Could not get file list for database '''
             + @dbname + '''.  Database is currently inaccessible.'
         FETCH NEXT FROM db_curs INTO @dbname, @dbstatus
       END
       SELECT * FROM #db_files
       CLOSE db_curs
       DEALLOCATE db_curs
       RETURN (0)
       GO 
    						
  2. Move all files out of the default SQL data root directory to a temporary location. Make sure that you include the data files for the master and all other system databases. If you are not sure where your data root directory is, use Regedt32.exe to find the following registry value:
       HKEY_LOCAL_MACHINE\Software\Microsoft\MSSQLServer\Setup\SQLDataRoot
    						
    The parent directory of the SQL Server data directory is stored in this value; add "\Data" to get the actual path. For example, if the string is "C:\Mssql7", the actual data path is "C:\Mssql7\Data".
  3. Uninstall SQL Server 7.0 evaluation edition from Control Panel, using Add/Remove Programs.
  4. Install the retail version of SQL Server 7.0. Be sure to use the same data root directory that the evaluation edition used, which is the directory that was stored in the registry value listed in Step 2 (the default is C:\Mssql7).
  5. After the installation, copy the data files you moved to a temporary location in Step 2 back into the DATA directory. If you have started SQL Server, you must stop it before you will be able to replace the files. To do so, double-click Services on Control Panel, select MSSQLServer, and click Stop.
For related information on SQL Server 2000, see the following article in the Microsoft Knowledge Base:
281574 INF: How to Upgrade to SQL Server 2000 Retail Version After SQL Server 2000 Evaluation Edition Expires

Properties

Article ID: 237303 - Last Review: October 26, 2013 - Revision: 2.0
Applies to
  • Microsoft SQL Server 7.0 Standard Edition
Keywords: 
kbnosurvey kbarchive kbinfo KB237303

Give Feedback

 

Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from smallbusiness.support.microsoft.com