Two SQLs on one server?
I have a server running nothing more than Veritas 11 that I'm thinking of adding some web services too for an Intranet.
I was going to install WAMPSERVER 2.0, but the server already has Microsoft SQL Server 2005 on (for Veritas).
Will the two sit side by side ok or should I reconsider?
It should be intelligent enough to add another instance on the existing SQL Server rather than install another copy.
Take a good back up / image before you try :)
I agree with kmount, create a second database within SQL 2005. It's the easiest option.
However it is also possible for SQL 2000, SQL 2005 and of course MySQL to live on the same server.
MS SQL is happy (and designed) to have have multiple instances/installs on the one box. Of course you are adding MySQL which is a totally different beast. IIRC though, the two use different ports so it should be fine.
MSSQL and MySQL will cohabit nicely. And you can quite happily have multiple MSSQL instances, which is fairly flawless unless you get an annoying bit of software which will *only* install to the default instance... of which I have come across a few. Grr.
Think it should be noted that Installatiop & Instances are different things.
MySQL listens on TCP 3306 by default whereas MSSQL is 1433.
Useful link here showing default ports for many services or for the nix of you /etc/services holds a list.
Great stuff, thanks for the replies guys.
I'd do without the MYSQL part, but I need it to run ClassRoom Booking System which I intend to deploy onto that server.
One thing to watch out for is memory allocation - I think MS SQL defaults to using all available RAM which makes it work quickly but can mess up anything else which needs RAM ...
You can configure this so that it uses no more than (say) 1Gb