Solved

Installing a MSSQL database in Administrator terminal session, not accessible by another terminal user

Posted on 2013-01-24
3
218 Views
Last Modified: 2013-02-16
Hi Guys,

We've installed / setup a SQL database in a terminal server Administrator session.  From a user session, we are able to see the database, but unable to open the database.  The database is reported to be "invalid"

Message
The database does not appear to be a valid database.
PROBLEM:  The SELECT permission was denied on the object.

However, when we open the database from the Administrator session it works fine.

I surmise the problem is related to user-rights, but I have given the user Full access rights on the MSSQL folder, and still no joy.

any ideas will help ...
0
Comment
Question by:Rupert Eghardt
[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
3 Comments
 
LVL 23

Assisted Solution

by:Ayman Bakr
Ayman Bakr earned 500 total points
ID: 38817502
0
 

Accepted Solution

by:
Rupert Eghardt earned 0 total points
ID: 38875787
We added the user to the domain administrators group and the problem was resolved.

Thanks for the help
0
 

Author Closing Comment

by:Rupert Eghardt
ID: 38896119
We added the user to the domain administrators group and the problem was resolved.
0

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

Restoring deleted objects in Active Directory has been a standard feature in Active Directory for many years, yet some admins may not know what is available.
This article discusses how to implement server side field validation and display customized error messages to the client.
This tutorial will walk an individual through the steps necessary to configure their installation of BackupExec 2012 to use network shared disk space. Verify that the path to the shared storage is valid and that data can be written to that location:…
This tutorial will walk an individual through the steps necessary to join and promote the first Windows Server 2012 domain controller into an Active Directory environment running on Windows Server 2008. Determine the location of the FSMO roles by lo…

737 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