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 ...
Rupert EghardtProgrammerAsked:
Who is Participating?
 
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.

All Courses

From novice to tech pro — start learning today.