Re: Network login problem

Please explain why the events is logged in the SQL server logs if remote connections is not enabled.

Regards;
/jb

"Sean McCown" <SeanMcCown@xxxxxxxxxxxxxxxxxxxxxxxxx> skrev i meddelandet news:3A4859FD-BDEB-470E-8E94-CD153CA080E6@xxxxxxxxxxxxxxxx
Sounds like you don't have remote connections setup.

Goto Surface Area Configuration and on the connections tab, make sure you've
enable remote.
--
Read my book reviews at:
www.ITBookworm.com

Blog Author of:
Database Underground -- http://weblog.infoworld.com/dbunderground/
DBA Rant – http://dbarant.blogspot.com




"Jonny Bergdahl" wrote:

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: 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)
  • Re: cannot acees two databases as owner
    ... it does not matter you are a member of the ... the sysadmin fixed server role or if there is no any other Login which is ... group if it's a domain) and you can login to your SQL Server with, ...
    (microsoft.public.sqlserver.setup)
  • Re: Database security design with ASP.net and form-based authentication
    ... Since you already have forms-based security, why not use a single SQL login ... for all database access? ... data entry, guest/view only, admin, report viewer. ... so I'm using SQL Server authentication. ...
    (microsoft.public.sqlserver.security)
  • Re: Credentials not being passed with remote access
    ... allowed windows authentication to work, ... I had assumed johnx was a domain user rather than a local Windows account. ... johnx was set up as a local login on sql server. ...
    (microsoft.public.sqlserver.security)
  • Re: No db access after publishing web site
    ... GRANT UPDATE TO ... If I detach and attach this database on a different PC (according that PC ... Cannot open database "pago" requested by the login. ... Are you detaching/attaching the SQL Server Express database correctly ...
    (microsoft.public.dotnet.framework.aspnet)