Skip to content

SQL SERVER INSTALLATION

Jump to bottom
mandolin edited this page Aug 31, 2021 · 1 revision

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.

Clone this wiki locally