Using MS SQL Server on Snow Leopard Server with Coldfusion

I was wondering if it was possible or is there a way of using that all together on one mach开发者_运维百科ine without virtualization

I don't think so. The only option for running Windows apps directly would be something like Crossover but SQL Server is known not to work with Crossover (or WINE on Linux for that matter).

Unlike typical Windows apps, SQL Server is likely to be deeply integrated with the OS for operations like disk access, etc.

With enough memory, virtualisation is probably the best way to go - you should be able to access the 'remote' virtualised database easily enough.