September 17, 2009 at 9:43 am
hi
i have a problem can't able to view the database to a user who is a db owner.
morning i did database encryption to a test database.
after some time, i have created one user and i gave DB-OWNER access to another database i.e test1 database.
i can able to login with this new user but i cant able to view the test1 database using SSMS2008.
i googled about this one, and i found out one thing
cleck on database then F7 then uncheck the collation.
i did this one but still i have the problem
can any one help me on this one
TX
Rock..
September 18, 2009 at 3:23 am
any idea???
September 18, 2009 at 3:34 am
rockingadmin (9/17/2009)
hii have a problem can't able to view the database to a user who is a db owner.
morning i did database encryption to a test database.
after some time, i have created one user and i gave DB-OWNER access to another database i.e test1 database.
i can able to login with this new user but i cant able to view the test1 database using SSMS2008.
i googled about this one, and i found out one thing
cleck on database then F7 then uncheck the collation.
i did this one but still i have the problem
can any one help me on this one
TX
Rock..
We can try, Can you give more details on what you done and what you are trying to do now.
what did you do exactly, concerning database encryption.
do you have trouble viewing the database on which you done this encryption. and when you say view, what exactly are you trying to see.
--------------------------------------------------------------------------------------
[highlight]Recommended Articles on How to help us help you and[/highlight]
[highlight]solve commonly asked questions[/highlight]
Forum Etiquette: How to post data/code on a forum to get the best help by Jeff Moden[/url]
Managing Transaction Logs by Gail Shaw[/url]
How to post Performance problems by Gail Shaw[/url]
Help, my database is corrupt. Now what? by Gail Shaw[/url]
September 18, 2009 at 4:03 am
September 18, 2009 at 7:52 am
i disabled the encryption to the test database.
after that also same err
September 18, 2009 at 7:59 am
Can you post the error that you are seeing
--------------------------------------------------------------------------------------
[highlight]Recommended Articles on How to help us help you and[/highlight]
[highlight]solve commonly asked questions[/highlight]
Forum Etiquette: How to post data/code on a forum to get the best help by Jeff Moden[/url]
Managing Transaction Logs by Gail Shaw[/url]
How to post Performance problems by Gail Shaw[/url]
Help, my database is corrupt. Now what? by Gail Shaw[/url]
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply