x

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

to

32 bit SQL 2005 standard on the same machine

to

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, 2012 at 03:34 PM in Default

CodedSteve gravatar image

CodedSteve
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, 2012 at 05:46 PM

Grant Fritchey gravatar image

Grant Fritchey ♦♦
101k 19 21 74

also hardware limits IIRC, only use single CPU?
May 23, 2012 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

By RSS:

Answers

Answers and Comments

SQL Server Central

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

Topics:

x1950

asked: May 22, 2012 at 03:34 PM

Seen: 843 times

Last Updated: May 23, 2012 at 07:57 AM