I am creating a process where I need to use an SQL2005 database - however I am not quite sure how to setup the datasource ( I still need to use the MySQL DB for the main datasource). How can I achieve this (where should I look for documentation - and if there are pitfalls could you point some of them out)?
I found out what was wrong - you need to disable the "dynamic" ports on your SQLEXPRESS server. This is done under SQL Server Configurtion Manager -> SQL Server 2005 Network Configuration -> Protocols for SQLEXPRESS -> TCP/IP (must be enabled) -> Properties -> IP Addresses -> TCP Dynamic Ports (remove the value that is there and add 1433 as the "TCP Port".