If you are not using the built-in database engine included with the ServiceLedger Installer, you will need to restore a database to a fully licensed MS SQL Server (or an Express edition). If you are using MS SQL Server 2005, 2008, 2008 R2, or 2012, you must restore the database through the MS SQL Server Management Studio.
There are two broad steps to this process:
- Restore a ServiceLedger database to your SQL Server
- Use the ServiceLedger installer to do a WORKSTATION install on your server.
To restore the database:
- If you're installing from scratch, contact ServiceLedger support to obtain the correct empty database backup for your version of ServiceLedger. If you're moving from an existing server, get a copy of the latest ServiceLedger backup (see KB Article T0003) from your old server.
- Open SQL Server Management Studio and log into the SQL Server instance-- Important: You can freely obtain and download MS SQL Server Management Studio from Microsoft's website
- Right click the Databases node under the chosen server and select Restore Database
- In the To database field enter in ServiceLedger (use the same capitalization)
- Select the From device: option, then click the [...] box
- Ensure the Backup media: field is set to File
- Click Add
- Navigate to the local disk (it must be a local fixed disk, not removable media or a network share) and locate your downloaded .BAK file (or your previous backup, if the installation is not new), then click OK
- Click OK on the Specify Backup window
- Check the ServiceLedger Database in the Select the backup sets to restore: frame
- Click the Options node in the Select a Page view on the left
- In the Restore the Database Files as Grid, please alter the paths as necessary for your storage. Alternatively you can simply create the specified folder before proceeding.
- Click OK
- After a few moments the database will be restored and your ServiceLedger database will be visible under the Databases node on the left
- Note: You may need to grant access to the new ServiceLedger database to your SQL Server or NT Users. ServiceLedger requires public and db_owner access on the ServiceLedger database.
In addition to restoring the ServiceLedger database, you will need to perform additional server configuration to make sure that the database is accessible to workstations.
- Enable xp_cmdshell; see the following KB Article for instructions: (T0151) ServiceLedger won't launch and shows the error message: "SQL Server blocked access to procedure 'sys.xp_cmdshell'..."
- Enable the TCP/IP protocol using the SQL Server Configuration Manager (Look for "SQL Server Network Configuration")
- Ensure the SQL Server Browser Service is enabled, running, and set to start automatically by going to Control Panel > Administrative Tools > Services or by typing services.msc from a command line. If you have previously run other installations of SQL Server, the SQL Server Browser service may be disabled.
- The following Firewall Exceptions must be created:
- Port opening: UDP port 1434 (the port through which workstations communicate with the SQL Browser service)
- Program exception for sqlservr.exe: You will need to locate the copy of sqlservr.exe that corresponds with your database. You can find this by right-clicking on your ServiceLedger database in SQL Management Studio, selecting Properties, then selecting the Files page from the pane on the left:
The directory referenced under Path will help you find where sqlservr.exe is located. If the path listed for the database files is:
C:\Program Files\Microsoft SQL Server\MSSQL10_50.SERVICELEDGER\MSSQL\DATA,
then sqlservr.exe will be located one directory higher in the \BINN folder. The location of sqlservr.exe, then, in this example will be:
C:\Program Files\Microsoft SQL Server\MSSQL10_50.SERVICELEDGER\MSSQL\BINN.
Completing Workstation Installs:
See the following KB article for information on completing the WORKSTATION installations: