• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1549
  • Last Modified:

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 ?
0
CaussyR
Asked:
CaussyR
1 Solution
 
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

Featured Post

 [eBook] Windows Nano Server

Download this FREE eBook and learn all you need to get started with Windows Nano Server, including deployment options, remote management
and troubleshooting tips and tricks

Tackle projects and never again get stuck behind a technical roadblock.
Join Now