• 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 EghardtAuthor Commented:
We added the user to the domain administrators group and the problem was resolved.

Thanks for the help
0
 
Rupert EghardtAuthor Commented:
We added the user to the domain administrators group and the problem was resolved.
0

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

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