Installation Instructions.

  • Download and extract zip file.
  • Create database called "EPM" on a SQL Server. (name can be anything)
  • Run "DBCreateScript.sql" against the database to create the required tables and stored procedures.
  • Create a SQL role with access to just run the stored procedures and create a login with membership of this role.
  • Copy the web folder contents to an IIS folder.
  • Create new website or virtual folder pointing to the copied EPM folder.
  • Make sure .net 2 is configured within asp.net for the website or virtual folder.

Web.Config

Modify the web.config amending the settings listed below for your own environment. 

(In the example below the ADConnectionString points to the "Users" container and is the root location where the provider will search for the user accounts, this can be changed to an OU depending on your environment)

 

 

 

<appSettings> 
     <add key="domain" value="testdomain.test.com" /> 
</appSettings>

<connectionStrings>
		<add name="ADConnectionString" connectionString="LDAP://testdomain.test.com/CN=Users,DC=testdomain,DC=test,DC=com"/>
		<add name="SQLConnectionString" connectionString="Data Source=localhost;Initial Catalog=EPM;Integrated Security=True" providerName="System.Data.SqlClient"/>
</connectionStrings>

 

Currently need to add some user credentials to the directory searcher in the default.vb unless site is running in the context of a domain account. (This will be moved to web.config)

Dim Entry As DirectoryEntry = New DirectoryEntry("LDAP://" & strADPath, "User", "Password")

Last edited Sep 8, 2011 at 3:43 PM by SteveKing79, version 6

Comments

No comments yet.