Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

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

SQL Server 2008 R2

I have set up a user on a server that we will be using for GP 2010.  I thought I had set him up correctly but he is not able to view the queries and a specifi row on the screen.  The row is circled in the attachment.
EE-SQL.docx
0
pstre
Asked:
pstre
1 Solution
 
urthrilledCommented:
The row on the attachment indicates a database selection, suggesting the user is not mapped to access it.

If you go to Security > Logins and right click on the user and choose Properties, on the left hand pane of the Login Properties window, click on User Mapping and check the database currently not available.
0
 
pstreAuthor Commented:
Ahh...I had them set up correctly.  I thought I would see all of the SQL queries I had written but they are unique to each user.  Once I wrote 1 SQL statement, they could see the row and the database...
0

Featured Post

What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

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