Installation Instructions for Microsoft SQLServer 2005 and Microsoft SQLServer 2005 Express Edition

1. Install SQLServer 2005 or SQLServer 2005 Express Edition

If you are using SQLServer 2005, have your system administrator install it now. If you are using SQLServer 2005 Express Edition, it was probably installed when you installed Visual Studio 2005. If you need to get it, download it from here. If you are installing SQLServer 2005 Express Edition, make note of the following.
  • Make sure all features are set to "install on local hard drive"
  • You can select either "Mixed Mode" or "Windows Authentication" as your Authentication Mode. WSRF.NET uses Windows Authentication which is supported in both modes.
  • You must select a password for the database administrator. WSRF.NET does not need to use this password.

2. Setup the database

Run the database setup script at {WSRFdotNet_install_dir}\Scripts\SqlExpress\setup.bat.

Note: The setup script takes up to two arguments, which are position sensitive (i.e. if you need to use the 2nd argument, you must also include the 1st). The first argument is the database name that you used during the install. If you used the default name - {your_machine_name}\SQLEXPRESS for SQLServer 2005 Express Edition, then the first argument is unnecessary. The second argument is the name of the account that your WSRF.NET web services runs as. On Windows XP, the default is "ASPNET". If you are using this account, you do not need to specify this argument. If you are using Windows 2003 Server, you should use the account name of the Application Pool uses by your web services.

3. Modify persistent-state.config if necessary.

Modify the persistent-state.config file The <connect-string> element may need to have the "Server=" changed. Set the "Server=" to be the name of the database you used in the last step. If you used the default name for SQLServer Express Edition, set this to {machine-name}\SQLEXPRESS.