SQL Server question

Report · Apr 07, 2008

I have a question regarding the use of SQL Server instead of Access for your database in RH Server 7.
Is it possible to point multiple help systems (servers) to one SQL Server location? Our network admin is doing this currently, and I recently noticed that the 2 help systems that are out there are merging their reporting information. So if you log into either Web admin you see the same results and statistics each place. He says that you should be able to point the different servers to the same SQL Server without this happening, but he wants me to look into further. Any help would be greatly appreciated.

Report · Apr 09, 2008

I have been testing this for the past couple of days. Our doc group wants to keep the reporting stats for the different project separate. Here is a doc that discusses that: < http://blogs.adobe.com/techcomm/2007/07/configuring_adobe_robohelp_ser.html>

However, I have foudn the doc to be incomplete. I have two projects in two different servers (websites) pointing to the same db (SQL Server). But the reporting info is still getting mixed. So I think the key is in addition to the directions in the doc, to point the individual websites to separate dbs (can be on the same SQL Server).

I have not tested this yet, but it should work. Just not sure about the additional license issues that may have to be addressed.