Improve company productivity with a Business Account.Sign Up

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

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

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
Rupert Eghardt
Asked:
Rupert Eghardt
  • 2
2 Solutions
 
Rupert EghardtProgrammerAuthor Commented:
We added the user to the domain administrators group and the problem was resolved.

Thanks for the help
0
 
Rupert EghardtProgrammerAuthor Commented:
We added the user to the domain administrators group and the problem was resolved.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Simplify Active Directory Administration

Administration of Active Directory does not have to be hard.  Too often what should be a simple task is made more difficult than it needs to be.The solution?  Hyena from SystemTools Software.  With ease-of-use as well as powerful importing and bulk updating capabilities.

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