Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
ivan.slabiak
Starting Member
1 Post |
 Posted - 2009-04-08 : 11:41:01
|
| Hi all ! I´m just starting to work with SQL with no previous experience, so i will have questions .. :-)I have created a new database in sql 2005.I created a user to connect to the database with, giving it dbreader rights.When I connect to the server, with SQL management studio, with the user I created, I can´t see anything but Systemdatabases and Database snapshots. What am I doing wrong?? User has:Server role: publicUser mapping: db_datareader and publicWhat to do ??// Ivan |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2009-04-08 : 12:31:25
|
| Right-click the Databases node in Management Studio and choose "Refresh". If the database still doesn't display, close Management Studio and reconnect. |
 |
|
|
jackv
Master Smack Fu Yak Hacker
2179 Posts |
Posted - 2009-04-09 : 07:41:51
|
| If you still can't see it after the suggestions above . Logon as the admin , and do a "select * from sys.databases" - can you see the db you created listed?Jack Vamvas--------------------http://www.ITjobfeed.com |
|
|
|
|
|
|
<invisible database ?