I have a SQL server running on a Windows 2000 Server SP 4 and I am having
problems connecting to it. When I attempt to connect to the server using
integrated security as a user in the local Administrators group on the server
I can connect just fine. When I attempt to connect to SQL server using an
SQL login I can connect just fine. Wnhen I attempt to connect to the sever
using integrated security with a user who is not a local admin on the SQL
server I receive the following error:

SqlDumpExceptionHandler: Process 54 generated fatal exception c0000005
EXCEPTION_ACCESS_VIOLATION. SQL Server is terminating this process..

Does anyone have any ideas as to what the cause and solution would be?
--

Hi,

This error message indicates an access exception. Most likely, the user
account is not permitted in any database. Verify the user account is added
as a user in at least one database.

If the account is a user in at least one database, the next areas to check
are the system databases. Check for the guest account in the system
databases. It should be present.

Let me know if this helps.

Thank you.

Gary Whitley

This posting is provided "AS IS" with no warranties, and confers no rights.