+ Post New Thread
Results 1 to 8 of 8
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 ...
  1. #1
    Gibbo's Avatar
    Join Date
    Feb 2008
    Location
    Cheshire
    Posts
    936
    Thank Post
    212
    Thanked 351 Times in 242 Posts
    Rep Power
    94

    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?

  2. #2


    Join Date
    Feb 2007
    Location
    Northamptonshire
    Posts
    4,706
    Thank Post
    354
    Thanked 807 Times in 722 Posts
    Rep Power
    348
    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

  3. #3

    Michael's Avatar
    Join Date
    Dec 2005
    Location
    Birmingham
    Posts
    9,331
    Thank Post
    242
    Thanked 1,601 Times in 1,277 Posts
    Rep Power
    346
    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.

  4. #4

    Ric_'s Avatar
    Join Date
    Jun 2005
    Location
    Boston, MA
    Posts
    7,601
    Thank Post
    110
    Thanked 771 Times in 599 Posts
    Rep Power
    183
    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.

  5. #5

    rob_f's Avatar
    Join Date
    May 2008
    Location
    Leeds
    Posts
    232
    Thank Post
    16
    Thanked 76 Times in 58 Posts
    Rep Power
    26
    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.

  6. #6


    Join Date
    Feb 2007
    Location
    Northamptonshire
    Posts
    4,706
    Thank Post
    354
    Thanked 807 Times in 722 Posts
    Rep Power
    348
    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.

  7. #7
    Gibbo's Avatar
    Join Date
    Feb 2008
    Location
    Cheshire
    Posts
    936
    Thank Post
    212
    Thanked 351 Times in 242 Posts
    Rep Power
    94
    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.

  8. #8

    Join Date
    Aug 2005
    Location
    London
    Posts
    3,159
    Thank Post
    116
    Thanked 529 Times in 452 Posts
    Blog Entries
    2
    Rep Power
    125
    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



SHARE:
+ Post New Thread

Similar Threads

  1. Replies: 8
    Last Post: 18th July 2008, 03:34 PM
  2. Replies: 5
    Last Post: 6th July 2007, 12:43 AM
  3. Windows Server 2003 File Server Resource Manager
    By mrforgetful in forum Windows
    Replies: 1
    Last Post: 17th June 2007, 02:51 PM
  4. Virtual Server 2005 R2 kills server network connection
    By ajbritton in forum Thin Client and Virtual Machines
    Replies: 0
    Last Post: 31st August 2006, 07:19 AM
  5. Downsides to passing tftp server via 2003 DHCP server?
    By pete in forum Wireless Networks
    Replies: 7
    Last Post: 11th July 2006, 11:07 PM

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •