hosting the website in IIS problem

Question

4.00/5 (1 vote)

See more:

Hi All,

I am using asp.net,C#,VS 2005,and sql server 2005
I have created a setup file for my web project...
I have also installed IIS in my PC..
my database (.mdf) file is in App_Data folder
I have installed my project now ...

my web.config contains the following connection string:

XML

<connectionStrings>
        <add name="conStr" connectionString="Trusted_Connection=true;pwd=;Initial Catalog=CLINICAL;Data Source=(local)" providerName="System.Data.SqlClient"/>       
    </connectionStrings>

But when i type http://localhost/WebSetup1/Firstpage.aspx

It will display a page..

But when i click on page that contains connection with the database it is not shown or executed..

It will give error message like Login Failed to KARAN\ASPNET..
but if i run from Visual studio no problem at all..Its working properly..

I have installed sql server in my pC.

In short : database connection is not established.. or data is not fetched from the database..

Please help me ....
Thanks in Advance.

regards
karan

Posted 22-May-11 22:23pm

karan joshua

Add a Solution

3 solutions

Solution 2

Are you install IIS before install VS.Net or after that?If you install after that then it create problem like that.

Posted 22-May-11 22:40pm

vineesha

Comments

karan joshua 23-May-11 4:48am

ya i have installed after installing VS.net

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)

**R. Giskard Reventlov** · Accepted Answer · 2011-05-22T22:33:00

Solution 1

It's most likely that the permissions are incorrect. This will help[^] to get you started.

Posted 22-May-11 22:33pm

R. Giskard Reventlov

Comments

karan joshua 23-May-11 5:07am

thank u for your solution sir... I got the problem cleared....

Prerak Patel · Accepted Answer · 2011-05-22T22:41:00

Solution 3

More to digital man's answer, you can use different connection string with SQL user credentials, or give ASPNET user required rights on you database.
http://www.dnzone.com/go?503[^]

Posted 22-May-11 22:41pm

Prerak Patel

Comments

karan joshua 23-May-11 5:04am

good job sir... u have provided with the essential link...

Finally i got it... your tutorial was very helpful...

struggling for 5 days with this problem...
Thank u sir...

THANK U..THANK U..THANK U..THANK U..THANK U..THANK U..THANK U..

THANK U..THANK U..THANK U..THANK U..THANK U..THANK U..

THANK U..

THANK U..

THANK U..

Prerak Patel 23-May-11 5:05am

You are most welcome.