Re: Authentication problem

From: Brian Sabino [MS] (briansa_at_online.microsoft.com)
Date: 02/20/04 

Date: Fri, 20 Feb 2004 14:29:22 -0800

As matt notes below, even if nothing on your box has changed it's possible
that the account you're using on your IIS machine has had it's password
expire. 

-- 
This posting is provided "AS IS" with no warranties, and confers no rights.
"Matt" <none@none.com> wrote in message
news:5j3c309qe2a3svhumknmf0mf101th729hq@4ax.com...
> Hi there
>
> On your IIS box, check the HTTP Authentication tab of the SQL Server
> CE Connectivity Management Console for you SQL CE virtual directory.
> Ensure that your authentication method is correct.
>
> Also, assuming that you are not using anonymous authentication, ensure
> that the username and password of the user with which the PPC app is
> trying to connect is still valid on the IIS box.
>
> To simplify your connectivity troubleshooting, you can browse to the
> SQL Server CE Server Agent using a browser:
> e.g. https://myserver/sqlce20/sscesa20.dll
>
> If your SQL CE virtual directory is set up for anonymous access, then
> you won't need a username and password to access the above dll.
> However, if you are using basic authentication or windows
> authentication, then you will need to supply the username and password
> of the user with which the PPC app is trying to connect to the Server
> Agent.  If the connection is successful, you should receive a simple
> message in the browser saying "SQL Server CE Server Agent".
>
> I hope this helps.
>
> Matt
>
> On Thu, 19 Feb 2004 14:42:27 -0600, Mark Clark
> <M-ClarkRemoveThis@wiu.eduNo-Spam> wrote:
>
> >  We have an Windows 2000 SP 4 server, running SQL server, with IIS and
> >SQLCE 2.0, that has been running fine for over a year.  Just recently
> >(this week), when we run our VB app on the PPC, we get the following
> >message:
> >
> >Source: Microsoft SQL Server 2000 Windows CE Edition
> >Error Number: 80004005
> >Native Number: 28011
> >Error Description: Authentication failed on the computer running IIS.
> >[,,,,,] Authentication failed on server SSCE_M_HHTPSTATUSDENIED
> >Param=0
> >Param=0
> >Param=0
> >Param=
> >Param=
> >Param=
> >
> >This is all I can see of the error.  The ONLY thing I know of that's
> >changed is we've applied Windows Updates to the machine.
> >
> >What can I do to figure out what is happening and/or troubleshoot this?
> >Thanks!
>

Relevant Pages

  • Windows Authentication with IIS on separate machines
    ... Yes, setting Basic Authentication in IIS works, but the ... >in SQL server but doesn't work if user account was ... >imported from a Windows account. ...
    (microsoft.public.sqlserver.security)
  • RE: IIS (ASP) -> SQLServer Authentication Issue
    ... I understand that you'd like to use IIS Intergration authentication in the ... and ASP "impersonates" authencitaed users to access SQL Server on ... only kerberos authentication allows double-hops from clients ...
    (microsoft.public.sqlserver.security)
  • IIS vs ASP.Net Authentication problem
    ... Requirement is to use 'domain\iisuser' to authenticate in SQL Server ... Only Integrated Windows Authentication enabled (Anonymous/basic/digest ... unchecked) in IIS 5 ... Login failed for user 'CCMIWS05\ASPNET'. ...
    (microsoft.public.dotnet.security)
  • RE: Interdev not creating project (authenticate failure)
    ... | 1st Computer (for SQL Server and IIS): ... | Member of: Administrators ... Also in IIS console, rightclick the web site and go to properties/directory ... Integrated Windows and check Basic authentication. ...
    (microsoft.public.inetserver.iis.security)
  • Re: Get UPN in ASP
    ... > We are using the Windows authentication in the config file. ... > authenticated to IIS and the File System? ... >>> Matt ...
    (microsoft.public.dotnet.framework.aspnet.security)