SQL standard & express on same machine

Hi,

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.

Kind Regards

asked May 22 '12 at 03:34 PM in Default

CodedSteve
0 ● 1 ● 1

(comments are locked)

1 answer:

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