Login Creation Problem in SQL SERVER 2005

• nikhil.verma

  SSCrazy

  Points: 2603

  More actions

  January 14, 2010 at 3:16 am

  #156577

  Hello All,

  I am facing a problem , while i tried to create the login in SQL SERVER 2005 , it is always throwing me error message :

  Create failed for login xxxxx

  Invalid object name admin..ddl_log (Microsoft SQL Server : Error 208)

  In the above mentioned error message , admin is -> dbname , I am not able to understand whenver i am trying to create the login with any default database i am geting this above error message . I can create the user and map it with the existing logins . But not able to create the new login for any database.

  Is it possible that there is any DDL Trigger in place which is not allowing to create Logins. Also if this is the case then how to check it ???

  Any suggestions would be of great help.

  Thanks

• MANU-J.

  SSC-Dedicated

  Points: 31126

  More actions

  January 14, 2010 at 2:24 pm

  #1103962

  Check the output of select * from sys.server_triggers

  Manu