Installing multiple versions of SQL Server Instances on same server

  • Has anyone successfully installed and maintained multiple versions of SQL Server instances on a single server?

    What disadvantages have you encountered maintaining multiple versions of SQL Server instances on a single server?

    Thanks.

  • smatu (8/17/2014)


    Has anyone successfully installed and maintained multiple versions of SQL Server instances on a single server?

    What disadvantages have you encountered maintaining multiple versions of SQL Server instances on a single server?

    Thanks.

    Hi smatu,

    We have installed multiple instances of different version, we do this to implement security between instances & different databases.

    Not so much errors come to place,some WMI errors come..

    for eg. when you will open SQL Server Configuration Manager, it will not show services, to solve the problem you have to install the sp2 or sp3 package of sql server (selection is based on already installed sql servers)

    Find some problem Click Here

    Vimal LohaniSQL DBA | MCP (70-461,70-462)==============================The greatest barrier to success is the fear of failure ** Success is a journey not a destination**Think before you print, SAVE TREES, Protect Mother Nature

  • Thank you Vimal.

  • Disregard question.

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply