tcp/ip on sql server 6.5

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

echeclus@gmail.com - 22 Jul 2008 21:19 GMT

Hi, I need tcp/ip on sql server 6.5 sp5 (windows NT sp6) but if I run
setup-change network support I see only "Named pipes" and
"multiprotocol".
How can I add "TCP/IP sockets"?
Thank you.

Reply to this Message

Tibor Karaszi - 23 Jul 2008 11:51 GMT

Now, I haven't used 6.5 for many years now - probably close to some 8 years. But from memory the IP
netlib is not available if you run your SQL Server in "Windows Only" security mode. The old
architecture had three security modes where new architecture has only 2 modes. But I do remember
that the IP netlib had some relationship with security mode since trusted connections couldn't be
established over the IP netlib.

Signature

Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi

> Hi, I need tcp/ip on sql server 6.5 sp5 (windows NT sp6) but if I run
> setup-change network support I see only "Named pipes" and
> "multiprotocol".
> How can I add "TCP/IP sockets"?
> Thank you.

Reply to this Message

echeclus@gmail.com - 23 Jul 2008 12:07 GMT

On 23 Lug, 12:51, "Tibor Karaszi"
<tibor_please.no.email_kara...@hotmail.nomail.com> wrote:

> Now, I haven't used 6.5 for many years now - probably close to some 8 years. But from memory the IP
> netlib is not available if you run your SQL Server in "Windows Only" security mode. The old
[quoted text clipped - 14 lines]
> > How can I add "TCP/IP sockets"?
> > Thank you.

Thank you.
I changed security from integrated to standard and now I can select
tcp/ip sockets.
I have to use sql server 6.5 on NT in vmware server for legacy reasons
and now the ODBC connection (from a winxp system) works good.
Bye.

Reply to this Message