Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 369
  • Last Modified:

Trusted User for SQL 2005 Database

I am trying to create a user that has the ability to use the database as a trusted connection. My server is currently sent to Windows and SQL authentication. I have the user sign on using Windows Authentication to the ERP system that connects to the SQL database. I have a Crystal Report that I have written that accesses a view I have created on the SQL database but when I use connect using Trusted Connection it tells me I do not have permission to access the database. What role or should I use to give read-only access to the user?
0
Tim
Asked:
Tim
1 Solution
 
Aneesh RetnakaranDatabase AdministratorCommented:
You should add that user in the database as a read only user; probably you created the login but missed to create the user under that database -> security -> user  section
0
 
Deepak ChauhanSQL Server DBACommented:
First map the login with concerning database and assign the “db_datareader ” role to that user in the database. Please note , Member of the “db_datareader ” role can only read data from all user tables.
0

Featured Post

Has Powershell sent you back into the Stone Age?

If managing Active Directory using Windows Powershell® is making you feel like you stepped back in time, you are not alone.  For nearly 20 years, AD admins around the world have used one tool for day-to-day AD management: Hyena. Discover why.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now