Skip to main content
November 25, 2008
Question

CF 8 instance

  • November 25, 2008
  • 11 replies
  • 1401 views
I am new at this and not sure if it is possible to achieve the following;
I have 2 websites accessing one MS SQL server, however each website access a different database within the SQL server.
- My action plan is to have 2 website in the IIS 6.0 (one webserver),
- in CF admin console I set the default for the 1st website - by pointing to 1 data source in my SQL server, let says > sales1
- create an instance and create a 2nd data source and point to AccoutRec in my SQL server.
So when I del/mod record in the sales1 database it will not affect the AccountRec database.

ANy suggestions would be much appreciated

DT
This topic has been closed for replies.

11 replies

Inspiring
November 25, 2008
You don't need a second CF instance. A single CF instance can serve CFM
pages for multiple websites, and provided each site uses a different
datasource (one can set up as many data sources as one wants within a
single CF instance), then you're all good.

--
Adam