Re: Authentication problem

From: Matt (none_at_none.com)
Date: 02/20/04 

Date: Fri, 20 Feb 2004 13:58:21 +0000

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: Authentication problem
    ... As matt notes below, even if nothing on your box has changed it's possible ... > On your IIS box, check the HTTP Authentication tab of the SQL Server ...
    (microsoft.public.sqlserver.ce)
  • 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: Windows Authentication in asp.net 2005 to SQL Server?
    ... If the domains do not trust each other, Windows authentication is not going ... Basic authentication sometimes makes the need for Kerberos delegation go ... generic account to do the backend data stuff on our SQL Server. ...
    (microsoft.public.dotnet.framework.aspnet.security)