RE: Unable to create Datasource ColdFusion8
What are you using in the datasource settings in CF? Adrian -Original Message- From: Priya Koya [mailto:priya23...@gmail.com] Sent: 14 February 2009 10:28 To: cf-talk Subject: Unable to create Datasource ColdFusion8 Hi All, I am using Wista Home edition. I installed ColdFusion8, SQL Server 2005 Express Edition in my PC. I set Protocols enabled in SQL Server 2005 but still I am unable to create a datasource. Can anyone help me with this? Thanks, Priya ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:319307 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Unable to create Datasource ColdFusion8
http://www.google.com/search?q=coldfusion+sql+server+expressie=utf-8oe=utf-8aq=trls=com.ubuntu:en-US:unofficialclient=firefox-a Mark On Sat, Feb 14, 2009 at 9:28 PM, Priya Koya priya23...@gmail.com wrote: Hi All, I am using Wista Home edition. I installed ColdFusion8, SQL Server 2005 Express Edition in my PC. I set Protocols enabled in SQL Server 2005 but still I am unable to create a datasource. Can anyone help me with this? Thanks, Priya ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:319308 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Unable to create Datasource ColdFusion8
I am using SQL SERVER 2005 to create a datasource. On Sat, Feb 14, 2009 at 6:01 AM, Adrian Lynch cont...@adrianlynch.co.ukwrote: What are you using in the datasource settings in CF? Adrian -Original Message- From: Priya Koya [mailto:priya23...@gmail.com] Sent: 14 February 2009 10:28 To: cf-talk Subject: Unable to create Datasource ColdFusion8 Hi All, I am using Wista Home edition. I installed ColdFusion8, SQL Server 2005 Express Edition in my PC. I set Protocols enabled in SQL Server 2005 but still I am unable to create a datasource. Can anyone help me with this? Thanks, Priya ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:319310 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Unable to create Datasource ColdFusion8
This is what the error I get when I try to create DataSource... Connection verification failed for data source: Banking java.sql.SQLException: [Macromedia][SQLServer JDBC Driver][Macromedia][SQLServer JDBC Driver]The requested instance is either invalid or not running. The root cause was that: java.sql.SQLException: [Macromedia][SQLServer JDBC Driver][Macromedia][SQLServer JDBC Driver]The requested instance is either invalid or not running. On Sat, Feb 14, 2009 at 6:01 AM, Adrian Lynch cont...@adrianlynch.co.ukwrote: What are you using in the datasource settings in CF? Adrian -Original Message- From: Priya Koya [mailto:priya23...@gmail.com] Sent: 14 February 2009 10:28 To: cf-talk Subject: Unable to create Datasource ColdFusion8 Hi All, I am using Wista Home edition. I installed ColdFusion8, SQL Server 2005 Express Edition in my PC. I set Protocols enabled in SQL Server 2005 but still I am unable to create a datasource. Can anyone help me with this? Thanks, Priya ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:319312 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Unable to create Datasource ColdFusion8
By default the SQL Server Express port is dynamic, meaning i changes. You need to use the SQL Server configuration tool to set a static port and use the port number, generally 1433, in the DSN admin interface. Have you done this? TJ Downes ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:319313 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Unable to create Datasource ColdFusion8
Did you read any of the Google results that Mark pointed you towards? Chances are since you are using SQL Server Express, you are trying to connect on the wrong port or SQL Server is not configured for TCP connections at all. You can use netstat -a on your machine to verify what ports are being listened on. But firstly, read a few of the many blog entries out there on the topic. http://www.fusioncube.net/index.php/coldfusion-sql-server-express ~Brad - Original Message - From: Priya Koya priya23...@gmail.com To: cf-talk cf-talk@houseoffusion.com Sent: Saturday, February 14, 2009 12:47 PM Subject: Re: Unable to create Datasource ColdFusion8 This is what the error I get when I try to create DataSource... Connection verification failed for data source: Banking java.sql.SQLException: [Macromedia][SQLServer JDBC Driver][Macromedia][SQLServer JDBC Driver]The requested instance is either invalid or not running. The root cause was that: java.sql.SQLException: [Macromedia][SQLServer JDBC Driver][Macromedia][SQLServer JDBC Driver]The requested instance is either invalid or not running. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:319314 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Unable to create Datasource ColdFusion8
Yes, I did.. Set tje port 1433..i tested with telnet localhost 1433 .. its connectivity is working fine On Sat, Feb 14, 2009 at 1:51 PM, TJ Downes koldfu...@gmail.com wrote: By default the SQL Server Express port is dynamic, meaning i changes. You need to use the SQL Server configuration tool to set a static port and use the port number, generally 1433, in the DSN admin interface. Have you done this? TJ Downes ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:319315 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Unable to create Datasource ColdFusion8
Here's what comes to mind for me Did you test it by telneting from the web server? I also leave TCP/IP and shared enabled, but disable named pipes and any other network libraries (using the sql config tool). Also make sure that you create a user name for CF using standard security (not AD security) and make sure that when you create it you set it so that the password does not need to be changed on first usage. -Mark Mark A. Kruger, CFG, MCSE (402) 408-3733 ext 105 www.cfwebtools.com www.coldfusionmuse.com www.necfug.com -Original Message- From: Priya Koya [mailto:priya23...@gmail.com] Sent: Saturday, February 14, 2009 1:08 PM To: cf-talk Subject: Re: Unable to create Datasource ColdFusion8 Yes, I did.. Set tje port 1433..i tested with telnet localhost 1433 .. its connectivity is working fine On Sat, Feb 14, 2009 at 1:51 PM, TJ Downes koldfu...@gmail.com wrote: By default the SQL Server Express port is dynamic, meaning i changes. You need to use the SQL Server configuration tool to set a static port and use the port number, generally 1433, in the DSN admin interface. Have you done this? TJ Downes ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:319316 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Unable to create Datasource ColdFusion8
Brad, I followed the link and now I am unable to restart service and error I get is sql server(SQLEXPRESS) service on Local Computer started and then stopped. SOme services stop automatically if they are not in use by other services or programs.http://www.uscis.gov/portal/site/uscis/menuitem.5af9bb95919f35e66f614176543f6d1a/?vgnextoid=da75d676b6b6f110VgnVCM104718190aRCRDvgnextchannel=68439c7755cb9010VgnVCM1045f3d6a1RCRD On Sat, Feb 14, 2009 at 2:00 PM, Brad Wood b...@bradwood.com wrote: Did you read any of the Google results that Mark pointed you towards? Chances are since you are using SQL Server Express, you are trying to connect on the wrong port or SQL Server is not configured for TCP connections at all. You can use netstat -a on your machine to verify what ports are being listened on. But firstly, read a few of the many blog entries out there on the topic. http://www.fusioncube.net/index.php/coldfusion-sql-server-express ~Brad - Original Message - From: Priya Koya priya23...@gmail.com To: cf-talk cf-talk@houseoffusion.com Sent: Saturday, February 14, 2009 12:47 PM Subject: Re: Unable to create Datasource ColdFusion8 This is what the error I get when I try to create DataSource... Connection verification failed for data source: Banking java.sql.SQLException: [Macromedia][SQLServer JDBC Driver][Macromedia][SQLServer JDBC Driver]The requested instance is either invalid or not running. The root cause was that: java.sql.SQLException: [Macromedia][SQLServer JDBC Driver][Macromedia][SQLServer JDBC Driver]The requested instance is either invalid or not running. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:319317 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Unable to create Datasource ColdFusion8
Wow, we've really made it angry now, huh? I've got to say I didn't have this much trouble, so I don't know how much help I can offer at this point. If I were you, I would start by looking in your windows system and application logs for clues. Also see if you have this log file: C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\LOG\ERRORLOG I have SQL Server 2005 express installed on my machine, and that appears to be the location of the log file. Something must be preventing the service from starting properly so I'm guessing you will need to find the real error message and make a trip to Google with it. As for the 11 Arrested, Indicted in Multi-State Operation Targeting Visa and Mail Fraud-- that really too bad for them. I don't suppose they would have been much help to your SQL server set up anyway. :) ~Brad - Original Message - From: Priya Koya priya23...@gmail.com To: cf-talk cf-talk@houseoffusion.com Sent: Saturday, February 14, 2009 2:03 PM Subject: Re: Unable to create Datasource ColdFusion8 Brad, I followed the link and now I am unable to restart service and error I get is sql server(SQLEXPRESS) service on Local Computer started and then stopped. SOme services stop automatically if they are not in use by other services or programs.http://www.uscis.gov/portal/site/uscis/menuitem.5af9bb95919f35e66f614176543f6d1a/?vgnextoid=da75d676b6b6f110VgnVCM104718190aRCRDvgnextchannel=68439c7755cb9010VgnVCM1045f3d6a1RCRD ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:319318 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
