+ 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
    912
    Thank Post
    207
    Thanked 346 Times in 239 Posts
    Rep Power
    93

    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,693
    Thank Post
    352
    Thanked 797 Times in 716 Posts
    Rep Power
    347
    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,262
    Thank Post
    242
    Thanked 1,572 Times in 1,252 Posts
    Rep Power
    340
    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
    London
    Posts
    7,592
    Thank Post
    109
    Thanked 769 Times in 598 Posts
    Rep Power
    181
    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
    227
    Thank Post
    16
    Thanked 75 Times in 57 Posts
    Rep Power
    25
    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,693
    Thank Post
    352
    Thanked 797 Times in 716 Posts
    Rep Power
    347
    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
    912
    Thank Post
    207
    Thanked 346 Times in 239 Posts
    Rep Power
    93
    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,157
    Thank Post
    116
    Thanked 529 Times in 452 Posts
    Blog Entries
    2
    Rep Power
    124
    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, 02:34 PM
  2. Replies: 5
    Last Post: 5th July 2007, 11:43 PM
  3. Windows Server 2003 File Server Resource Manager
    By mrforgetful in forum Windows
    Replies: 1
    Last Post: 17th June 2007, 01: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, 06: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, 10: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
  •