Created a 'datareader' user linked to Windows AD to embed in SSRS reports; and user has authentication issues

1 vote

1 answer

59 views

sql-server security users active-directory

                          I am attempting to add a Windows AD User account in order to embed it in SSRS reports for org wide reports.

Using SSMS (with \\Administrator access):

 - Server Level:
   - Created the account on SQL Server > Security
   - Logins: General (Windows Authentication)
   - Default Database: \
   - Server Roles: Public
   - User Mapping: \ (selected)
   - Status:
     - Connect: Grant
     - Login: Enabled

 - Database Level:
   - Membership: db_datareader
                        

Asked by S M (11 rep)

Jun 3, 2025, 01:44 PM
Last activity: Jun 4, 2025, 09:57 AM

Created a 'datareader' user linked to Windows AD to embed in SSRS reports; and user has authentication issues

Related Questions