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.

Last edited Apr 28, 2008 at 6:46 PM by cbakopanos, version 9

Comments

Taersious Mar 26, 2015 at 3:25 PM 
Does this project require a new database, or can it be executed against an already existing database on a server?