Note: The SQL Server will improve your Loadman Fleet Manager's performance if any of the following apply to you. Otherwise it is not required nor advised to perform this upgrade.

• You need to access the database over a slow data link such as older networks or a wide area network.
• You will have 4 or more users attached to the database at one time.

• You have Microsoft .NET Framework 2.0 installed. If you are not sure, check the list in Add or Remove Programs of your control panel.
• If you are running Windows XP, you must upgraded to SP2.
• If you are running Windows 2000, you must have SP4 and Microsoft Data Access Components (MDAC) 2.8 SP1 installed.
• If you are running Windows Server 2003, please have your system administrator verify that the latest upgrades including MDAC 2.8 SP1 are installed.
  

1. Go to www.loadmansoftware.com and select Released Software. You will be provided the login and password.
   Download SQLEXPR.EXE and SQLServer2005_SSMSEE.msi.
   
   
2. Run the SQL Server install program SQLEXPR.EXE.
   
   
   • Early in the setup this program will evaluate your system to be sure that it is capable of running SQL Server. Any problems must be fixed before proceeding.
   • When asked to select components, select Database Services, Client Components, and Connectivity Components.
   • When asked, select the Windows Authentication Mode. If you have a need to use SQL Server Authentication, you may select Mixed Mode. This choice can be easily changed later. The Communications Setup tutorial contains information about configuring Master and Satellite database connections for both Authentication Modes.
   • Leave both boxes unchecked for the Error and Usage Report Settings.
   
   
   
3. Run the SQL Server Management Studio install file SQLServer2005_SSMSEE.msi.
   
   
   • There is only one component, Management Studio Express, make sure that it is selected.
   
   
   
4. Open the Start Menu, select All Programs, select Microsoft SQL Server 2005, and then run the SQL Server Management Studio.
   
   
   • It will start with a Connect to Server screen showing. The Server Name combo box should show the name of the current computer and Authentication should show Windows Authentication. Press the Connect button.
   • As per the following screen shot, from the Object Explorer pane on the left, right-click Databases and select New Database. Set the Database Name (at the top of the dialog box) to LoadmanFleetManager. The rest of the defaults are OK unless you have a desire to store the database files elsewhere. Then click OK.
     
     
     
     
   • Close the SQL Server Management Studio.
   
   
   
5. If you want the database to only be accessible from the computer which it is installed on, you are done. Continue with the following to allow access to the database from other computers.
   
   
6. Open the Start Menu, select All Programs, select Microsoft SQL Server 2005, select the subgroup Configuration Tools, and run the SQL Server Configuration Manager.
   
   
   • In the tree control at the left, expand the item SQL Server 2005 Network Configuration (If it has a '+' to the left, click it, if it has a '-' it is already expanded).
   • Click Protocols for SQLEXPRESS.
   • Then on the right pane right-click TCP/IP and select Properties. This will bring up a dialog box. Set all entries as per the following screen shot.
     
     
     
     
   • Now select the IP Address tab and set the values for IP1 as per the following screen shot. Note that the IP address shown will probably not be the same as yours. This is OK, do not change it.
     Advanced users: If you have a server with multiple NICs, edit the entry for the IP that you will be using for the database connection.
     Then click OK.
     
     
     
     
   • In a similar fashion, expand the item SQL Native Client Configuration in the tree on the left, click Client Protocols, right-click TCP/IP in the right pane, and select Properties. Set the values as shown in the following screen shot. Then click OK.
     
     
     
     
   • Click SQL Server 2005 Services. Then in the right pane right-click SQL Server (SQLEXPRESS) and restart it as per the following screen shot.
     
     
     
     
   • In the right pane, right-click SQL Server Browser, select Properties, and then select the Service tab. Then set the Start Mode to Automatic as shown the following screen shot. Then click OK.
     
     
     
     
   • Then right-click again on SQL Server Browser and select start as shown in the following screen shot.