SQL Server client connection on novell netware 4.11 
Author Message
 SQL Server client connection on novell netware 4.11

We have problem getting sql server 7.0 client connection working.
The server is on NT 4, client on novell netware 4.11, and the
version of sqlsrv32.dll 3.70.0623. We used TCP/IP, port 1433.
The error message is:

Connection failed:
SQL State: 'HY000'
SQL Server Error: 1060
[Microsoft][ODBC SQL Server Driver]Cannot generate SSPI context

We had a couple of testing which might give any indication:

1) We tried an older version of sqlsrv32.dll (3.60.0319) and
got the connection successful to the extend that we could see all
databases from enterprise manager and query analyzer, but could not
query data. The query analyzer complained the version of sql server
odbc driver being lower than 3.7.
2) There is no problem with connection from a client on microsoft
network

Any idea where our problem is?

Thanks,

Tian Chen



Fri, 18 Jan 2002 03:00:00 GMT
 SQL Server client connection on novell netware 4.11

Some things to check on your server that can cause this problem.

1) If IP protocol was loaded on this server (or reloaded) after SP4 or
5 was applied it can cause this problem. If that is the case, please
stop SQL and reapply NT SP4 or 5.

2) Check the permissions on the following registry key:

HKEY_LOCAL_MACHINE\SYSTEM\CURRENTCONTROLSET\SERVICES\NTLMSSP

There should be four subkeys here ENUM, LINKAGE, PARAMETERS, SECURITY.

Permissions on all these keys starting from NTLMSSP down should be:

EVERYONE (Special Access)
        Query Value
        Create Subkey
        Enumerate Subkeys
        Notify
        Read Control
SYSTEM (Full Control)
Servername\Administrators (Full Control)

If this is not the case set these permissions at NTLMSSP and check
the "Replace permissions on existing subkeys" box.

Then select the SECURITY subkey and remove the permission for EVERYONE.
That will leave SYSTEM and Servername\Administrators with Full Control.

Then reboot the server and test your clients.

Hope this helps.

Ralph


Quote:

> We have problem getting sql server 7.0 client connection working.
> The server is on NT 4, client on novell netware 4.11, and the
> version of sqlsrv32.dll 3.70.0623. We used TCP/IP, port 1433.
> The error message is:

> Connection failed:
> SQL State: 'HY000'
> SQL Server Error: 1060
> [Microsoft][ODBC SQL Server Driver]Cannot generate SSPI context

> We had a couple of testing which might give any indication:

> 1) We tried an older version of sqlsrv32.dll (3.60.0319) and
> got the connection successful to the extend that we could see all
> databases from enterprise manager and query analyzer, but could not
> query data. The query analyzer complained the version of sql server
> odbc driver being lower than 3.7.
> 2) There is no problem with connection from a client on microsoft
> network

> Any idea where our problem is?

> Thanks,

> Tian Chen

Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't.


Wed, 30 Jan 2002 03:00:00 GMT
 
 [ 2 post ] 

 Relevant Pages 

1. PDOX 4.0/WIN95/Novell 4.11/32-bit Novell Client

2. URGENT HELP -- ORA-12571 on Oracle7.1/Novell Netware 4.11

3. URGENT HELP -- ORA-12571 on Oracle7.1/Novell Netware 4.11

4. Oracle Agent on Novell Netware 4.11

5. Paradox Dos 4.02 and Novell Netware Version 4.11

6. Help w/Pdox 4.0 and Novell Netware 4.11

7. Btrieve 6.10f database corruption on Novell NetWare 4.11

8. Progress V8 and Novell Netware 4.11

9. Installing SQL Server 6.5 on a Novell 4.11 Server

10. SQL Server super slow when Novell Client For Netware is installed on client PC

11. SQL Server super slow when Novell Client For Netware is installed on client PC

12. SQL Server super slow when Novell Client For Netware is installed on client PC


 
Powered by phpBB® Forum Software