May 13, 2008 at 5:10 am
Using a box Ive got , sql 2000, mixed mode security , allow remote connections etc unless I grant a windows user sa rights it can connect to the server but cant see any databases
If you give it public and datareader/writer to a db it still cant see it
Im embarressed to ask as its bound to be simple but there you go !
~si
May 14, 2008 at 8:11 am
You must grant individual users access to a particualar database. Logged in as sa, from Enterprise Manager, go to Security - Logins. Right click the user you want to give priviledges to, select Properties. On the Database Access tab, check the databases you want them to be able to see. You can also assign them to a role within the database to give them access to the data within the database. The role db_datareader would give them permission to select from (read) any table in the database.
Steve
May 14, 2008 at 8:22 am
sblock (5/14/2008)
You must grant individual users access to a particualar database. Logged in as sa, from Enterprise Manager, go to Security - Logins. Right click the user you want to give priviledges to, select Properties. On the Database Access tab, check the databases you want them to be able to see. You can also assign them to a role within the database to give them access to the data within the database. The role db_datareader would give them permission to select from (read) any table in the database.Steve
Hi Steve
Yes I'd done those steps originally, added myself as a windows user etc when I first hit this problem with all the above , and still under databases it says no items
thanks Simon
May 14, 2008 at 8:26 am
p.s interestingly I can see the database and tables in query analyser in the tree view and by querying them , just not via EM
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply