login problem

• madhu-686862

  SSChampion

  Points: 10707

  More actions

  April 10, 2008 at 9:22 am

  #154275

  hi,

  I created a login n user, i used mixed mode authintication.

  when I tried to login with this login its giving me this error

  Create failed for User 'reddy'. (Microsoft.SqlServer.Smo)

  For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=9.00.3042.00&EvtSrc=Microsoft.SqlServer.Management.Smo.ExceptionTemplates.FailedOperationExceptionText&EvtID=Create+User&LinkId=20476

  ------------------------------

  ADDITIONAL INFORMATION:

  An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)

  ------------------------------

  The login already has an account under a different user name. (Microsoft SQL Server, Error: 15063)

  For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=09.00.1399&EvtSrc=MSSQLServer&EvtID=15063&LinkId=20476

  wat would be the possible reason?

  thanx

• K. Brian Kelley

  SSC Guru

  Points: 114642

  More actions

  April 12, 2008 at 8:44 am

  #801801

  It doesn't look like the login is failing. Are you running a script that uses SMO?

  K. Brian Kelley
  @kbriankelley