Localhost connecting database problem

Question

0.00/5 (No votes)

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..

I have installed my project ...

my web.config contains the following connection string:

XML

<appSettings/>
    <connectionStrings>
  <add name="conStr" connectionString="DATABASE=CLINICAL;Integrated Security=SSPI;AttachDBFilename=|DataDirectory|CLINICAL.mdf;User Instance=true"
   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.. when i do click on insert button...

I have installed sql server in my pC.
In short : database connection is not established..

Please help me in this regard.
Thanks in Advance.
regards
karan

Posted 20-May-11 20:11pm

karan joshua

Updated 20-May-11 20:46pm

Ramalinga Koushik

v2

Add a Solution

Comments

Mohd Wasif 21-May-11 2:41am

You have not placed server name in this connection string

karan joshua 21-May-11 4:27am

still not working

Mohd Wasif 21-May-11 2:42am

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)

Mohd Wasif · Answer 1 · 2011-05-20T20:43:00

Solution 1

you can make connection string as below

<connectionStrings>
  <add name="conn" connectionString="Data Source=servername;database=databasename; integrated security=true" />

 </connectionStrings>

Posted 20-May-11 20:43pm

Mohd Wasif

Updated 20-May-11 20:47pm

v3

Comments

karan joshua 21-May-11 4:06am

It will still give exception like:Login Failed to KARAN\ASPNET