cannot access database

[vj]

Hi everyone,

I have windows server 2008 R2 64bit on server with Sql Server 2008 R2 Management Studio (SQL Express) ...

I have created 3 users on the server, if i log in using Administrator Account ... iam able to open up any SQL-Server Database from the Management Studio ... but when i log in using any of the other 2 users iam not able to open up the database in the Management Studio .... even though i'v added the other 2 users in the administrators group . can anyone tell me .. what are the settings so that the other 2 users can also open up and view databases using the Management Studio.

thankx
Vijay

 

[johnherman]

I seem to remember a checkbox "Alias to dbo". (database owner).

==================================
adaptive uber info galaxies (bigger, better, faster than agile big data clouds)