How do I configure in SQL 2008 TCP/IP settings ?

Posted on 2009-04-20
Last Modified: 2012-05-06
I have 2 instances on a SQL 2008 database rinnung on an IBM server with 34Gb of RAM and 24 core processors.

When I configure Connection Manager to port 1433, this will stop one instance and run the other.  I also tried the following:

1.) Firewall: open tcp 1433 in/out
2.) Activate SQL-Server authentication mode
3.) enable remote connections
4.) HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL10.(InstanceName)\MSSQLServer\SuperSocketNetLib\Tcp','TcpPort' ,PortNum
5.) Activate tcp in sql server configuration manager
6.) Enable and Activate TCP + Dynamic Ports = 0 (off), Port 1433
7.) IPALL Port 1433

How you can test it:
netstat -a must show a listening task at 1433

But SQL still using Named Pipes, which is slower than TCP/IP.

Can any let me know how to configure TCP/IP withoughout stopping any other instances ?
Question by:CaussyR
    LVL 31

    Accepted Solution

    are you sure, you have exactly followed all the steps given in

    this might be useful too
    LVL 142

    Expert Comment

    by:Guy Hengel [angelIII / a3]
    >5.) Activate tcp in sql server configuration manager
    did you also then deactivate named pipes?
    or did you at least change the order of priority on the client?

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Highfive Gives IT Their Time Back

    Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

    I annotated my article on ransomware somewhat extensively, but I keep adding new references and wanted to put a link to the reference library.  Despite all the reference tools I have on hand, it was not easy to find a way to do this easily. I finall…
    The Delta outage: 650 cancelled flights, more than 1200 delayed flights, thousands of frustrated customers, tens of millions of dollars in damages – plus untold reputational damage to one of the world’s most trusted airlines. All due to a catastroph…
    Video by: Steve
    Using examples as well as descriptions, step through each of the common simple join types, explaining differences in syntax, differences in expected outputs and showing how the queries run along with the actual outputs based upon a simple set of dem…
    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

    759 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

    11 Experts available now in Live!

    Get 1:1 Help Now