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,
BeanSmart website is not affiliated with any of the manufacturers or service providers discussed here. All logos and trade names are the property of their respective owners.