James Smith wrote: > One of our developers has MSDE installed on his machine as well as a > developer copy of CF. > > 1) His CF can connect happily to a remote MSSQL server. > 2) His Enterprise manager connects to his local MSDE. > 3) My Enterprise manager connects to his MSDE. > 4) His CF can't connect to his MSDE. > > I have tried unblocking ports, I have double checked his MSDE is still on > 1433, I have changed usernames and passwords, and I have run out of ideas.
1. Use SQL Server Express 2005 instead. It is so much better. 2. Does he have SQL Server authentication or Windows authentication? 3. What is the error? Jochem ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:256227 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
