Dave, For someone with your length of development you really have surprised me on this issue.
First of all, if you install SQL2005 on a workstation it will default to a desktop version or a named instance of a database, however you can have multiple databases in that named instance. Second of all, yes for every named instance you do need to have a different port. Now Kurt this may answer your question. You need to download the SQL2005 JDBC drivers from MS if you haven't done so already, you then make the connection in the same manner you would any JDBC driver connection even mySQL. Now comes the catch, you need to go back to SQL2005 and open the TCP/IP ports because by default these are disabled and you will not be able to get coldfusion to connect to until you do this. SQL Express doesn't run on port 1433. On my machine it runs on port 1771. I didn't do anything special during the installation (meaning I just accepted all the defaults) so I'm not sure if 1771 is the default port for SQL 2005 now or if for some reason on my setup it just chose this port. The port is obviously crucial when you're setting up your datasources for CF. To check your port after installation, go to the SQL Server Configuration Manager (the same one you went to above to enable TCP/IP connectivity), go to Network Configuration/Protocols again, right click on TCP/IP, choose Properties, then click on the IP Addresses tab. Under IPAll in the TCP Dynamic Ports section, in my install this was automatically set to port 1771. Senior Coldfusion Developer Aegeon Pty. Ltd. www.aegeon.com.au Phone: +613 8676 4223 Mobile: 0404 998 273 -----Original Message----- From: Dave Watts [mailto:[EMAIL PROTECTED] Sent: Tuesday, 10 October 2006 12:38 PM To: CF-Talk Subject: RE: CF, jdbc, SQL2k5 problem > > You can't connect using an instance name. You will need to > > use the IP socket corresponding to the instance. > > I'm not so sure about that. I believe i used an instance name > at a client and it worked see: > http://www.adobe.com/cfusion/knowledgebase/index.cfm?id=tn_18294 > but can't get it to work here You might want to read that technote more carefully. It says you have to use a unique port, which is what I said as well. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber vendor-authorized instruction at our training centers in Washington DC, Atlanta, Chicago, Baltimore, Northern Virginia, or on-site at your location. Visit http://training.figleaf.com/ for more information! ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:256058 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
