sql server 2005 hangs when i click user mapping to new user

Answered sql server 2005 hangs when i click user mapping to new user

  • mardi 1 mai 2012 11:39
     
     
    Hi guys i have sql server 2005 i installed before 2 days every thing is ok but when i create user in security for all database then i click user mapping it hangs and frezes and take more time and last not open after this   error reporting of sql server display then when i click to see message tell me found that there are error in two files sqlwb.msdp and appcompat how i solve this proplem please help me
    notes
    user mapping found in
    open ssms
    click databases
    security
    new login
    user mapping
    thanks

Toutes les réponses

  • mardi 1 mai 2012 12:09
     
     

    What happens if you use SQL commands to create the user?


    Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se
  • mercredi 2 mai 2012 09:39
    Modérateur
     
     Traitée

    Hi Ahmedsalah,

    Please read this article and try to map users to a SQL Server login using TSQL:

    http://msdn.microsoft.com/en-us/library/ms174378.aspx

     see what will happen, and post error messages if you received.


    Best Regards,
    Iric
    Please remember to mark the replies as answers if they help and unmark them if they provide no help.