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
[EMAIL PROTECTED]
http://www.twcreations.com/
954.721.3452
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
