Login failed for user 'IIS APPPOOL\DefaultAppPool' SQl server
Login failed for user 'IIS APPPOOL\DefaultAppPool' SQl server
--sql
CREATE LOGIN [IIS APPPOOL\DefaultAppPool] FROM WINDOWS
GO
--USE Table Name
GO
CREATE USER [IIS APPPOOL\DefaultAppPool] FOR LOGIN [IIS APPPOOL\DefaultAppPool]
GO
EXEC sp_addrolemember 'db_datareader', 'IIS APPPOOL\DefaultAppPool'
GO
EXEC sp_addrolemember 'db_datawriter', 'IIS APPPOOL\DefaultAppPool'
GO
then give permision sql server roles>database Roles>'IIS APPPOOL\DefaultAppPool'>MemberShips
Subscribe to:
Post Comments
(
Atom
)
No comments :
Post a Comment