On 5/1/01, Dennis Powers penned: >I have been trying to convince them to purchase an SQL server, but I don't >see that anytime soon. I was hoping to connect the CF Server to the Box >with the MSDE database, I just can't figure out how, or IF it can be done. >I guess I'll have to go there.
It should be relatively simple.
On the MSDE box: 1. Start Menu/Programs/Msde/Server Network Utility
2. Be sure TCP/IP is listed under Active server network library configurations. If not, click Add, choose TCP/IP, then click OK.
On the CF box: 1. Go info CF Administrator, Add Datasource using SQL Server driver, give the datasource a name, enter the IP Address of the MSDE box in the Server field, click CF Settings.
2. Now, this is where we may have problems. I believe WebBoard's database is installed under the sa SQL login. I installed WebBoard demo awhile back. I can't remember if I had to enter a password for the sa account or not when MSDE was installed. But anyway, if the sa account is set up with a blank password, then enter sa in the ColdFusion login field and leave the password field blank. If he remembers entering an sa password for MSDE when he installed WebBoard, then enter that. I believe the database is named WebBoardPrimary, which is what you'll enter in the Login:Database field. Do all that and see if it verifies. --
Bud Schneehagen - Tropical Web Creations
_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ ColdFusion Solutions / eCommerce Development buddy@twcreations.com http://www.twcreations.com/ 954.721.3452
CF-Talk
Bud