Network login problem

I have a problem with a newly installed system where I can't seem to login from a client. The SQL Server is set up for mixed authentication, and I can login locally (using the Managment Studio). I have checked the the event log, which verifies that the SQL Server indeed has denied the login. Both the SQL Server machine and the machine I am trying to login from is both Windows 2003 Servers running as domain controllers for the DOMAIN domain. My account is member of a domain group that in turn is granted the 'sysadmin' role on the SQL Server (however, as I can login locally, I don't think that matters).

SQL Server 2005, 9.00.2042 (Build 3790 Service Pack 2).

This is the ERRORLOG lines of the failed login event.

2008-05-22 20:36:38.56 Logon Error: 18456, Severity: 14, State: 5.
2008-05-22 20:36:38.56 Logon Login failed for user 'DOMAIN\jonny'. [CLIENT: x.x.x.x]

State 5 means 'invalid userid'???

I also have problems with login using a machine account. The setup is the same, the computer is member of a domain group that in turn is granted the 'public' role to the SQL Server. This also fails, but with another State code.

2008-05-22 19:57:40.25 Logon Error: 18456, Severity: 14, State: 11.
2008-05-22 19:57:40.25 Logon Login failed for user 'DOMAIN\WEB01$'. [CLIENT: x.x.x.x]

State 11 means 'Valid login but server access failure'.

I am basically stuck, so any help is much appreciated.

Regards;
/jb

.

Relevant Pages

  • Re: SQL Login
    ... The sa login account is a member of that role as well. ... Dejan Sarka, SQL Server MVP ... > But how do we add the User X to the sysadmin / ...
    (microsoft.public.sqlserver.security)
  • Re: Keeping User From Deleting Table Records
    ... Hugo - Your comment about the user being a member of an admin group did the ... - I have created a new Windows user login in Security/Logins that is ... SQL Server to obtain default settings for the additional configuration ...
    (microsoft.public.sqlserver.security)
  • Re: Other way of Changing Password if does not have Server Role
    ... A user can change his password without being a member of the sysadmin role. ... You just have to login as the user and then omit the 3rd parameter ... Dejan Sarka, SQL Server MVP ...
    (microsoft.public.sqlserver.security)
  • RE: Network login problem
    ... Sounds like you don't have remote connections setup. ... which verifies that the SQL Server indeed has denied the login. ... account is member of a domain group that in turn is granted the 'sysadmin' ...
    (microsoft.public.sqlserver.connect)
  • Re: Unexpected Login Screen When Accessing SQL Data Via .NET Intra
    ... >> data and the SQL Server is on the same server. ... >> My problem is that one user has started getting a login popup ... >> right in via Windows Authentication like everyone else and like they ...
    (microsoft.public.sqlserver.connect)
Loading