Skip to main content
M
MoBarger
Participant
July 29, 2009
Question

CFMXE 7.x and SQL Server 2008

  • July 29, 2009
  • 1 reply
  • 823 views

Hello - a client recently upgraded to SQL Server 2008 and we can no longer connect from CFMXE 7.x.

I have asked them to go through the steps outlined here <http://blog.mxunit.org/2009/02/connecting-sql-server-2008-to.html> but errors persist. The DSN is defined using the standard SQL Server driver - is there an updated one that is required for 2008?

The error I have now is Cannot open database "database" requested by the login. The login failed.

Caveats - I have no access to the database server.

Suggestions?

This topic has been closed for replies.

1 reply

A
Anonymous
August 6, 2009

I know we have a couple of CF 7 servers that are connecting using the built in sql drivers to sql 2008 without issue, so out of the box it should work.

I would suggest seeing if dynamic ports are enabled on the sql server, which would maybe cause a problem if there is a firewall involved and perhaps with the CF drivers.

To ensure you stay on port 1433, I think in CF 7 you can specify additional connection params in the DSN under the advanced dialog.  I don't have a machine in front of me. I'd have to try it out.

Alternatelly you could try the "other" driver for the DSN, and use a JDBC connection string to connect and specify the port.  If you need a better example, email me and I'll send over an example. 

Our 2005 - 2008 Sql upgrades have been very smooth with regards to the DSN, and we didn't have to update anything aside from the server ip, so it should work.

Byron Mann

mannb@hostmysite.com

byronosity@gmail.com

Software Architect

hosting.com | hostmysite.com

http://www.hostmysite.com/?utm_source=bb

Terms & ConditionsAccessibility statement
Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices