Click here to Skip to main content
12,067,351 members (55,344 online)
Rate this:
 
Please Sign up or sign in to vote.
See more: IIS7 IIS 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 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 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
Top Experts
Last 24hrsThis month


Advertise | Privacy | Mobile
Web03 | 2.8.160208.1 | Last Updated 26 Apr 2013
Copyright © CodeProject, 1999-2016
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