Sign in
 
HomeLibraryLearnDownloadsTroubleshootingCommunityForums
SQL Server Developer Center >
> 
> 
SSMS 2008 R2 hangs when looking at user mappings

Answered SSMS 2008 R2 hangs when looking at user mappings

  • Thursday, February 28, 2013 11:37 AM
     
     
    Sign In to Vote
    0

    Hi,

    This problem occured today, when we open up a user account through SSMS

    security>logins>accountname & click on user mappings the window hangs & SSMS needs to be restarted. I have checked and the user accounts are not orphaned. As we had created some new users on the instance today I've checked and the problem occurs on both new & pre existing ID's. Additionally it effects both SQL accounts and Active directory accounts.

    We have 2 instances on this server, this issue only occurs on one of them.

    Regards

     

All Replies

  • Thursday, February 28, 2013 4:53 PM
     
     
    Sign In to Vote
    0

    How many databases do you have? And are some or many of the databases closed because they are set to AUTOCLOSE? To complete the grid of databases, SQL Server has to open each database, and query sys.database_principals to see if the login is mapped to a user account. This can take a while if there are many databases, or if the databases were closed, and must be opened before querying.

    Yeah. This is not a great system. It has been around for decades, and was created when people only had a couple of databases.

    Or... you have some other problem.

    Rick Byham, Microsoft, SQL Server Books Online, Implies no warranty

     
  • Friday, March 01, 2013 9:33 AM
     
     
    Sign In to Vote
    0

    Hi,

    There are 17 databases in total, they all have the AUTOCLOSE setting set to false. I've tried using different SSMS console from other servers & PC's and the issue occurs on all of them.

     
  • Friday, March 01, 2013 3:11 PM
     
     
    Sign In to Vote
    0

    Hi,

    May be something wrong with the mapping you have created. Have you tried remove these users from the database and map to the login again? 

    Cheers

     
  • Friday, March 01, 2013 5:44 PM
     
     
    Sign In to Vote
    0

    Same performance when logged in as a different login? (Trying to remove permission issues related to one login.)

    What about when login in to SSMS installed on the server? (Trying to remove the possibility of network issues.)

    Anything interesting in the SQL Server error log or Windows Event log?

    Rick Byham, Microsoft, SQL Server Books Online, Implies no warranty

     
  • Wednesday, March 06, 2013 9:49 AM
     
     Answered
    Sign In to Vote
    0

    Hi,

    This turned out to be a a firewall issue, we have 2 domains here & the server was unable to communicate correctly to one of them. This meant we could not add new users from that domain but exisiting user accounts were ok. Once this was fixed everyhting went back to normal.

    TL:DR - the LSA over RPC communication was blocked