Make sure they run the SQL Server Configuration Manager and turn on the client protocols. My installation had all of them disabled by default, until I went in and manually enabled tcp/ip access.
On Jul 29, 2009, at 7:32 AM, Maureen Barger wrote: > > 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? I am > logging in with SQL user and its password. > > 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? > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:325071 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
