Re: CF9 and MS SQL DSN Creation Errors
Yep, about a minute after I sent the email I found what I was needing. Here is a link to the site i found with step by step instructions. http://www.mattgifford.co.uk/local-sql-server-2008-coldfusion-datasource/ Now wonder what else i'll break along the way LOL Thanks for the insight though. From: Mark A. Kruger To: cf-talk Sent: Fri, March 19, 2010 11:44:51 AM Subject: RE: CF9 and MS SQL DSN Creation Errors It's called something else in 05/08 - surface area configuration or some :) Naturally they took something that was easy to understand and made it more difficult. Mark A. Kruger, MCSE, CFG (402) 408-3733 ext 105 www.cfwebtools.com www.coldfusionmuse.com www.necfug.com -Original Message- From: Roger Austin [mailto:raust...@nc.rr.com] Sent: Friday, March 19, 2010 12:40 PM To: cf-talk Subject: Re: CF9 and MS SQL DSN Creation Errors DURETTE, STEVEN J (ATTASIAIT) wrote: > MS SQL 2005 and 2008 deny ip Connections by default, you have to go into > the settings (don't remember how off the top of my head) and allow tcpip > connections. Don't you use the SQL Server Client Network Utility to do that? -- LinkedIn: http://www.linkedin.com/pub/8/a4/60 Twitter: http://twitter.com/RogerTheGeek MissHunt: http://www.misshunt.com/ (Home of the Clean/Dirty Magnet) NCDevCon: http://ncdevcon.com/ 2010 Raleigh ColdFusion Conference ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:331903 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: CF9 and MS SQL DSN Creation Errors
It's called something else in 05/08 - surface area configuration or some :) Naturally they took something that was easy to understand and made it more difficult. Mark A. Kruger, MCSE, CFG (402) 408-3733 ext 105 www.cfwebtools.com www.coldfusionmuse.com www.necfug.com -Original Message- From: Roger Austin [mailto:raust...@nc.rr.com] Sent: Friday, March 19, 2010 12:40 PM To: cf-talk Subject: Re: CF9 and MS SQL DSN Creation Errors DURETTE, STEVEN J (ATTASIAIT) wrote: > MS SQL 2005 and 2008 deny ip Connections by default, you have to go into > the settings (don't remember how off the top of my head) and allow tcpip > connections. Don't you use the SQL Server Client Network Utility to do that? -- LinkedIn: http://www.linkedin.com/pub/8/a4/60 Twitter: http://twitter.com/RogerTheGeek MissHunt: http://www.misshunt.com/ (Home of the Clean/Dirty Magnet) NCDevCon: http://ncdevcon.com/ 2010 Raleigh ColdFusion Conference ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:331901 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: CF9 and MS SQL DSN Creation Errors
That sounds right. -Original Message- From: Roger Austin [mailto:raust...@nc.rr.com] Sent: Friday, March 19, 2010 1:40 PM To: cf-talk Subject: Re: CF9 and MS SQL DSN Creation Errors DURETTE, STEVEN J (ATTASIAIT) wrote: > MS SQL 2005 and 2008 deny ip Connections by default, you have to go into > the settings (don't remember how off the top of my head) and allow tcpip > connections. Don't you use the SQL Server Client Network Utility to do that? -- LinkedIn: http://www.linkedin.com/pub/8/a4/60 Twitter: http://twitter.com/RogerTheGeek MissHunt: http://www.misshunt.com/ (Home of the Clean/Dirty Magnet) NCDevCon: http://ncdevcon.com/ 2010 Raleigh ColdFusion Conference ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:331900 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: CF9 and MS SQL DSN Creation Errors
DURETTE, STEVEN J (ATTASIAIT) wrote: > MS SQL 2005 and 2008 deny ip Connections by default, you have to go into > the settings (don't remember how off the top of my head) and allow tcpip > connections. Don't you use the SQL Server Client Network Utility to do that? -- LinkedIn: http://www.linkedin.com/pub/8/a4/60 Twitter: http://twitter.com/RogerTheGeek MissHunt: http://www.misshunt.com/ (Home of the Clean/Dirty Magnet) NCDevCon: http://ncdevcon.com/ 2010 Raleigh ColdFusion Conference ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:331899 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: CF9 and MS SQL DSN Creation Errors
MS SQL 2005 and 2008 deny ip Connections by default, you have to go into the settings (don't remember how off the top of my head) and allow tcpip connections. -Original Message- From: Christopher Stowell [mailto:christopher.stow...@yahoo.com] Sent: Friday, March 19, 2010 1:34 PM To: cf-talk Subject: CF9 and MS SQL DSN Creation Errors Ok.. I've installed CF9 64bit and MS SQL 8 on my local machine which is running Windows 7 Professional. The install for CF went fine and all 'initial' created DSN's that came with the install verified fine. I am able to load the SQL Manager and create databases/users with no problem. I created a DSN using the stand alone ODBC manager on the computer and tested connection and works fine. But the problem happens when I try creating a DSN within ColdFusion Administrator. I create a new DSN (different name then the one in the ODBC Manager), put in the database name, localhost for server (tried 127.0.0.1), and the username, in this case is sa. No password since its a stand alone dev machine. But I get the following error: Connection verification failed for data source: WebSite001DSN java.sql.SQLNonTransientConnectionException: [Macromedia][SQLServer JDBC Driver]Error establishing socket to host and port: localhost:1433. Reason: Connection refused: connect The root cause was that: java.sql.SQLNonTransientConnectionException: [Macromedia][SQLServer JDBC Driver]Error establishing socket to host and port: localhost:1433. Reason: Connection refused: connect I tried creating a ODBC Socket connection within COldFusion Administrator but tells me the ODBC Service is not running and when try starting the agent and server both, they both start but shut back down isntantly. Does anyone have any ideas? I did disable my firewall on that machine but it did not help. ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:331898 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
CF9 and MS SQL DSN Creation Errors
Ok.. I've installed CF9 64bit and MS SQL 8 on my local machine which is running Windows 7 Professional. The install for CF went fine and all 'initial' created DSN's that came with the install verified fine. I am able to load the SQL Manager and create databases/users with no problem. I created a DSN using the stand alone ODBC manager on the computer and tested connection and works fine. But the problem happens when I try creating a DSN within ColdFusion Administrator. I create a new DSN (different name then the one in the ODBC Manager), put in the database name, localhost for server (tried 127.0.0.1), and the username, in this case is sa. No password since its a stand alone dev machine. But I get the following error: Connection verification failed for data source: WebSite001DSN java.sql.SQLNonTransientConnectionException: [Macromedia][SQLServer JDBC Driver]Error establishing socket to host and port: localhost:1433. Reason: Connection refused: connect The root cause was that: java.sql.SQLNonTransientConnectionException: [Macromedia][SQLServer JDBC Driver]Error establishing socket to host and port: localhost:1433. Reason: Connection refused: connect I tried creating a ODBC Socket connection within COldFusion Administrator but tells me the ODBC Service is not running and when try starting the agent and server both, they both start but shut back down isntantly. Does anyone have any ideas? I did disable my firewall on that machine but it did not help. ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:331897 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
