Click here to Skip to main content
13,045,379 members (123,385 online)
Rate this:
Please Sign up or sign in to vote.

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 20:36pm
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

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
Please Sign up or sign in to vote.

Solution 1

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

try these settings.

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
Web02 | 2.8.170713.1 | Last Updated 26 Apr 2013
Copyright © CodeProject, 1999-2017
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