Windows Thread, Two SQLs on one server? in Technical; I have a server running nothing more than Veritas 11 that I'm thinking of adding some web services too for ...
17th July 2008, 09:59 AM #1
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?
IDG Tech News
17th July 2008, 10:02 AM #2
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
17th July 2008, 10:06 AM #3
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.
17th July 2008, 10:08 AM #4
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.
17th July 2008, 10:16 AM #5
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.
17th July 2008, 10:23 AM #6
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.
17th July 2008, 10:26 AM #7
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.
17th July 2008, 12:54 PM #8
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
By cuke2u in forum MIS Systems
Last Post: 18th July 2008, 03:34 PM
By Zoom7000 in forum Windows
Last Post: 6th July 2007, 12:43 AM
By mrforgetful in forum Windows
Last Post: 17th June 2007, 02:51 PM
By ajbritton in forum Thin Client and Virtual Machines
Last Post: 31st August 2006, 07:19 AM
By pete in forum Wireless Networks
Last Post: 11th July 2006, 11:07 PM
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)