SQL server cluster install second instance 1433

Posted on 2012-09-13
Last Modified: 2012-09-20
Hi everyone, I have a install of microsoft cluster (win 2008) with two sql server instances.
The first instance works fine but the seccond instance do not listen on 1433 port.... I found a solution in the web..

1) Take the sqlserver service offline from cluster administrator

2)  Disable the checkpointing to the quorum using the following command

Cluster res “SQL Server (MSSQLSERVER2)” /removecheck: “Software\Microsoft\Microsoft SQL Server\MSSQL.2\MSSQLSERVER


When I run the command that error is displayed:

System error 5007 (0x0000138f).
Can not find the cluster resource

Any ideas?
Question by:LBDP
    LVL 44

    Expert Comment

    by:Vitor Montalvão
    Be careful, you can't have same port for different SQL Server instances.
    Use SQL Server Configuration Manager and check in SQL Server Network Configuration for the TCP/IP protocol. The last entry is the TCP Port and the number shows the port that instance is listening.

    Good luck

    Author Comment

    VMontalvao may be you do not understand, one instance is one application and the other is another application.... the ip address are not the same. Both instance can listen in 1433 port becouse they are listen in different ip address.

    LVL 44

    Expert Comment

    by:Vitor Montalvão
    If they are in windows cluster enviroment, they can't listen in same port, even with different VIP's. At least this is valid for SQL Server instances.
    LVL 28

    Accepted Solution

    For sure they can both listen on port 1433 on their own virtual IP addresses - I've been using that configuration for years. Here's how I accomplished it:

    Essentially, you modify the MSSQL TCP listener configuration to listen on port 1433 on its own IP address. That allows us to connect to the SQL Servers without specifying instance name, as it uses the default 1433 port.

    Slight caveat - some providers don't like this configuration and complain with an "Invalid Instance ()" error message. In those cases, you can connect to "SQLNETWORKNAME,1433" or you can still specify the instance name.

    Author Closing Comment


    Featured Post

    PRTG Network Monitor: Intuitive Network Monitoring

    Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

    Join & Write a Comment

    Everyone has problem when going to load data into Data warehouse (EDW). They all need to confirm that data quality is good but they don't no how to proceed. Microsoft has provided new task within SSIS 2008 called "Data Profiler Task". It solve th…
    OfficeMate Freezes on login or does not load after login credentials are input.
    This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function
    Via a live example, show how to shrink a transaction log file down to a reasonable size.

    745 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

    16 Experts available now in Live!

    Get 1:1 Help Now