What port is SQL Server 2005 listening on? Also, can you connect using the same password in Enterprise Manager?
Run a trace on the 2005 database and include failed login events from the audit group. Can you see the login failures coming through. If not, CF isn't hitting the correct SQL instance. ~Brad ----- Original Message ----- From: "Stan Winchester" <[email protected]> To: "cf-talk" <[email protected]> Sent: Tuesday, February 17, 2009 9:38 PM Subject: SQL Server 2005 Datasource failing > > On my local network I've been using SQL Server 2000 and connecting to it > with BD7 & CF8 with no problems. I also have SQL Server 2005 on it and am > having trouble creating a datasource that logins. It seems to see SQL > Server 2005, but I am getting the following error: > > Connection verification failed for data source: [my datasource] > java.sql.SQLException: [Macromedia][SQLServer JDBC > Driver][SQLServer]Cannot open database "[my datasource]" requested by the > login. The login failed. > The root cause was that: java.sql.SQLException: [Macromedia][SQLServer > JDBC Driver][SQLServer]Cannot open database "[my datasource]" requested by > the login. The login failed. > > With SQL Server 2000 I just connected using the [server name] over port > 1433 with no problems. SQL Server 2005 is on the box so the server is > called "[server name]\sqlserver2005" as shown in the connections > properties in MS SQL Server Management Studio, with the instance name > "sqlserver2005". > > I have checked and re-checked the user name / password and they are the > same in CF8 & the SQL Server 2005 database. > > Any ideas what I am missing? > > Thanks, Stan ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:319457 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
