How to make SQL Server work?

A

AcidBat2016-07-07 15:05:50

SQL

AcidBat, 2016-07-07 15:05:50

Windows Server 2012 R2. SQL Server Express 2014. The SQL Server (SQLEXPRESS) service is running. SQL Server 2014 Management Studio perfectly sees that the server is running. I connect in advance created database to the server. Everything is fine, Management Studio sees all the databases.
In Web.config I prescribe the connection:
Does not work, error:
Unable to open database "****" requested by the login. Failed to sign in.
Login failed for user 'IIS APPPOOL\DefaultAppPool'.
I'm already tired. I don't know what to do.

Reply

Answer the question

In order to leave comments, you need to log in

1 answer(s)

S

shagguboy, 2016-07-07
@AcidBat

1) give rights in MS SQL server to the user of the IIS pool
2) change the user on behalf of which the IIS pool works
3) switch to access to the database by login and password