+ 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
    895
    Thank Post
    206
    Thanked 343 Times in 238 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,687
    Thank Post
    352
    Thanked 794 Times in 714 Posts
    Rep Power
    346
    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,568 Times in 1,250 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,590
    Thank Post
    109
    Thanked 762 Times in 593 Posts
    Rep Power
    180
    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
    224
    Thank Post
    15
    Thanked 73 Times in 56 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,687
    Thank Post
    352
    Thanked 794 Times in 714 Posts
    Rep Power
    346
    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
    895
    Thank Post
    206
    Thanked 343 Times in 238 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,154
    Thank Post
    114
    Thanked 527 Times in 450 Posts
    Blog Entries
    2
    Rep Power
    123
    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
  •