Installing multiple instances of SQL Server - Do I need to specify a different port?

Posted on 2008-11-13
Last Modified: 2012-05-05
As part of a SharePoint installation I am going to install a second instance of SQL Server (i.e. one server running 2 instances of SQL Server).

Do I have to do anything special other than specifying the name of the instance?

What about ports? Can both instances share the same port?
Question by:dmoss123
    LVL 14

    Accepted Solution

    First off, step back and ask yourself "why am I doing this".  A single SQL instance can easily take care of multiple databases and seperate associated security for each.  So you may be creating additional complexity where it does not need to exist.

    For the specific answer to your question, no.  Just set the named instance.

    Here is a link that discusses the process of named SQL instanaces a bit further.

    Author Closing Comment

    Sorry, you posted your comments while I was awarding points(i have no more points to give).

    Our reasoning is that we do not want to put the SharePoint databases on the same SQL Server instance that runs all of our other databases. However, the box it is running on is set up to use SANs. Our network admin said that setting up another server to use SAN's would be expensive and require fiber optic cabling.

    Anyway, we got it set up as a named instance and afterthing is good. Thanks for replying.

    Featured Post

    Find Ransomware Secrets With All-Source Analysis

    Ransomware has become a major concern for organizations; its prevalence has grown due to past successes achieved by threat actors. While each ransomware variant is different, we’ve seen some common tactics and trends used among the authors of the malware.

    Join & Write a Comment

    Foreword In the years since this article was written, numerous hacking attacks have targeted password-protected web sites.  The storage of client passwords has become a subject of much discussion, some of it useful and some of it misguided.  Of cou…
    As a database administrator, you may need to audit your table(s) to determine whether the data types are optimal for your real-world data needs.  This Article is intended to be a resource for such a task. Preface The other day, I was involved …
    Illustrator's Shape Builder tool will let you combine shapes visually and interactively. This video shows the Mac version, but the tool works the same way in Windows. To follow along with this video, you can draw your own shapes or download the file…
    This demo shows you how to set up the containerized NetScaler CPX with NetScaler Management and Analytics System in a non-routable Mesos/Marathon environment for use with Micro-Services applications.

    755 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    18 Experts available now in Live!

    Get 1:1 Help Now