FlexLink YOUTILIZE - Manual (Page 99)

Providing production efficiency
Page 99 of 125
Is the Database Service Running
If the service is running, it is an indication that SQL Server has installed correctly and the database is
available for use by the toolset.
You can check to see if the Database Service is running by navigating to your the Services
application. Depending on your operating system, the path may be a bit different, but it should be
along the lines of Start>>Control Panel>>Administrative Tools>>Services(alternately type
"services.msc" (excluding quotes) into a run window)
Scroll down through the list and look for a service named "SQL Server (IMONITOREXPRESS)". Check
the Status of the service. If the status is anything other than "Running" (or, possibly, "Started" in the
case of Windows XP users), right click on it and select "Start". If it then starts successfully the status
will change to "Running".
If the Service refuses to Start or does not exist, more troubleshooting is needed some kind of
installation issue with SQL Server. We need to look at the properties on the service and figure out
where to go from here. One is files left over from some manual file deletions, the .mdf and .ldf files
no longer exist, but the service is still there. Path to executable field may hold some clues.
• Ensure SQL Server (IMONITOREXPRESS): Open the SQL Server Configuration Manager (by
default
Start | Microsoft SQL Server 2005 | Configuration Tools | SQL
Server Configuration Manager ) and in the object tree in the left hand panel click on
the SQL Server Services entry. Ensure entry for SQL Server (IMONITOREXPRESS) appearing in
the right hand panel has a State of Running. If not select it and start it (either using the
button on the toolbar or the option in the context menu).
Did SQL Server Install?
Check your Start menu and see if it installed at all. Go to Start>>Program Files>>Microsoft SQL
Server 2008. If nothing exists here then there are two basic explanations:
1. When you selected to install manually, ran the installer, and omitted to install MSSQL
Express. If this is the case. Try performing the installation procedure a second time, make
sure that you install SQL Server 2008.
2. Something went wrong with the SQL Server installation and it failed to install at all. You can
try installing the software again. If this is unsuccessful, you can try downloading and
installing it manually.
Did the database get created?
Check the toolset installation directory for the restored database files. Depending on where you
installed the Game and Toolset, they will be in a location similar to
C:\Program Files (x86)\Microsoft SQL
Server\MSSQL10_50.IMONITOREXPRESS\MSSQL\DATA
Browse to this location and look for the existence of the following two files: