Server Fault is a question and answer site for system and network administrators. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I have a server running IIS7, and Ii want to set up an SQL database on it to use with my web application. I have read this post and I'm very new to this so I'm a bit lost as what to do.
can somebody please give me some pointers as to how to go about doing this.

share|improve this question
Can you clarify what you're trying to achieve? Install MS SQL? – Dan Feb 24 '10 at 11:18
Basically i'm trying to connect to an sql database hosted on the same machine as the iis server using the same connection string that worked when running it in VS (using integrated security). I think it must have something to do with permissions. – harryovers Feb 24 '10 at 11:40
up vote 0 down vote accepted

You will need to make sure the Identity of your Application Pool (account your application pools runs as) has access to the database since you want to use integrated security.

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.