Reason: this user 'NT AUTHORITY\NETWORK SERVICE' does not have read access to DW_PROD
Solution: Connect to the server via SSMS. in Security section, create this user if doesn’t exist.
Then go to login properties –> User Mapping and choose the database you want to grant permission, grant db_datareader role
No comments:
Post a Comment