Installing a MSSQL database in Administrator terminal session, not accessible by another terminal user
Posted on 2013-01-24
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"
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 ...