I'm trying to get round a problem that I have where I am unable to create a linked server from a 64 bit SQL 2005 standard machine to a Sybase 11.9.2 database.
The solution that I have been given is to install a 32 bit version of SQL 2005 on the 64 bit box and create a link server from
64 bit SQL 2005 standard
32 bit SQL 2005 standard on the same machine
Sybase Sybase 11.9.2
My question is can we use SQL 2005 express instead of the 32 bit SQL 2005 standard to create the link server.
Is there any licensing / compatibility / best practice issues that I need to be aware of.
asked May 22 '12 at 03:34 PM in Default
I have had multiple versions of SQL Express running side-by-side with multiple versions of SQL Server with zero issues. Mind you, this was not in a production environment. However, from a strict technical stand point, this should work just fine. Just remember that there are data & connection limits on Express.
answered May 22 '12 at 05:46 PM
Grant Fritchey ♦♦