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

Post on 27-Jul-2020

7 Views

Category:

Documents

0 Downloads

Preview:

Click to see full reader

TRANSCRIPT

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

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

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.

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.

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.

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

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

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

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.

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

MS-SQL 2008 Upgrade Guide

Step 17

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.

Cscenter@morpho.com

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

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

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

MS-SQL 2008 Upgrade Guide

3) Double click "PendingFileRenameOperations"

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

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

MS-SQL 2008 Upgrade Guide

top related