Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2012 Forums
 SQL Server Administration (2012)
 Granting permissions to acces a database from ASP

Author  Topic 

rafael.soteldo
Starting Member

36 Posts

Posted - 2013-02-01 : 11:36:33
How can I grant permissions to log in and access the AdventureWorks database from the IIS?

I'm developing an application in Visual Studio 2010 (Silverlight hosted in the IIS) and I get an error saying that it couldn't open the AdventureWorks databse since login failed for user IIS APPPOOL\ASP .NET 4.0.

Thanks in advance for your time

-------
Rafael Soteldo

rafael.soteldo
Starting Member

36 Posts

Posted - 2013-02-04 : 10:01:23
Found a complete solution, for those interested please see: http://stackoverflow.com/questions/7698286/login-failed-for-user-iis-apppool-asp-net-v4-0

Thanks in advance for your time

-------
Rafael Soteldo
Go to Top of Page
   

- Advertisement -