CODEWITHSUNDEEP
asp.netsql-server
lapots
lapots

Reputation: 13395

troubles with connection to database

When I start site from visual studio(F5) - it works normal in browser. But when I start it from IIS Manager - it always shows standart IIS page with languages.

Site uses database DB.mdf. In web config connection string is

Data source=.\MSSQLSERVER2;Database=DB;Integrated security=true

The database is in App_Data.

In IIS manager in ASP.NET->Connectionstring for my site I've create new connectionstring - same as the connection string in web.config with name CName.

Where is a problem? The path to my site is the path to catalog which contains App_Data catalog.

Upvotes: 0

Views: 73

Answers (1)

Shawn Steward
Shawn Steward

Reputation: 6825

When running in IIS, it uses the security context of the Application Pool it's running under. You will either need to use a different user on your App Pool Identity, or grant rights to your resources to the current App Pool user.

See this article on how to setup the App Pool identities.

Upvotes: 1

Related Questions