Tim
asked on
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?
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
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.