Re: Can't connect to SQL server in Windows XP SP2

Thanks, I'm not sure how to turn on login auditing, but using profiler is a
good idea. I wonder why I didn't think of it.

Chris Pankhurst

"Sue Hoegemeier" <Sue_H@xxxxxxxxxxxxx> wrote in message
news:u257j19kdbt8s946sb7mu633v2nm1tb8el@xxxxxxxxxx
> Sometimes you can tell from the full text of the error
> messages. You could turn on failed login auditing to see if
> the login is hitting the server and failing. You can also
> monitor for login failures in Profiler. You won't get a lot
> of information on the login failure but enough to see if the
> client is hitting the server.
>
> -Sue
>
> On Fri, 23 Sep 2005 12:01:20 +1200, "Christopher Pankhurst"
> <christopher_pankhurst@xxxxxxxxxxx> wrote:
>
> >Yes, I opened the ports 1433 and 1434 in Windows Firewall and SQL server
is
> >set to windows or sql authentication. I believe I opened them with the
> >correct TCP/UDP combination. I also told windows firewall about
> >sqlserver.exe, however I suspect that is more for outbound connections.
> >
> >I understand the security reasons why the normal error message has to be
> >vague about sql server does not exist or access denied. Is it possible to
> >configure SQL server into a diagnostic mode where it will tell the client
> >that the sql server does exist but it was just that access was denied?
This
> >would help me narrow down the problem.
> >
> >If not, how can I tell if it is networking/firewall type problem or an
SQL
> >server security problem?
> >
> >Chris Pankhurst
> >
>


.

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)