Setting up Connection String with IIS Manager

On a previous article I discussed how to properly configure the database connection string after deploying the application. However this way required to edit the web.config and sometimes users had issues with the code and couldn’t get their application working. There’s an easy way to do this without modifying the web.config. In this article I will give you a step by step guide on how to set up the connection string with IIS Manager

1. Open IIS Manager and connect to your site:

connection 1

2. Once connected, click on Connection Strings:

connection 2

3. Click on Add to configure a new connection string:

connection 3

4. First, add the connection string name. Make sure it is the same connection string that you use in your ASP application. Then add the server’s name and also the name of the database:

connection 45. Before saving, we have to set up the credentials to connect to your database. Set Credentials to ‘Specify Credentials‘ and then click on ‘Set…

connection 5

6. Enter the username and password of the database that your application will be using and click ok:

connection 6

7. Check that the information is correct and click on ‘Ok‘:

connection 7

8. And that’s it! Your Connection String has been configured!

connection 8

Looking for quality Asp Hosting? Look no further than Arvixe Web Hosting!

Happy Hosting!

Rodolfo Hernandez

Tags: , , , , , , , , , , , , , , , , , , , , , | Posted under ASP .NET 2, ASP .NET 3.5, DotNet/Windows Hosting, DotNetPanel Administration, MSSQL, Web Deploy, WebsitePanel Tutorials, Windows Server Admin | RSS 2.0

Author Spotlight

Rodolfo Hernandez

I like photography and reading books. Currently working for Arvixe as Elgg Community Liaison. Elgg Security Expert Web Security Expert CEO of UDP SW Social Web

Leave a Reply

Your email address will not be published. Required fields are marked *