CODEWITHSUNDEEP
sql-serversecurityiis
birdus
birdus

Reputation: 7504

Database connection works for Cassini, but fails for IIS

I'm connecting to a remote database. The connection works for ASP.NET Development Server, but is failing since I switched to using IIS. Here's my connection string:

<add name="ConnectionString"
    connectionString="Server=SQL-NWSS-048\SHRDDEV01;Database=PESTS;Trusted_Connection=True;" 
    providerName="System.Data.SqlClient" />

Upvotes: 1

Views: 309

Answers (1)

David
David

Reputation: 73594

In Cassini, the web site is running under your account. Since your account has rights to the database, it works, as you're using Windows Integrated security to access the SQL Server. (Trusted Connection=True).

In IIS, unless you configure it differently, it runs under the <Server Name>\Network Service account, which is a local account on that server. Odds are that account doesn't have access to the database.

See How to: Access SQL Server Using Windows Integrated Security

That's relatively difficult compared to using SQL Server authentication instead. I'd recommend using SQL Server authentication, where you pass in a username/password if your situation allows for it. Just be sure to encrypt the connection strings in the web.config.

Upvotes: 3

Related Questions