I recently upsized an Access dB to SQL 2000 dB. I have put in the proper users to access SQL Server, but I keep getting an error "Cannot generate SSPI context" whenever a client computer tries to log on to the dB.
How do I fix this problem. I think it has something to do with not having the correct drivers to connect to SQL Server, but I don't know how to fix it. I've searched Books On Line, but it doesn't tell me how to resolve the error.
Thanks in advance,
Joe T
This error is generated if you're unable to impersonate the client over TCP.
Try using Named Pipes as the IPC. Use the SQL Client Network Utility to
either create an alias using
Named Pipes or put Named Pipes on the top of the list.
Thanks,
Kevin McDonnell
Microsoft Corporation
This posting is provided AS IS with no warranties, and confers no rights.
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment