<cfwhat>

Sunday, March 25, 2007

ColdFusion and MSDE 2000 on XP with SP2

I set up a new PC for development at home this weekend and I ran into a (common) problem trying to get ColdFusion to work with MS SQL Server 2000 (MSDE) on XP with SP2. It took me ages but eventually I got it working. The solution was to uninstall the copy of MSDE that I originally put on and do a fresh install using SQL Server SP4 for MSDE. The setup required some parameters, eg.:
setup.exe SAPWD="your_sa_password" DISABLENETWORKPROTOCOLS=0 /L*v C:\MSDELog.log

If you can't get that to run at the command line (I couldn't) then set up a shortcut to setup.exe and put it in the target field.

1 Comments:

Post a Comment

<< Home