CFM DataSource won`t accept MS SQL Server 2000
If you just did a fresh install of Adobe ColdFusion 8 and Microsoft SQL Server 2000 and you tried to add a datasource but all you get is error. Its all because of the default MS SQL Server 2000 port which is 1433 is not a secure port in Windows XP.
To solve this problem you need to install the MS SQL Server 2000 SP4. This update will let Windows XP recognize the port 1433 as a secure port and will now let you connect your CFM datasource with MS SQL Server 2000.