Database connections in .NET applications
Depending on your database different senarios will apply. For example for a wide area intranet application, I am using overlays on top of Bing Maps. The GIS data is acessed through, in my case, javascript to the ArcSDE connection on a SQL Server 12.0 database. In development, the application passed my username/credentials -- however on my first test on the production database that was not the case. IIS would not pass the username/creditials to the database but only passed the IURS_XXXX user (IIS local user). What I had to do in my application is to create a user account on the server, set the app on IIS to use that user, and within SQL Server set appropriate permissions for the created account. Another way around this issue would be setting up a worker pool on IIS for that created account and your app would be set to use that worker pool......
Along with our System Administrator --- it was a lot of trial error before we got a working balance! I imagine every set up would be different -- Now if you are using Kerberos as part of your security, you may have to yet go through another level of setting up stuff -- A lot of this is highly depended upon your individual network set up so any one answer may or may not apply to you.
For my case I set up a domain and local account srv-mdxinfo. Hope this gives you some things to try out!
