Local Database Connection String

Question

1.00/5 (1 vote)

See more:

Hi everyone,

I have classical ASP.Net web application, and my Connection string is in webconfig file. I published this to my iis server 8. When i run the iis application, the web application can not connect the local database.

What should i do for the connection? IIS Application pool settings or Web config Connection string settings?

My iis server url is localhost:8082 and i could not connect my Database.

Thanks a lot

Posted 28-Dec-13 10:26am

batuhan karaduman

Add a Solution

Comments

ZurdoDev 28-Dec-13 22:09pm

What was the error? Why won't it connect?

Rana Zarour 29-Dec-13 5:56am

what is your connection string ?

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

S. M. Ahasan Habib · Answer 1 · 2013-12-29T01:52:00

Database connectivity not depends on your local iis server/iisexpress or other things. It is depends on proper connection string which you store anywhere there you can access it and programatically read. No metter it is web.config or not. But usually we store it web.config file for easily read using System.ConfigurationManager class. Your problem is when you publish it, you can not connect to the database from your applicaton. If so please first check your web.config file after publishing your site. It would be better if you check it from file system. Means where your web application files are deployed. In that web.config files what the value it contains and that are really valid or not. You can write some code from your application and write some logs what connection string it finds when published and use try catch block and write log of this exception in details so that you can identify what the problem is.