pgrade procedure · ms-sql 2008 upgrade guide 1 overview this manual describes how to upgrade from...

16
Copyright © 2009 L-1 Identity Solutions. All rights reserved. 3 - 1 MS-SQL 2008 Upgrade Guide 1 OVERVIEW This manual describes how to upgrade from Microsoft MS-SQL 2005 to MS-SQL 2008. MS- SQL is one of Morpho SecureAdmin TM application. This manual is intended as a practical "third-party" information for users of L-1 Security Solutions hardware and software and is not intended to replace the MS-SQL 2008 help files users should consult for specific questions or customized configuration of MS-SQL 2008 server. 2 UPGRADE PROCEDURE Follow the procedure below, once the MS-SQL 2008 installation has started. Step 1 Click YES to upgrade from MS-SQL 2005 to MS-SQL 2008. Step 2

Upload: others

Post on 27-Jul-2020

5 views

Category:

Documents


0 download

TRANSCRIPT

Page 1: PGRADE PROCEDURE · MS-SQL 2008 Upgrade Guide 1 OVERVIEW This manual describes how to upgrade from Microsoft MS-SQL 2005 to MS-SQL 2008. MS-SQL is one of Morpho SecureAdminTM application

Copyright © 2009 L-1 Identity Solutions. All rights reserved. 3 - 1

MS-SQL 2008 Upgrade Guide

1 OVERVIEW

This manual describes how to upgrade from Microsoft MS-SQL 2005 to MS-SQL 2008. MS-SQL is one of Morpho SecureAdminTM application. This manual is intended as a practical "third-party" information for users of L-1 Security Solutions hardware and software and is not intended to replace the MS-SQL 2008 help files users should consult for specific questions or customized configuration of MS-SQL 2008 server.

2 UPGRADE PROCEDURE

Follow the procedure below, once the MS-SQL 2008 installation has started.

Step 1

Click YES to upgrade from MS-SQL 2005 to MS-SQL 2008.

Step 2

Page 2: PGRADE PROCEDURE · MS-SQL 2008 Upgrade Guide 1 OVERVIEW This manual describes how to upgrade from Microsoft MS-SQL 2005 to MS-SQL 2008. MS-SQL is one of Morpho SecureAdminTM application

Copyright © 2009 L-1 Identity Solutions. All rights reserved. 3 - 2

MS-SQL 2008 Upgrade Guide

Click Installation on the left of the screen that appears.

Step 3

Click OK on the Setup Support Rules screen.

Step 4

Page 3: PGRADE PROCEDURE · MS-SQL 2008 Upgrade Guide 1 OVERVIEW This manual describes how to upgrade from Microsoft MS-SQL 2005 to MS-SQL 2008. MS-SQL is one of Morpho SecureAdminTM application

Copyright © 2009 L-1 Identity Solutions. All rights reserved. 3 - 3

MS-SQL 2008 Upgrade Guide

Click Next on the Product Key screen.

Step 5

Click the I accept the license terms check box and the Next button on the License Terms screen.

Page 4: PGRADE PROCEDURE · MS-SQL 2008 Upgrade Guide 1 OVERVIEW This manual describes how to upgrade from Microsoft MS-SQL 2005 to MS-SQL 2008. MS-SQL is one of Morpho SecureAdminTM application

Copyright © 2009 L-1 Identity Solutions. All rights reserved. 3 - 4

MS-SQL 2008 Upgrade Guide

Step 6

Click Install on the Setup Support Files screen.

Step 7

Click Next on the Setup Support Rules screen.

Page 5: PGRADE PROCEDURE · MS-SQL 2008 Upgrade Guide 1 OVERVIEW This manual describes how to upgrade from Microsoft MS-SQL 2005 to MS-SQL 2008. MS-SQL is one of Morpho SecureAdminTM application

Copyright © 2009 L-1 Identity Solutions. All rights reserved. 3 - 5

MS-SQL 2008 Upgrade Guide

Step 8

Click Database Engine Services to select them and click Next on the Feature Selection screen.

Step 9

Check if the Named Instance radio button is checked and click Next.

Page 6: PGRADE PROCEDURE · MS-SQL 2008 Upgrade Guide 1 OVERVIEW This manual describes how to upgrade from Microsoft MS-SQL 2005 to MS-SQL 2008. MS-SQL is one of Morpho SecureAdminTM application

Copyright © 2009 L-1 Identity Solutions. All rights reserved. 3 - 6

MS-SQL 2008 Upgrade Guide

Step 10

Click Next on the Disk Space Requirements screen.

Step 11

Click Use the same account for all SQL Server services on the Server Configuration screen. You will get Pop-up window (see next step).

Page 7: PGRADE PROCEDURE · MS-SQL 2008 Upgrade Guide 1 OVERVIEW This manual describes how to upgrade from Microsoft MS-SQL 2005 to MS-SQL 2008. MS-SQL is one of Morpho SecureAdminTM application

Copyright © 2009 L-1 Identity Solutions. All rights reserved. 3 - 7

MS-SQL 2008 Upgrade Guide

Step 12

Click the Account Name drop-down and select NT AUTHORITY/NETWORK SERVICE on the dialog box.

Click OK on the dialog box.

Click Next at the bottom of the server configuration page

Step 13

Page 8: PGRADE PROCEDURE · MS-SQL 2008 Upgrade Guide 1 OVERVIEW This manual describes how to upgrade from Microsoft MS-SQL 2005 to MS-SQL 2008. MS-SQL is one of Morpho SecureAdminTM application

Copyright © 2009 L-1 Identity Solutions. All rights reserved. 3 - 8

MS-SQL 2008 Upgrade Guide

Click Add Current User to configure Server Administrator Account.

Click Next on The Database Engine Configuration screen.

Step 14

Click Next on the Error and Usage Reporting screen.

Step 15

Page 9: PGRADE PROCEDURE · MS-SQL 2008 Upgrade Guide 1 OVERVIEW This manual describes how to upgrade from Microsoft MS-SQL 2005 to MS-SQL 2008. MS-SQL is one of Morpho SecureAdminTM application

Copyright © 2009 L-1 Identity Solutions. All rights reserved. 3 - 9

MS-SQL 2008 Upgrade Guide

Click Next on the Installation Rules screen.

Step 16

Click Install on the Ready to Install screen.

The Installation Progress screens appear.

Page 10: PGRADE PROCEDURE · MS-SQL 2008 Upgrade Guide 1 OVERVIEW This manual describes how to upgrade from Microsoft MS-SQL 2005 to MS-SQL 2008. MS-SQL is one of Morpho SecureAdminTM application

Copyright © 2009 L-1 Identity Solutions. All rights reserved. 3 - 10

MS-SQL 2008 Upgrade Guide

Step 17

Page 11: PGRADE PROCEDURE · MS-SQL 2008 Upgrade Guide 1 OVERVIEW This manual describes how to upgrade from Microsoft MS-SQL 2005 to MS-SQL 2008. MS-SQL is one of Morpho SecureAdminTM application

Copyright © 2009 L-1 Identity Solutions. All rights reserved. 3 - 11

MS-SQL 2008 Upgrade Guide

Click Close on the Complete screen to finish the upgrade installation.

3 TECHNICAL SUPPORT CONTACT INFORMATION

The Morpho team endeavors to resolve all inquiries from clients with supported products in a timely fashion. Please visit our webpage for the most up to date, hours, contacts and resources available for resolving your technical needs. Please note that some services are provided under a support contract or warranty only.

[email protected]

Page 12: PGRADE PROCEDURE · MS-SQL 2008 Upgrade Guide 1 OVERVIEW This manual describes how to upgrade from Microsoft MS-SQL 2005 to MS-SQL 2008. MS-SQL is one of Morpho SecureAdminTM application

Copyright © 2009 L-1 Identity Solutions. All rights reserved. 3 - 12

MS-SQL 2008 Upgrade Guide

Problem Description restart Computer when installing SQL.

Trying to install SQL Server 2008 Developer edition setup fails at the Setup Support Rules page

on the Rule "Restart Computer". The following error message appear on screen: "Restart

computer failed".

Page 13: PGRADE PROCEDURE · MS-SQL 2008 Upgrade Guide 1 OVERVIEW This manual describes how to upgrade from Microsoft MS-SQL 2005 to MS-SQL 2008. MS-SQL is one of Morpho SecureAdminTM application

Copyright © 2009 L-1 Identity Solutions. All rights reserved. 3 - 13

MS-SQL 2008 Upgrade Guide

Rule "Restart Computer" failed.

A computer restart is required. You must restart this computer before installing SQL Server.

The error message asks for a computer restart, but after rebooting the computer

many times, setup keeps failing on the same step.

Cause.

In general, a previous program installation created pending file operations on the installation machine.

Solution.

Please follow the steps below:

1) Open the registry.

2) Open HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\Session Manager

Page 14: PGRADE PROCEDURE · MS-SQL 2008 Upgrade Guide 1 OVERVIEW This manual describes how to upgrade from Microsoft MS-SQL 2005 to MS-SQL 2008. MS-SQL is one of Morpho SecureAdminTM application

Copyright © 2009 L-1 Identity Solutions. All rights reserved. 3 - 14

MS-SQL 2008 Upgrade Guide

3) Double click "PendingFileRenameOperations"

Page 15: PGRADE PROCEDURE · MS-SQL 2008 Upgrade Guide 1 OVERVIEW This manual describes how to upgrade from Microsoft MS-SQL 2005 to MS-SQL 2008. MS-SQL is one of Morpho SecureAdminTM application

Copyright © 2009 L-1 Identity Solutions. All rights reserved. 3 - 15

MS-SQL 2008 Upgrade Guide

4) Press the key "Delete" on your keyboard.

5) Press OK and close the registry.

6) Click Re-Run

Page 16: PGRADE PROCEDURE · MS-SQL 2008 Upgrade Guide 1 OVERVIEW This manual describes how to upgrade from Microsoft MS-SQL 2005 to MS-SQL 2008. MS-SQL is one of Morpho SecureAdminTM application

Copyright © 2009 L-1 Identity Solutions. All rights reserved. 3 - 16

MS-SQL 2008 Upgrade Guide