• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 607
  • Last Modified:

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

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.


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

Open in new window

  • 2
  • 2
1 Solution
Eugene ZCommented:
please see solution from
LadyGailAuthor Commented:
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.
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.

LadyGailAuthor Commented:
Additionaly I am using
SQL 2005
Active Directory
.NET 2.0
Eugene ZCommented:
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
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..

Featured Post

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now