The login already has an account under a different user name.The login already has an

• Ravi-347590

  SSC Enthusiast

  Points: 133

  More actions

  August 31, 2006 at 6:37 am

  #172341

  Hi All

  While execuitng following stored procedure i am getting error.

  exec sp_changegroup 'awsadm','awsadmin'

  go

  Error in exec: ODBCret=-1

     Msg: [Microsoft][ODBC SQL Server Driver][SQL Server]The login already has an account under a different user name.The login already has an account under a different user name.

  Pls tell me the reason of this error.

  Thanks

  Ravi Shankar

   

• Michelle-164472

  SSCommitted

  Points: 1715

  More actions

  September 1, 2006 at 10:27 am

  #658087

  Use sp_helpgroup to see who are already members of the group...

  use dbname;

  sp_helpgroup (list all groups\roles that are defined in the database)

  sp_helpgroup 'awsadm' (list info about the MEMBERS in the that group)

  Hope this helps...Michelle