Creating a backup user/login

• Jake Shelton

  Hall of Fame

  Points: 3109

  More actions

  November 3, 2014 at 12:07 am

  #291634

  Hi all,

  We have a 3rd party backup software that requires an account to access the database files, I can see how to create in the GUI as BackupOperator, but this gives me no option to create a password.

  Would the above be enough to allow access + backup rights? Also, if we need to use a password, where do I enable this?

  Thanks,

  Jake

• spaghettidba

  SSC Guru

  Points: 105732

  More actions

  November 3, 2014 at 2:48 am

  #1756281

  If it's not asking for a password, I suppose you're creating a database user and not a login.

  Use scripts, not the GUI.

  CREATE LOGIN test WITH PASSWORD = 'test'

  USE yourdatabasename;

  CREATE USER test FOR LOGIN test;

  EXEC sp_addrolemember 'db_backupoperator', 'test'

  -- Gianluca Sartori

• Adi Cohn-120898

  SSC-Dedicated

  Points: 33944

  More actions

  November 3, 2014 at 3:02 am

  #1756286

  I think that it could also be that he tried to create a login with windows authentication.

  Adi

  --------------------------------------------------------------
  To know how to ask questions and increase the chances of getting asnwers:
  http://www.sqlservercentral.com/articles/Best+Practices/61537/

  For better answers on performance questions, click on the following...
  http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

• Ed Wagner

  SSC Guru

  Points: 287026

  More actions

  November 3, 2014 at 5:53 am

  #1756304

  For your own sanity, make sure you understand the difference between logins and users. And to echo what Gianluca said, always use scripts. They help you understand what you're doing and also give you more control over what you're doing.

  Tally Tables - Performance Personified
  String Splitting with True Performance
  Best practices on how to ask questions