Click here to Skip to main content
Rate this: bad
good
Please Sign up or sign in to vote.
See more: IIS7 Authentication
Hi
 
I have tried working with windows authentication for my application and it works fine, but my requirement is to add the credentials(username and password) only in the application settings in the IIS7 and I don't want to add the access roles in the database(sql server 2008) is it possible to do it that way? please provide suggestive link if there any
Posted 25-Apr-13 21:36pm
Comments
Bernhard Hiller at 26-Apr-13 2:57am
   
Where is your problem? Connecting to the SQL Server with SQL Server authentication instead of Windows Authentication? Access rights to your web application?
Shashwath7 at 26-Apr-13 3:43am
   
Hi
 
I want to create a SQL Server login that uses Windows Authentication without adding the Login name.Is it possible if not whats the ideology behind it

1 solution

Rate this: bad
good
Please Sign up or sign in to vote.

Solution 1

 
<system.web>
   
        <compilation debug="true" targetframework="4.0"></compilation>
 
        <identity impersonate="true" username="yourSystemUserName" password="YourSystemPassword" />
 </system.web>
 
 <appsettings>
        <add key="ConnString" value="server=YourServer;database=YourDatabase;Integrated Security=true;"></add>
    </appsettings>
 

try these settings.
  Permalink  

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

  Print Answers RSS
0 OriginalGriff 5,170
1 DamithSL 4,357
2 Maciej Los 3,750
3 Kornfeld Eliyahu Peter 3,470
4 Sergey Alexandrovich Kryukov 2,851


Advertise | Privacy | Mobile
Web04 | 2.8.141216.1 | Last Updated 26 Apr 2013
Copyright © CodeProject, 1999-2014
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100