MaxSea TZ: Microsoft SQL Server problems End User

(1)

This TechNote applies to MaxSea TimeZero Navigator and Explorer v1.9.5 and above

Description:

TimeZero uses Microsoft SQL server to manage routes, marks, logbook and track data. Microsoft SQL server is installed as part of the TimeZero installation. In some instances, the installation of Microsoft SQL fails or the service is not properly launched resulting in the following error displayed at startup:

Resolution:

Follow the steps below (make sure to respect the order)

1) Remove any existing Microsoft SQL component

Close TimeZero and open the “Add or Remove Programs” utility from the Control Panel. Note: under Vista/7, you need to open “Programs” (or “Programs and Features”) from

the Control Panel.

You have to remove all the items whose name begins with “Microsoft SQL” (uninstall all of them) starting with the main component (“Microsoft SQL Server 2008” or “Microsoft SQL server 2005”)

(2)

Microsoft SQL Database

2 After removing the main component, close the “Programs” control panel and re-open it (this force Windows to refresh the list of installed programs). If you see any remaining item whose name begins with “Microsoft SQL”, remove them one by one (the order does not matter at this point).

2) Delete the Microsoft SQL Folder

When all the “Microsoft SQL” items are removed from the “Programs” Control Panel, go to the “Program Files” folder (Computer -> Local Disk (C:) -> Program files) and delete any folder beginning with “Microsoft SQL Server” if any.

Note: Under 64Bit Operating System, you also need to delete the “Microsoft SQL Server” folder from “Program Files (x86)” (Computer -> Local Disk (C:) -> Program files(X86))

IMPORTANT: If you cannot delete the “Microsoft SQL Server” from the program file

(because a process is running), contact our Tech Support.

Once all the Microsoft SQL components are removed and the folder deleted, restart the computer.

3) Re-install Microsoft SQL Server

a) Disable any Anti-virus/Anti-Spyware and Firewall that could be running in the background. Make sure that you are logged in as an Administrator.

b) If you have the MaxSea TimeZero DVD: Insert the TimeZero install DVD into the computer. If the Autorun starts, cancel it. Right click on the DVD icon and choose “Explore” to browse the content of the DVD. Browse to:

“\Tools\SetupPrerequisites\MSQL_Server_2008_Express_R2_MaxSeaInstance” and double click on “Setup.exe”

This will launch the manual installation of Microsoft SQL 2008R2.

If you don’t have the DVD: Download and run the standalone SQL Installer:

http://download.maxsea.com/MSQL_Server_2008_Express_R2_MaxSeaInstance.ex e

c) The SQL installer will ask you to accept agreements and to confirm multiple steps: simply leave the default settings and click on “OK”, “Next” or “Install”.

Note: You can refer to the Appendix (chapter 2) to see all the steps and the prompts of the Microsoft SQL installation under Vista/7

d) If the installation is successful restart the computer. e) Launch TimeZero

(3)

3

Appendix

(4)

(5)

(6)

(7)

(8)

(9)

(10)

10 3) Manually remove SQL Server (advanced)

Follow the steps below if for some reasons you cannot remove SQL Server using the common process:

- Go to the Control Panel -> Add/Remove Programs (or “Programs” under Windows 7/Vista). Select and Remove the maximum amount of Microsoft SQL Server programs. If you cannot remove a component, skip it (it will be removed later using the Windows Clean Up utility)

- Open the Control Panel - Administrative Tools – Services

(11)

11 - Double click each SQL Service and note the "Service Name: xxx" and click on

“Stop” if the service is running

- From the Command line (Start - Run - CMD) type: sc delete xxx (enter the Service Name from above) Example: “sc delete

MSSQL$MAXSEASQLEXPRESS”. Repeat this for each SQL Services

Note: If you have an error stating that the service cannot be removed because you are not authorized, close the CMD window and start it again using the “Run as Administrator” option.

- Open REGEDIT (Start - Run – REGEDIT or search for “Regedit” under Windows 7). Back up your Registry Editor. Highlight My Computer (at the very top) then select - File - Export.

- From REGEDIT go to the folder:

(12)

12

Note: you may have less Microsoft SQL server folder on your computer

- From Windows Explorer go to Program Files (and “Program Files (x86)” on 64bits OS) then right click on “Microsoft SQL server” folders and select DELETE

- If some SQL components are still present in the “Add/Remove” programs, run the Microsoft Windows Cleanup Utility to remove all SQL programs.

- Reboot the computer

(13)

13

Permission Type Category OS Product Version Keyword