SQL Databse not connecting on iis 7.5

Question

1.00/5 (1 vote)

See more:

, +

hello ,

am hosting web application on iis 7.5 and it work fine , but i cant access the database from sql , am using this connection string in my web.config

, what should i do else ? , the web application require login which is in database and i cant access to it , please help

XML

<remove name="LocalSqlServer" />
    <add name="LocalSqlServer" connectionString="Data Source=Ahmad-PC\SQLExpress;Initial Catalog=abad;Integrated Security=True" 

providerName="System.Data.SqlClient" />
    <add name="ABADConnectionString" connectionString="Data Source=Ahmad-PC\SQLExpress;Initial Catalog=abad;Integrated Security=True" 

providerName="System.Data.SqlClient" />
    <add name="ABADConnectionString1" connectionString="Data Source=Ahmad-PC\SQLExpress;Initial Catalog=abad;Integrated Security=True" 

providerName="System.Data.SqlClient" />

am using windows 7 home premium 64 bit , Microsoft SQL Server 2012 and IIS 7.5

Posted 28-Oct-15 8:11am

Member 11558177

Updated 28-Oct-15 8:14am

v2

Add a Solution

2 solutions

Solution 3

From your comment you pretty much have your answer.

If SQL server is running on you local development box, then chances are good that your server will not have access to it. What you need to look into is either using a separate SQL server that you host can access or look at installing SQL Express on the host where IIS is installed.

Posted 30-Oct-15 5:09am

AnvilRanger

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)

**Zoltán Zörgő** · Accepted Answer · 2015-10-28T08:32:00

Wait a second.
1) IIS does not connect to any RDBMS, except for storing session state - it is only a setting you can use in your application
2) SQL Express does not enable TCP/IP connector by default, you need to enable it[^].
3) For this to work, you need to have specific port level access[^] between the server running IIS and SQL Server - if they do not run on the same machine
4) In IIS applications run under application pools, that impersonate either a dedicated pool user or the authenticated client user (if NTLM or Kerberos is used). Kerberos is needed for delegation - if IIS needs to pass the client token to third party machine (running SQL server for example) delegation, thus Kerberos is needed. Integrated security authentication means delegation if the application is running under client user identity.
5) Either dedicated pool identity or client identity - integrated security implies that this user has to have access to SQL Server and the database of course.

So... check these...