Community
Showing results for 
Search instead for 
Do you mean 
Reply

Configuring the ACT! Premium web server for multiple databases

Copper Contributor
Posts: 83
Country: NZ

Configuring the ACT! Premium web server for multiple databases

I   am currently working with a financial advisory group on a proposal to host   ACT! for web on a [single] web server. At this stage we think we will need to   maintain a separate DB for each franchise (maybe up to 20 separate DB's) to   maintain confidentiality between the franchises. Can you suggest a good paper or KB article I can provide to their IT support company that sets out how the   web server will should be configured. The Web Administrators guide is a bit thin on detail.
 
  I would also appreciate any comments re the practicality of even attempting   such a configuration.
 
  Kind regards,
  Mike Maltby
  Server Group (BOP) Ltd

Platinum Elite Contributor
Posts: 6,537
Country: USA

Re: Configuring the ACT! Premium web server for multiple databases

[ Edited ]

Hello Mike,

I am not aware of a whitepaper for this and there is not a KB article that encompasses all this. The Web Admin guide has all the information you need to install and configure the web client. Regarding the multiple databases, you could add all of those databases into a single virtual directory in IIS, so when users login via the web client they will see a list and can choose the database they want to login to. If you wanted to keep them separate, you would have to create custom virtual directory for each database. The downside of this is that each virtual directory runs a separate instance of the W3WP.exe (web publishing) service and running multiple directories sumultaneously can be a strain on the web server. If you need more information on creating custom virtual directories, please see this Knowledgebase article:

http://kb.Sagesoftwareonline.com/cgi-bin/Sagesoftwareonline.cfg/php/enduser/std_adp.php?p_faqid=1486...

 

Another option would be to use a single database, then use Limited Access rules to define which contacts each user can have access to. More information on contact access ruless are in this KB article:

http://kb.Sagesoftwareonline.com/cgi-bin/Sagesoftwareonline.cfg/php/enduser/std_adp.php?p_faqid=1522...

 

This article provides information on setting the default access level for new contacts created by the users:

http://kb.Sagesoftwareonline.com/cgi-bin/Sagesoftwareonline.cfg/php/enduser/std_adp.php?p_faqid=2701...

Greig Hollister

Note: Effective 6/1/13, Sage no longers provides support for the Act! software. This is now provided by Swiftpage.

Copper Contributor
Posts: 83
Country: NZ

Re: Configuring the ACT! Premium web server for multiple databases

Thanks for your help Greg.

Bronze Elite Contributor
Posts: 1,430
Country: United_Kingdom

Re: Configuring the ACT! Premium web server for multiple databases

Hi Greig

 

I am also trying to resolve this and some users do not like having to scroll through a list.  I do not want to go via the separate web address for load reasons as you outlined.

 

Is there a way of adding the database name to the URL so it automatically offers the correct database for user?

 

 

Platinum Elite Contributor
Posts: 6,537
Country: USA

Re: Configuring the ACT! Premium web server for multiple databases

Hello ch1p,
I don't believe there is a way to do this, since the database is not actually part of the URL. To do this you would need to create different virtual directories in IIS for each database or databases you want displayed. Then add then appropriate database(s) to each directory through the Web Site Administration tool in ACT!. You would then give the appropriate users a designated URL, like:
http://(web server address)/APFW
http://(web server address)/APFW2
http://(web server address)/APFW3
...etc

Greig Hollister

Note: Effective 6/1/13, Sage no longers provides support for the Act! software. This is now provided by Swiftpage.