Comments
Sort by recent activity
petey wrote:
When the SQL Backup Agent service starts, it needs to grant rights to some internal objects, to both it's startup user and the associated SQL Server service's startup user.
Try setting the SQL Backup Agent service user to LocalSystem (assuming LocalSystem has the SQL Server sysadmin fixed server role). For the SQL Server service user, is it started using a domain user? Is the full name of the domain user i.e. DomainName\UserName ?
I've tried local system to no avail
I've tried DOMAINNAME\Username (3 different users).
I've tried .\Username (3 different users)
All come up with the same error.
SQLSERVER is started by .\Administrator (I verified this). / comments
petey wrote:
When the SQL Backup Agent service starts, it needs to grant rights to some internal objects, to both it's startup user and the associated SQL Server service's startup user.
Try sett...
petey wrote:
For the SQL Server service, if you can change it, could you pls try using <COMPUTERNAME>\Administrator instead of .\Administrator?
I could, yes. But I cannot restart the service as people are connected.
Ok, I changed both the SQLSERVER and the SQLBACKUP program to DOMAIN\Administrator and it works (without a sql server restart).
weird. / comments
petey wrote:
For the SQL Server service, if you can change it, could you pls try using <COMPUTERNAME>\Administrator instead of .\Administrator?
I could, yes. But I cannot restart the service ...
Brian Donahue wrote:
Hello,
This is a fairly standard error. SQL Backup Agent is set to log on as a domain account and the domain is unavailable to verify the login. There is either a network problem or the account has been deleted from the domain or is invalid.
You can try changing the account that the SQL Backup Agent service runs under. Possibly re-entering the account intormation into the LogOn tab may help if the account had been deleted and recreated.
This is installed directly on my SBS2k3 server. So there is certainly no network issue involved here.
I've tried three different login users (admin, myself and another user) that all have rights as administrator on this machine.
I've not found a solution yet. / comments
Brian Donahue wrote:
Hello,
This is a fairly standard error. SQL Backup Agent is set to log on as a domain account and the domain is unavailable to verify the login. There is either a network pr...
Still no luck. Googling yields no extra results other than the thread I found here. / comments
Still no luck. Googling yields no extra results other than the thread I found here.
Hi. I am using 5.3.8.2 and it seems to support synonyms ok. [image] / comments
Hi. I am using 5.3.8.2 and it seems to support synonyms ok.