Here is the situation:
Where I work (small division of large company), we have a single on site big company owned server running SQL Server. We only have access to this server through windows authentication, and only a single windows account (xyzCo\theUser) can be used to access it. As this server is ran by large company instead of small division, we cannot change this setup, and we have to work within their rules.
We are looking to to purchase a second (division owned) server to run IIS for a simple intranet, but we need to access data on the SQL Server instance. Being primarily a programmer, I have never done this, so I figured here would be the correct place to ask.
Is it straight forward to configure IIS to use a particular Windows account to connect to SQL Server?
I have researched this, and particularly, the following article: http://msdn.microsoft.com/en-us/library/ff647396.aspx
In theory, it seems i just set "xyzCo\theUser" as the user for the application pool, then I can connect in code using standard means.
Is it actually this easy?
Are there any pitfalls I need to avoid? Anyone who has done this before have any other advice? Any other step-by-step instructions online?