Hello

I have a user who is attempting to connect to SQL Server Enterprise 2000 SP3a running on Windows 2000 Server. The client has WIndows NT 4.0 with MDAC 2.8. The problem is that when I attempt to create the ODBC link , I receive the following error

"connection failed
sqlstate '01000'
sql server error 770
Microsoft odbc sqlserver driver tcp/ip socket connection write
secencrypt data
Connection failed
sql state '08S01'
Sql server error 18 security error

------
SSL/Encryption is not forced on the Server and I have many other clients who have no issues in connecting

If anyone has any suggestions, I would appreciate it

Thank

The only thing that I can think of is that if the user has
had their NT Account re-created, and if you are using "NT
Authentication" in ODBC to connect to SQL Server, then SQL
Server will not recognise the user (It be a Ticket
problem).

If this is the case then re-register the user in SQL
Server and try again.

Hope This Helps


Tony C.
[quoted text, click to view]
Enterprise 2000 SP3a running on Windows 2000 Server. The
client has WIndows NT 4.0 with MDAC 2.8. The problem is
that when I attempt to create the ODBC link , I receive
the following error:
[quoted text, click to view]