1

I have an application running on SQL Express SQL 9.0. Are there any known problems installing a Development Edition of MS SQL Server 2008 R2 along side SQL Express? In other words, is there a known problem having two different flavors of SQL Server installed? Is the Development edition treated like a second instance?

I know you can have multiple instances of SQL Server, with only one instance allowed as the unnamed or default instance. I'm just curious if anyone knows of a gotcha.

Thanks.

Improve this question
5
  • Point taken. I edited the question's title and body to reflect what I'm trying to do.
    – octopusgrabbus
    Aug 28, 2012 at 19:30
  • There could be issues with the ports that the two SQLs would use
    – Jake Andrew
    Aug 28, 2012 at 19:34
  • This may help: dev.mysql.com/doc/refman/5.1/en/multiple-servers.html
    – Jake Andrew
    Aug 28, 2012 at 19:35
  • 2
    @JakeElsley I somehow doubt a doc on MySQL will be of much use to someone with MSSQL server, actually.
    – HopelessN00b
    Aug 28, 2012 at 19:38
  • Sorry I seem to have mis-read the version
    – Jake Andrew
    Aug 28, 2012 at 21:31

1 Answer 1

Reset to default
2

Aside from the normal cautions and warnings about a side-by-side SQL installation, there are no "known issues" as a result of doing a side-by-side installation between SQL Express 9 and SQL Server 2008 R2.

This guy's done it without issue, as have I, though with different versions. Pretty sure it was SQL Express 2005 and SQL 2008 (100)/R1 in my case.

EDIT:

Since you've updated the question, I'll do the same... the Developer Edition will be treated exactly like a second instance (because that's what it is), and the general use-case of a side-by-side MSSQL installation is to have different versions of MSSQL. Because, for example, in my case, our #$^@ing employee time-keeping software is shackled to MSSQL 2000, while the rest of the world has moved on, and requires a higher version of MSSQL. So one of our [production] SQL servers has MSSQL 2000 and MSSQL 2008 on it in a side-by-side installation.

Improve this answer
2
  • Thanks. I'm trying not to screw up a production environment running Wasp Barcode Inventory Control. Since it's a public works server and we're short of SQL server space, I've got a license that will cover two people.
    – octopusgrabbus
    Aug 28, 2012 at 19:46
  • Just another point but remember the developer edition is not licensed for production use (last time I checked). SQL Express however is.
    – Brent Pabst
    Aug 28, 2012 at 19:49

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .