Database User -DBO has no Login

• mike.tavares

  SSC Veteran

  Points: 224

  More actions

  June 14, 2011 at 2:52 pm

  #239916

  While setting up replication i realized one of my databases had a slight issue. the DBO user on that DB didn't have an associated login. As a result i can not configure replication ... see image.. Any suggestions

  

• JeremyE

  SSCoach

  Points: 16201

  More actions

  June 14, 2011 at 3:13 pm

  #1338685

  Try:

  EXEC sp_changedbowner 'sa'

• mike.tavares

  SSC Veteran

  Points: 224

  More actions

  June 15, 2011 at 6:58 am

  #1338934

  Thank you