tags:

views:

122

answers:

0
Q: 

Which user needs access to SQL Server 2008 R2 db using IIS7.5 and .NET 4.0?

I am running a .NET 4.0 WCF service that attempts to access a SQL Server 2008 R2 database.

System.Data.EntityException: The underlying provider failed on Open. ---> System.Data.SqlClient.SqlException: Login failed for user 'IIS APPPOOL\ASP.NET v4.0'.

In previous versions of SQL Server, I would make the [computerName]\IUSR_[computerName] and [computerName]\IWAN_[computerName] the db_Owner.

I tried to add a login for 'IIS APPPOOL\ASP.NET v4.0' through Management Studio but it would not let me.

Any recommendations? Thoughts?

related questions

Subsonic Vs NHibernate
How to check For File Lock in C# ?
Is nAnt still supported and suitable for .net 3.5/VS2008?
Limit size of Queue<T> in .NET?
Viewstate invalid when using Safari
Free OCR library
Unhandled Exception Handler in .NET 1.1
Localising date format descriptors
Get a new object instance from a Type in C#
VFP .NET OLEdb provider does not work in Win 64-Bits. Help
.NET Testing Framework Advice
Embedded Database for .net that can run off a network
Automatically update version number
Homegrown consumption of web services
How do you migrate a large app from VB6 to VB .net ?
.NET Migrations Engine
Adding Scripting functionality to .NET applications
SQLite and XSD
Floating Point Number parsing: Is there a Catch All algorithm?
How do I programmatically create a PDF in my .NET application?
How do I sync the SVN revision number with my ASP.NET web site?
XSD DataSets and ignoring foreign keys
Anatomy of a "Memory Leak"
Reliable Timer in a Console Application
How do I calculate relative time?