KB Created By inflectra. This lets the application pool access the local system resources only: When you want to connect to a database on a remote server, the application doesn't use this identify, instead it uses the login and password that is configured in the application's Web. In this case, you will need to change the IIS application pool to run as a Active Directory user instead: When you want to connect to a database on a remote server, the application will use this identify to make the connection, instead of using an identity hard-coded in the Web.
Run as Service permissions to be able to used as a service account. Select files to upload Or drag and drop files here. Uploading …. Upload More? To begin, you need to configure your application in IIS to turn off anonymous access and turn on Windows authentication. Open the node for your server, and then open nodes until you find the node for your application, which is typically located under Default Web Site.
In the Authentication Methods dialog box, clear the Anonymous Access check box, and then do one of the following:. In the application configuration file Web. Open the node for the server and expand the node for the database you want to give users permissions for.
Additionally, configure the SQL Server to allow all domain users to access the database. Skip to main content. Andomar Andomar k 44 44 gold badges silver badges bronze badges.
OK, thanks for the tip. To be honest I just want to get it working on my local machine; once it gets deployed I'll leave it to the network admins to work it out :- — gerrod.
Well no; but I need to use the integrated Windows Authentication in order to work out who the user of the application is. Usually I would do the same thing, otherwise! Have you switched the asp. Raj More Raj More Sign up or log in Sign up using Google. Sign up using Facebook. Sign up using Email and Password.
Post as a guest Name. Email Required, but never shown. The Overflow Blog. Archived Forums. Sign in to vote. Please review the stack trace for more information about the error and where it originated in the code. Exception Details: System. Monday, August 18, PM. Sunday, August 24, PM. User posted Great, thanks for your help. Wednesday, August 20, PM. User posted I understand that IIS uses the process account, Network Service acount in my case, to access resources.
Thursday, August 21, AM. User posted Thanks, these articles are helpful. Friday, August 22, AM. User posted What you need to do is add the web server machine account on the sql server.
Monday, August 25, PM. User posted Hi, You are encountering the classic 'double-hop' scenario. Thursday, August 28, AM.
0コメント