Solved

Trusted User for SQL 2005 Database

Posted on 2014-02-11
2
355 Views
Last Modified: 2014-02-11
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
Comment
Question by:tparus
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 75

Expert Comment

by:Aneesh Retnakaran
ID: 39850768
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
 
LVL 15

Accepted Solution

by:
Deepak Chauhan earned 500 total points
ID: 39850930
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

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article runs through the process of deploying a single EXE application selectively to a group of user.
Did you know that more than 4 billion data records have been recorded as lost or stolen since 2013? It was a staggering number brought to our attention during last week’s ManageEngine webinar, where attendees received a comprehensive look at the ma…
This Micro Tutorial hows how you can integrate  Mac OSX to a Windows Active Directory Domain. Apple has made it easy to allow users to bind their macs to a windows domain with relative ease. The following video show how to bind OSX Mavericks to …
Microsoft Active Directory, the widely used IT infrastructure, is known for its high risk of credential theft. The best way to test your Active Directory’s vulnerabilities to pass-the-ticket, pass-the-hash, privilege escalation, and malware attacks …

734 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question