MS SQL server Error : 916
这哥们真是个好同志啊！http://www.xheo.com/Blog/post/Server-user-e28098ABCe28099-is-not-a-valid-user-in-database-e28098XYZe28099-when-using-Management-Studio-2008.aspx
Serveruser ‘ABC’ is not a valid user in database ‘XYZ’ when using Management Studio 2008
http://www.xheo.com/Blog/themes/indigo/img/timeicon.gif二月 2, 2009 12:48 by http://www.xheo.com/Blog/themes/indigo/img/author.gifPaul Alexanderhttp://www.xheo.com/Blog/themes/indigo/img/comments.gif评论 (2)
I ran into the following issue when I first installed SQL Server 2008on my dev machine a while back.
http://www.xheo.com/Blog/image.axd?picture=usernotvalidindatabase.gif
I spent a lot of time searching for a fix but kept coming across unrelated posts. I did finally come across a blog entry that covered theresolution but I can’t seem to find it again. Anyhow, I vaguely remembered some of the steps and finally worked through it again. So I thought I’d reproduce it here in case anyone else has the same issue (IfI can find the original blog post I’ll link back to it).
The fix is actually pretty simple but to be honest I’m not a SQL guy so explaining why has to be left for those that are more familiar with the tools.
[*]Open Microsoft SQL Server Management Studio
[*]Open a connection to the server in question. You may get the error immediately…or after a few seconds. Just ignore it and continue these instructions.
[*]Make sure the Object Explorer Detailsview is open (F7).
[*]Expand the root connection node and select the Databasesnode.
http://www.xheo.com/Blog/image.axd?picture=databasesselected.gif
[*]You should definitely see the error now if you haven’t already. In the Object Explorer Details view you should not see an empty table including the columns Name, Policy Health State, Recovery Model, Compatibility Level, Collationand Owner. The Collationcolumn is the key.
http://www.xheo.com/Blog/image.axd?picture=collationcolumn_thumb.png
[*]Right click on the table header and unselect Collation.
[*]Select Refresh. This time the databases are listed correctly.
页:
[1]