I am using SQL Server 6.5. By default TCP/IP protocol is not enabled (1433 port is not opened by the server). How can I enable this so that I can use a JDBC driver to connect to it.
In SQL Server 2000, the "SQL Server Network Utility" helps us to enable the TCP/IP protocol. But not able to figure our how/where this can be done in 6.5.
Thanks for any helpGoto start --> programs --> MSSQL SErver 6.5 --> SQL Setup and from there you can add the network library for TCP/IP and then after you must restart SQL services to take affect of new settings.
Showing posts with label tcp. Show all posts
Showing posts with label tcp. Show all posts
Wednesday, March 7, 2012
Friday, February 24, 2012
Enable tcp/ip protocol via registry
Well, I need to enable the tcp/ip protocol via registry,
so I added the following value inside the registry
[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsof t SQL
Server\GESTP\MSSQLServer\SuperSocketNetLib\Tcp]
"TcpHideFlag"=dword:00000000
"TcpDynamicPorts"="0"
"TcpPort"="1433"
But if I call the svrnetcn tool tcp/ip isn't listed as enable protocol.
Why?
Andrea Moro
I forgot to say ... I want to enable the tcp/ip protcol
for a named instance.
I suspect that sql tool do more thing that alter the
registry keys I specified.
Andrea
|||hi Andrea,
"Andrea Moro" <moroandreaet@.ettiscali.it> ha scritto nel messaggio
news:%23dg$jOX2EHA.2180@.TK2MSFTNGP10.phx.gbl
> Well, I need to enable the tcp/ip protocol via registry,
> so I added the following value inside the registry
> [HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsof t SQL
> Server\GESTP\MSSQLServer\SuperSocketNetLib\Tcp]
> "TcpHideFlag"=dword:00000000
> "TcpDynamicPorts"="0"
> "TcpPort"="1433"
> But if I call the svrnetcn tool tcp/ip isn't listed as enable
> protocol.
> Why?
you have to check
HKLM\SOFTWARE\Microsoft\Microsoft SQL
Server\InstanceName\MSSQLServer\SuperSocketNetLib
\ProtocolList
key, that must include the "tcp" value
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.9.1 - DbaMgr ver 0.55.1
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
so I added the following value inside the registry
[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsof t SQL
Server\GESTP\MSSQLServer\SuperSocketNetLib\Tcp]
"TcpHideFlag"=dword:00000000
"TcpDynamicPorts"="0"
"TcpPort"="1433"
But if I call the svrnetcn tool tcp/ip isn't listed as enable protocol.
Why?
Andrea Moro
I forgot to say ... I want to enable the tcp/ip protcol
for a named instance.
I suspect that sql tool do more thing that alter the
registry keys I specified.
Andrea
|||hi Andrea,
"Andrea Moro" <moroandreaet@.ettiscali.it> ha scritto nel messaggio
news:%23dg$jOX2EHA.2180@.TK2MSFTNGP10.phx.gbl
> Well, I need to enable the tcp/ip protocol via registry,
> so I added the following value inside the registry
> [HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsof t SQL
> Server\GESTP\MSSQLServer\SuperSocketNetLib\Tcp]
> "TcpHideFlag"=dword:00000000
> "TcpDynamicPorts"="0"
> "TcpPort"="1433"
> But if I call the svrnetcn tool tcp/ip isn't listed as enable
> protocol.
> Why?
you have to check
HKLM\SOFTWARE\Microsoft\Microsoft SQL
Server\InstanceName\MSSQLServer\SuperSocketNetLib
\ProtocolList
key, that must include the "tcp" value
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.9.1 - DbaMgr ver 0.55.1
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
Subscribe to:
Posts (Atom)