RE: Interdev not creating project (authenticate failure)

From: IT Community (it-community.online@microsoft.com)
Date: 11/09/02 

From: it-community.online@microsoft.com (IT Community)
Date: Sat, 09 Nov 2002 16:30:10 GMT

You wrote:
| 1st Computer (for SQL Server and IIS):
| Computer Name "SERVER"
| Windows 2000 Advanced Server
| SQL Server Enterprise SP2
| NTFS partition
| Member of Workgroup "HOME"
| No Domain
| No Active Directory
| User Accounts:
| 1.
| Username: Administrator
| Password: pwd
| Member of: Administrators
| 2.
| Username: user01
| Password: <blank>
| Member of: Users/Administrators
|
|
| 2nd Computer (for SQL Server client tools and Visual
| Studio 6 Interdev with SP5):
| Computer Name "LOCAL1"
| Windows XP Professional
| SQL Server Enterprise (Client Tools Only) SP2
| NTFS partition
| Member of Workgroup "HOME"
| No Domain
| No Active Directory
| User Accounts (same as 1st computer):
| 1.
| Username: Administrator
| Password: pwd
| Member of: Administrators
| 2.
| Username: user01
| Password: <blank>
| Member of: Users/Administrators

Response:
This is a work group environment. Namely there is no a central security
database as it is in a domain environment.
Computers in the same workgroup will be visible to one another. Still
"each" machine has its own security database locally. Consequently each
machine will need to have the account information of an intended user.
Also in IIS console, rightclick the web site and go to properties/directory
security/edit anonymous access and authentication control, uncheck
Integrated Windows and check Basic authentication. This will allow user
credentials to be passed to IIS for authentication. More information on how
IIS authenticates a user, please review

Q308160 HOW TO: Configure Internet Information Services Web Authentication
in
http://support.microsoft.com/default.aspx?scid=kb;EN-US;Q308160

Hope this helps.

Please do not send email directly to this alias. This is an online account
name for newsgroup participation only.
This posting is provided "AS IS" with no warranties, and confers no rights.
You assume all risk for your use.

Cumulative Patch for Internet Information Service (Q327696) released on
10/30/2002
http://www.microsoft.com/technet/treeview/default.asp?url=/technet/security/
bulletin/MS02-062.asp
Microsoft Product Service Packs
http://support.microsoft.com/default.aspx?ID=FH;EN-US;sp&FR=0&SD=GN&LN=EN-US
&CT=SD&SE=NONA
Microsoft IIS Bookstore
http://go.microsoft.com/fwlink/?LinkID=8279

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)
  • 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)
  • VPN NT Authentication
    ... I am trying to access the SQL Server through a VPN using ... NT Authentication. ... login and into the database as a member of a group. ...
    (microsoft.public.sqlserver.security)