Greetings,
I have a new installation and I am trying to setup tape backups using a SQL database agent. During the install, I was never prompted to setup an "sa" password, so I assumed POS was using it's own defaults.
Is there a "default" account that is used, or can be used, to allow the backup software to backup the database live, rather than scripting SQL to do the same thing?
Cheers, Rob
I have a new installation and I am trying to setup tape backups using a SQL database agent. During the install, I was never prompted to setup an "sa" password, so I assumed POS was using it's own defaults.
Is there a "default" account that is used, or can be used, to allow the backup software to backup the database live, rather than scripting SQL to do the same thing?
Cheers, Rob
You can use a named instance with RMS - just enter "InstanceName\DatabaseName" on the database filed in SO Admin...
You definitely need to use SQL Server authentication though.
Glenn Adams Tiber Creek C> Rob,
Have something to add? Share your thoughts — no account required.
Ask the community — no account required