| Server Requirements |
 |
Windows 2003 Server or newer (or a dedicated Windows XP, Vista, or Windows server may be used). |
|
Microsoft .Net Framework 2.x or greater. |
|
Microsoft SQL Server: One of the following is required: SQL Server 2005, SQL Server 2005 Express, SQL Server 2008, or SQL Server 2008 Express. (Note: SQL Server Express editions are free downloads from Microsoft.com) |
|
IIS 5.1 or greater. |
| |
Configuration Files
After installing Scotland Yard there are two (2) configuration files that must be modified for Scotland Yard to work in your environment.
How to change the configuration files is documented later on this installation page.
| File Name |
Description |
| web.config |
.Net configuration file for the web services |
| config.xml |
Configuration file for the client web software |
Running the setup.exe
After downloading and unzipping the syweb.zip file, run the setup.exe file ON THE SERVER to install Scotland Yard.
Below are some of the screen shots that will be displayed:
Change the Virtual Directory from "Setup Project" to "ScotlandYard" (no spaces). If you want to use another name for the virual directory,
it is recommended that the virtual directory does not include spaces. The virual directory will be part of the URL for employees to access the software.
Please read the read me file for the overview of the installation steps. The read me file will also be installed in the virtual folder under the name
SCOTLAND YARD WEB EDITION.rtf
Modifying the configuration files
After Scotland Yard Web Edition is installed into the Virtual Directory, there are two configuration files that need to be modified.
Step 1: Modify the web.config configuration file.
In the folder where Scotland Yard Web Edition was installed, modify the "connectionString" in the web.config file. The web.config file will looks like this:
Use WordPad or an XML editor to edit the file. Change the SERVERNAME to the name of your server that is running SQL Server. Most of the time this may be the same server name as the name of the server where Scotland Yard is installed.
If needed, modify the Integrated Security section to meet your server requirements, including changing it to user name / password.
Step 2: Modify the config.xml configuration file
In the folder where Scotland Yard Web Edition was installed, modify the config.xml file.
The config.xml file will looks like this:
Use WordPad or an XML editor to edit the file. Change the "http://192.168.200.104/sy.asmx?WDSL" to the URL of your server that the employee's will be accessing. Do not make the URL "localhost" as this will not work from employee's workstations.
Examples:
webServiceURL value="http://intranet.mycompany.com/scotlandyard/sy.asmx?WSDL"
webServiceURL value="http://192.168.100.101/sy.asmx?WSDL"
After you make the change to the config.xml, cut and paste the value settings (i.e. http://192.168.100.101/sy.asmx?WSDL) into a browser window.
If the Scotland Yard web service page is displayed, you will know that the config.xml file should be setup correctly.
SQL Database setup and Configuration
Step 1: Create the ScotlandYard database in SQL
The Scotland Yard SQL database was included in the setup package and is located in the same folder where the Scotland Yard files were installed.
The file name is ScotlandYard.bak
Run Micrsoft SQL Management Studio (or the Express version) and create a new database name ScotlandYard (no spaces in the name). Then select the menu choices Tasks, Restore, Database....
On the restore form, select "To Database: ScotlandYard". Select "from device" and then browse to the ScotlandYard.bak file.
The Scotland Yard file will then loaded with the database tables and sample data to get you started quickly.
Step 2: Add user access rights to the ScotlandYard database.
Depending on your MS SQL security settings, you may need to assign specific access rights to the Scotland Yard database. See the "Test Scotland Yard Web Services and Database" below.
If the test succeeds, then you do not need to this step (step 2).
With Microsoft SQL Management Studio still open, we now need to assign the necessary security access to the ScotlandYard database.
If using "Integrated Security" (our recommendation) for the SQL Connection, then we need to make sure MS SQL allows the
NT AUTHORITY\NETWORK SERVICE user to access the ScotlandYard database.
Follow these steps:
Test Scotland Yard Web Services and Database
The following test should be run from the server. Although the webservices are accessible from client workstations your server security settings
may disable the webservice "invoke" option (allowing you to enter in data to a web form an invoking the web method manually). Testing the webservice
from the server will allow you to "invoke" the web method for testing.
- Open a Web Browser on the server and enter in the URL of the location of the sy.asmx file. This is the connection string parameter in the web.config file you
edited earlier (minus the ?WSDL extention. Examples:
http://intranet.mycompany.com/scotlandyard/sy.asmx
http://192.168.100.101/sy.asmx
- Click on the validateUser method
- Fill out the validateUser form with "demo@demo.com" and "demo" for the LoginEmail and Password.
- Press the invoke button. If data is returned then you know everything is setup correctly.
This is what you should see when the validateUser method is selected:
After pressing the "invoke" button, this is the exepected result to be displayed in another web browser window:
How to run Scotland Yard
The ScotlandYard database is pre-populated with a sample set of employees.
To run Scotland Yard, run your browser application, then select the IP Address or URL with "scotlandyard.html".
Examples:
http://intranet.mycompany.com/scotlandyard/scotlandyard.html
http://sy.company.com/scotlandyard.html
To login, use the demo employee account information:
Login email: demo@demo.com
password: demo
After logging in, you may customize the departments, status codes, and employees.
Be sure to add additional users with Employee Administration rights before deleting the demo@demo.com user.
|
