Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Peter99
Constraint Violating Yak Guru
498 Posts |
 Posted - 2011-06-09 : 15:31:45
|
| Hi,I am installing default and named instances of sql server 2005 on windows 2003.I will set tcp/ip port 1433 for default and 1432 for named instance.When I open sql server configuration manager, clicked on tcp/ip protocole, ip addresses tab, there are some IP1, IP2, IPAll options. On IP1 and IP2 it display Active->yes, Enabled->yes, IP Address, TCP Port No. I want to know whether I should set No for enabled for IP1 and IP2. and set 1433 for named instance for tcp/ip port for all (IP1,IP2,IPAll)? If I leve IP1 and IP2 enabled what will happend?Secondly for standalone server what protocoles I should enabled? TCP/IP, Named Pipes, Shared Memory? This server will be accessed on network.Thanks |
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2011-06-09 : 15:45:01
|
| When you run the installation program, you won't have to touch configuration manager. |
 |
|
|
Peter99
Constraint Violating Yak Guru
498 Posts |
Posted - 2011-06-09 : 16:42:27
|
| I am talking about after installation. After installation I want to setup protocoles. |
|
|
|
Peter99
Constraint Violating Yak Guru
498 Posts |
Posted - 2011-06-10 : 12:53:11
|
| Tara, if you have time, please help. I just want to know on standalone server (access on network) IP1,IP2 should be enbaled or disabled?Thanks |
|
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2011-06-10 : 13:01:54
|
| As said earlier, you don't need to do anything.But, to answer "what will happen" nothing if you leave it alone.If you make the 127.0.0.1 inactive, LOCAL won't work. Any others you disable won't work.Why do want to change any of this?For most applications, you'll need TCP/IP enabled, named pipes and shared memory don't have to be. |
|
|
|
Peter99
Constraint Violating Yak Guru
498 Posts |
Posted - 2011-06-10 : 13:55:55
|
| Russell, Thanks for your help. |
|
|
|
|
|
|
|
|
IP Addresses (TCP/IP)