SQL standard & express on same machine


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
more ▼

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

CodedSteve gravatar image

0 1 1 1

(comments are locked)
10|1200 characters needed characters left

1 answer: sort voted first
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.
more ▼

answered May 22 '12 at 05:46 PM

Grant Fritchey gravatar image

Grant Fritchey ♦♦
90.9k 19 21 74

also hardware limits IIRC, only use single CPU?
May 23 '12 at 07:57 AM Fatherjack ♦♦
(comments are locked)
10|1200 characters needed characters left
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

New code box

There's a new way to format code on the site - the red speech bubble logo will automatically format T-SQL for you. The original code box is still there for XML, etc. More details here.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here



Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.



asked: May 22 '12 at 03:34 PM

Seen: 733 times

Last Updated: May 23 '12 at 07:57 AM