Client Server Setup

All RecPro client's must be configured to point to your SQL database.  This is done by pressing 'Server Setup' at the application login screen.  If you're launching RecPro for the first time you will be brought to this setup automatically.

1. Database Server:  SQL Server Name \ SQL Instance name  (You can replace the server name with its IP address if DNS is not working)

2. Port:  Always leave blank unless database was installed on a customer port number

3. Database Name:  RecPro SQL Database name.  The default is 'recpro'.

4. User Name:  SQL Login Username.  The default is 'recpro'.

5. Password:  SQL Login Password.  Call RecPro support for the default password.

This data is saved to a local file named ServerSettings.xml found under C:\ProgramData\IsolatedStorage\[RandomString]\[RandomString]\StrongName.[RandomString]\AssemFiles.  You can also edit this file manually if needed.

<?xml version="1.0"?>
<ServerSetup xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema">
  <Server>ServerName\Instance</Server>
  <Port />
  <Database>recpro</Database>
  <UserName>recpro</UserName>
  <Password>PasswordEnteredHere</Password>
  <IntegratedSecurity>false</IntegratedSecurity>
</ServerSetup>

If your client application is not opening it could be due to a corrupt ServerSetings.xml file or its being pointed to a database server that no longer exists.  You can delete the ServerSettings.xml file above and restart the application to reset this configuration. The file will regenerate with default data when RecPro is reopened.