Sql Server - Cannot Expand Database In Object Explorer
So you can remotely connect to the server and see the restored database but when you click to expand it and view the tables it throws an error. An error like not available in security context or such other such helpful information. The problem in my case is that the user existed, and it had all the proper security. I ran the change users proc on the user...or so I thought. Actually on the upper left somehow the database selected was master. Good thing for co workers that can point out my mistake. So, my fault I guess, although these orphaned users are strange... EXEC sp_change_users_login 'Auto_Fix', ' user ' http://dbadiaries.com/using-sp_change_users_login-to-fix-sql-server-orphaned-users