Coupon code copied
Server Intellect
(855) 850-HOST

Toll Free 24/7/365        (4678)

Get help from a Microsoft Certified Engineer.

Intellect Connect

Technical problem with your Windows Hosting?

Let our Microsoft Certified experts handle the problem for you.
Chat Now

Using Integrated SQL Server Security in your Website

To enable your site to use integrated SQL authentication you will first need to determine the user ID the site is running under.

Step 1

Start by logging into your server and opening up the IIS Management Console.

Next locate the site you would like to use integrated authentication on and right click and select Properties.

kb-integrated-sql-site-1

Step 2

Next select the security tab and click on theĀ Edit button.

kb-integrated-sql-site-2

Step 3

This should display the user that the web site is running as.

kb-integrated-sql-site-3

Step 4

Now that you know what user the site runs under you can grant this user permissions on the database server. Open up SQL Management Studio and expand the Security folder.

Right click on the Logins folder and select New Login.

kb-integrated-sql-site-4

Step 5

Click on the Search Button to the right to begin locating the Windows Login for your site.

kb-integrated-sql-site-5

Step 6

Now click on the Advanced button and then the Find Now button. This should list all the users and groups on the system.

kb-integrated-sql-site-6

Step 7

Now select the user from the list that was listed under the security tab in IIS.

kb-integrated-sql-site-7

Step 8

One you have this users selected press OK to return to the new user options.

kb-integrated-sql-site-8

Step 9

Now set the default database for your site at the bottom.

kb-integrated-sql-site-9

Step 10

Now select the User Mapping Tab from the top left hand corner. Once the list of databases appears, check the box next to your database name and then the db_owner checkbox as well. Public should already be checked by default.

kb-integrated-sql-site-10

Now press OK and your IIS user should have access to your database and you should be able to use integrated authentication.

Interested in letting our experts solve your IT problems for you?
Get a free, no-obligations consultation with one of our experts today!

Call us at (855) 850-HOST

Chat Now

Start Your Order

X

This form does not accept free e-mail accounts. Please enter a business e-mail to submit it.

Submit Form Cancel

Please wait...

Submitting your info. This may take less than a minute.