Solved

Login failed for user DOMAIN\SERVER$, Active Directory Auhtentication

Posted on 2008-10-28
4
601 Views
Last Modified: 2012-06-21
I added security in the form of Roles and Users Groups in SQL 2005.  Using Active Directory I would like to connect to my application using the Roles which I have set-up in my web.config file.  
Aportion of my web.config file that pertains to connecting to the database and code snippet from one of the ASPX.VB files is included.

I am on week two of trying to resolve this error, your help is greatly appreciated.

Thank you.

LadyG

            
<connectionStrings>
  <add name="TiresConnectionString" connectionString="Data Source=DOMAIN\(INSTANCE17);Initial Catalog=TiresDb;Integrated Security=True"/>
  </connectionStrings>
<configProtectedData>
<providers>
<add useMachineProtection="false" keyEntropy="" name="TiresDataProtectionConfigurationProvider" 
type="System.Configuration.DpapiProtectedConfigurationProvider, System.Configuration, Version=2.0.0.0,Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a"></add>
</providers>
</configProtectedData>
<system.web>
<authentication mode="Windows"/>
   <roleManager enabled="true" defaultProvider="AspNetSqlRoleProvider"
     cacheRolesInCookie="true" createPersistentCookie="false" cookieProtection="All">
<providers >
 <remove name="AspNetSqlRoleProvider" />
 <add name="AspNetSqlRoleProvider" applicationName="Tires"
 connectionStringName="TiresConnectionString"
 type="System.Web.Security.SqlRoleProvider, System.Web, Version=2.0.0.0, Culture=neutral,PublicKeyToken=B03F5F7F11D50A3A"/>
 <remove name="AspNetWindowsTokenRoleProvider" />  
</providers>
</roleManager >
 <authorization>
 <allow roles ="Admin, Supervisor, User"/>
 <allow users ="DOMAIN\(INSTANCE17) Users,DOMAIN\(INSTANCE17) Supervisors, DOMAIN\(INSTANCE17) Admin Users"/>
<deny users="*"/>
</authorization>
 <identity impersonate="true"/>
<customErrors mode="Off" defaultRedirect="UnauthorizedUser.aspx">
<error statusCode="401" redirect="UnauthorizedUser.aspx"/>
</customErrors>
*********************
From my code behind file:
 If (Roles.IsUserInRole("Admin", "password")) Then
    Else
Response.Redirect("http://intranet.tires.asp")
End If

Open in new window

0
Comment
Question by:LadyGail
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
  • 2
4 Comments
 
LVL 42

Expert Comment

by:Eugene Z
ID: 22830648
please see solution from
http://forums.asp.net/t/917229.aspx 
0
 

Author Comment

by:LadyGail
ID: 22830782
More confusion has resulted by reading your suggested solution, not to say that contained within it is a solution, just I don't understand fully, where I need to begin.
Question:
Am I to modifiy the Machine.config file contents to resemble that listed on the solution site?
Where might I find the Machine.config file (do note that my level is beginner)?
My application has three level of users with a three passwords, how to I incorporate the specifics into the Machine.config file?
What is the Application Pool and where might I find it?
How to I ensure that the Application Pool is a member of IIS_WPG Group in order to give it rights to Microsoft.Net\version no...., and the temp directory.
How do I restart the App Pool?

Thank you.

LadyG
0
 

Author Comment

by:LadyGail
ID: 22830829
Additionaly I am using
SQL 2005
Active Directory
IIS6
.NET 2.0
0
 
LVL 42

Accepted Solution

by:
Eugene Z earned 250 total points
ID: 22834017
in IIS you can see what account is used for your Application Pool  (see tab identity)  ->it is probably network system account;
 
in local user groups on the server check if it is member of IIS_WPG
then:
--
for this account -give NTFS (Full)  permisssions  on the folder C:\windows\Microsoft.NET
--
<restart the App Pool?
in IIS right click  App Pool- stop - start  or restart IIS..
 
 
0

Featured Post

Back Up Your Microsoft Windows Server®

Back up all your Microsoft Windows Server – on-premises, in remote locations, in private and hybrid clouds. Your entire Windows Server will be backed up in one easy step with patented, block-level disk imaging. We achieve RTOs (recovery time objectives) as low as 15 seconds.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Need help in debugging a UDF results 7 49
How can I find this data? 3 23
SQL- GROUP BY 4 21
Tech Writing: 'Browser Window' or 'Browser Tab' 4 14
In this article we will get to know that how can we recover deleted data if it happens accidently. We really can recover deleted rows if we know the time when data is deleted by using the transaction log.
These days, all we hear about hacktivists took down so and so websites and retrieved thousands of user’s data. One of the techniques to get unauthorized access to database is by performing SQL injection. This article is quite lengthy which gives bas…
This video teaches viewers how to create their own website using cPanel and Wordpress. Tutorial walks users through how to set up their own domain name from tools like Domain Registrar, Hosting Account, and Wordpress. More specifically, the order in…
Use Wufoo, an online form creation tool, to make powerful forms. Learn how to selectively show certain fields based on user input using rules to gather relevant information and data from your forms. The rules feature provides you with an opportunity…

735 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question