Solved

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

Posted on 2013-01-24
3
214 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
  • 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

Do email signature updates give you a headache?

Do you feel like you are constantly making changes to email signatures? Are the images not formatting how you want them to? Want high-quality HTML signatures on all devices, including on mobiles and Macs? Then, let Exclaimer solve all your email signature problems today.

Join & Write a Comment

Suggested Solutions

Sometimes drives fill up and we don't know why.  If you don't understand the best way to use the tools available, you may end up being stumped as to why your drive says it's not full when you have no space left!  Here's how you can find out...
This article demonstrates how to create a simple responsive confirmation dialog with Ok and Cancel buttons using HTML, CSS, jQuery and Promises
This tutorial will show how to push an installation of Backup Exec to an additional server in both 2012 and 2014 versions of the software. Click on the Backup Exec button in the upper left corner. From here, select Installation and Licensing, then I…
This tutorial will give a an overview on how to deploy remote agents in Backup Exec 2012 to new servers. Click on the Backup Exec button in the upper left corner. From here, are global settings for the application such as connecting to a remote Back…

706 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

Need Help in Real-Time?

Connect with top rated Experts

16 Experts available now in Live!

Get 1:1 Help Now