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

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 ?
CaussyRAsked:
Who is Participating?
 
RiteshShahCommented:
are you sure, you have exactly followed all the steps given in

http://msdn.microsoft.com/en-us/library/ms177440.aspx

this might be useful too
http://forums.sqlwire.com/showthread.php?t=4278
0
 
Guy Hengel [angelIII / a3]Billing EngineerCommented:
>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?
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.