Thanks much Bruce, Brian, Charlie, After some tweaking w/everyone's suggestions, I now get this error:
Connection verification failed for data source: pc_inventory java.sql.SQLException: [Macromedia][SQLServer JDBC Driver][SQLServer]Login failed for user 'administrators'. The root cause was that: java.sql.SQLException: [Macromedia][SQLServer JDBC Driver][SQLServer]Login failed for user 'administrators'. I checked all settings and user id/pswds. Going through Windows Authentication is OK via SQL. The port is 1433 and I tried the port I found in SQL Express. I'm running CF and SQL Express on the same box w/Windows 2003 Server. Anything I'm missing? RO -----Original Message----- From: Brian Kotek [mailto:[EMAIL PROTECTED] Sent: Monday, August 13, 2007 2:55 PM To: CF-Talk Subject: Re: SOT: SQL Express Setting up a SQL Express database should be the same as connecting to any other SQL Server. If it is local and on windows, make sure the Windows firewall is set to exclude the SQL Server executables. On 8/13/07, Orlini, Robert <[EMAIL PROTECTED]> wrote: > > I have SQL Express installed and am having connection problesm when > verifying the datasource. The CF erro is "...failed for datasource...error > extablishing socket..." I found a KB (#400255) on Adobe 's site and went > through the steps, but have some questions. > > It reads to note the TCP port. Is that 1433? Also, it reads to "Configure > a SQL Server JDBC data source in the CF Admin to isten to the port number". > How is that done? > > Any help appreciated. > > Thanks. > > RO > HWW > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Get the answers you are looking for on the ColdFusion Labs Forum direct from active programmers and developers. http://www.adobe.com/cfusion/webforums/forum/categories.cfm?forumid-72&catid=648 Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:286125 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4