From EpiHandy

There can be many reasons for EpiHandy Server not running properly, the following is a listing of possible solutions.

Contents 1 How to start / stop EpiHandy Server 1.1 Start using EpiHandy Advanced Tools 1.2 Start using SQL Server Service Manager 1.3 Start using Windows Services 2 Resolving failed startup 2.1 Resolve using EpiHandy Advanced Tools 2.2 Resolve using Windows Services

How to start / stop EpiHandy Server

Start using EpiHandy Advanced Tools

1. Start EpiHandy
2. In the Login window go to Settings
3. In the Settings window go to Advanced Tools
4. On the Status tab, there are 2 buttons:
5. Start SQL Server
6. Stop SQL Server
7. A message will be displayed stating SQL Server started or stopped.
8. If the status still shows that the server is not running, then try the 2 other startup options below.

Start using SQL Server Service Manager

To open SQL Server Service Manager do ONE of the following:

• On the Windows Taskbar, in the listing of services there should be a computer icon with a green Start or red Stop button on it. Double click this icon
• -> Start -> Run ->  sqlmanager
• -> Start -> Run -> C:\Program Files\Microsoft SQL Server\80\Tools\Binn\sqlmangr.exe
• Or go to the folder: C:\Program Files\Microsoft SQL Server\80\Tools\Binn\ and there double click the file called sqlmangr.exe

Once this window has opened

1. From the Server dropdown list select the one ending with \EPIHANDY
2. From the Services dropdown list select SQL Server
3. Ensure that Auto-start service when OS starts is selected
4. Click on Start/Continue
5. From the Services dropdown list select SQL Server Agent
6. Ensure that Auto-start service when OS starts is selected
7. Click on Start/Continue

If you get any messages about failing to start the server, then continue onto steps outlined below.

Start using Windows Services

1. -> Start -> Control Panel -> Administrative Tools -> Services
2. In the window listing the services running, go to: MSSQL$EPIHANDY
3. Rigth click and select Start, or use the Start link to the left of the services listing.
4. go to: SQLAgent$EPIHANDY
5. Rigth click and select Start, or use the Start link to the left of the services listing.

If you get any messages about failing to start the server, then continue onto steps outlined below.

If MSSQL$EPIHANDY is not listed, then the EpiHandy Server is not installed on your system.

Resolving failed startup

If both of the following procedures fail it is recomended that you contact EpiHandy Support team for further instructions.

Alternatively ty doing a complete reinstall as described in detail in EpiHandy_ReInstallation.

Resolve using EpiHandy Advanced Tools

1. Start EpiHandy
2. In the Login window go to Settings
3. In the Settings window go to Advanced Tools
4. Click on the Startup tab
5. Without changing any of the settings click on: Apply SQL Server Startup settings
6. Once complete go to the Status window and refresh.

If this fails you may

1. go back to Startup tab
2. Select the option Use a local Windows user account
3. Enter a username and password with Administrative permissions
4. If you are using a domain to logon, please select that and enter username like this: DOMAIN\USERNAME
5. Click Apply SQL Server Startup settings.
6. Once complete go to the Status window and refresh.

If this fails you may

1. -> Start -> Settings -> Control Panel -> Administrative Tools -> Computer Management
2. Using the left side node tree go to System Tools -> Local Users and Groups -> Users
3. In the listing of users, right click on episervice an select Delete
4. Answer Yes to any questions
5. Click Apply SQL Server Startup settings.
6. Once complete go to the Status window and refresh.

If all of the above steps fail, then it is likely that the installation is corrupt and needs to be reinstalled, but it is recomended to also try the steps below before doing that.

Resolve using Windows Services

1. -> Start -> Control Panel -> Administrative Tools -> Services
2. In the window listing the services running, go to: MSSQL$EPIHANDY
3. Rigth click and select Properties
4. On the General tab, ensure that Startup type is set to: Automatic
5. Go to the Log On tab
6. Ensure that the option This account is selected
7. Enter a username with Administrative permissions,
8. NOTE! if using a local account you must enter it like: .\USERNAME
9. NOTE! if using  domain account you must enter it like: DOMAIN\USERNAME
10. Click on OK
11. Start the service by right clicking and selecting Start
12. Repeat the above steps for the service listed as SQLAgent$EPIHANDY

'NOTE! If MSSQL$EPIHANDY and SQLAgent$EPIHANDY is not listed, then the EpiHandy Server is not installed on your system.