Connection string to connect to Database from Web Service

Question

4.00/5 (1 vote)

See more:

This is my connection string, which the web service (hosted in IIS) uses to connect to database

XML

<add name="AdventureWorksEntities"connectionString="metadata=.\AdventureWorks.csdl|.\AdventureWorks.ssdl|.\AdventureWorks.msl;
provider=System.Data.SqlClient;provider connection string='Data Source=TestMachine;Initial Catalog=AdventureWorks;
Integrated Security=True;Connection Timeout=60;multipleactiveresultsets=true'" providerName="System.Data.EntityClient" />

When I try to access the site I am getting an exception: Login Failed for user MyDomain\TestMachine$.

Why is IIS trying to use TestMachine to connect and not my user account (e.g MyDomain\TestUser) ? How do I specify it to use the context of the user that made the request ?

Posted 30-Oct-12 12:54pm

Frank__Q

Add a Solution

2 solutions

Add a Solution

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

Loki · Answer 1 · 2012-10-30T13:03:00

Solution 1

You have to turn on Impersonation in the web.config. This will make IIS use your windows account when connecting to SQL

<system.web>
<identity impersonate="true" />
....</system.web>

Posted 30-Oct-12 13:03pm

Loki

Updated 30-Oct-12 13:05pm

v3

Comments

Frank__Q 31-Oct-12 12:52pm

If I do that then I cannot access the site remotely. Accessing the site from local IIS server machine will work but not remotely.

Loki · Answer 2 · 2012-10-31T10:21:00

Solution 2

It will work if you use Windows Authentication, even remotely.

Posted 31-Oct-12 10:21am

Loki

Connection string to connect to Database from Web Service

2 solutions

Solution 1

Solution 2

Add your solution here

Preview 0

Connection string to connect to Database from Web Service

2 solutions

Solution 1

Solution 2

Add your solution here

Preview 0

Existing Members

...or Join us