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 |
|
mike123
Master Smack Fu Yak Hacker
1462 Posts |
 Posted - 2009-01-16 : 11:16:41
|
| Hi,I am connecting to my remote server via SSMS, however after I succesfully connect I can't see any databases. I get an error that I couldnt succesfully connect to the first alphabetical DB on the system.I am able to succesfully send commands by creating new queries, and TEST CONNECTIOn works, I just can't see any objects. My default database for the login is set correctly.Any ideas ?Thanks again!mike123 |
|
|
mike123
Master Smack Fu Yak Hacker
1462 Posts |
Posted - 2009-01-16 : 11:19:23
|
| Error Msg : The server principal "mylogin" is not able to access the database "idontwanttologinhereanwyays" under the current security context. (microsoft SQL srever, error: 916)Thanks :)mike123 |
 |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2009-01-16 : 12:22:34
|
| does a valid login exist for mylogin account in database "idontwanttologinhereanwyays" |
|
|
|
|
|
|
connecting to remote server via SSMS