If not; you will receive this message:
In this event you must ensure that you have entered a valid SQL Server and database name and that the machine you are attempting to connect from is able to connect to the SQL Server in question.
1. Click on Start – Run – Richmond Systems –SupportDesk Web Interfaces – Self Service Portal – Self Service Portal Administration from the Windows Start menu.
2. The Web Admin application will appear. At this point, the main options will be disabled as you are required to browse for the Self Service Portals configuration file called Web.config. This is an XML file which contains all application settings for the system.
Note:
The application will attempt to load Web.config automatically when it is started. If this does not happen; the file can be found in the root directory of the SupportDeskSSP website (i.e. C:/InetPub/wwwroot/… )
3. In the Database Connection Settings frame, enter the required SQL Server and database name.
4. Click on the Test button. If the test is successful; you will receive the following message:
If not; you will receive this message:
In this event you must ensure that you have entered a valid SQL Server and database name and that the machine you are attempting to connect from is able to connect to the SQL Server in question.
5. The Advanced Database Options allow you to fine-tune the database connection pool and should only be changed if you are expecting more than 100 concurrent users to be connected to the system at any single point in time. If this is the case, you should increase the value of the Maximum Pool setting by the required amount.
Warning:
Setting the Maximum Pool to a value which is too low could result in users experiencing database connectivity problems and so it is recommended that the default value of 100 is used for most installations.
6. Once you are satisfied with the settings, click on the Save button to update the configuration file and exit the application.
Note:
The settings specified with the Web Admin application are only loaded when the Self Service Portal application is started. If changes are made whilst the web application is running then it will be necessary for you to restart it before the new settings are applied. This will cause any active user sessions to be lost.