SQL SERVER INSTALLATION

You need to manually run the SQL scripts provided in the Setup subfolder. Then you also need to change the SQL connection string attribute in the web.config.

Running SQL scripts on remote server

  1. Open SQL Query Analyzer on the remote machine.
  2. Run Setup\Portal_CreateDB.sql.
  3. Run Setup\PortalGrantPermissionsForRemote.sql.
  4. Run Setup\Portal_LoadData.sql.

Running the scripts creates a SQL login, PortalUser, with this password: PortalUser

Changing the SQL Connection String in the web.config file

  1. Open the web.config file using a text editor.
  2. Under <configuration>\<appSettings>\<add key="ConnectionString" ... />, change the value attribute.
  3. Modify the value attribute to the desired connection string (you can't use Integrated Security) using PortalUser as both the uid and pwd pointing to the remote SQL Server.

web.config section
<add key="ConnectionString" value="server=REMOTE_SERVER;database=Portal;uid=PortalUser;pwd=PortalUser;" />

Database clean up

You can manually run the SQL script, Portal_CleanUp.sql, provided in the Setup subfolder using Query Analyzer.