Cannot start SQL Backup Agent

• 
  What are the service startup accounts for the SQL Backup service and the related SQL Server service?

  petey July 12, 2006 20:52

  - 0 +
• 
  using account named sqladmin. same as other sql services.

  angelgar July 12, 2006 20:54

  - 0 +
• 
  Sent you a private message asking for more details. Did you try the steps in that message?

  petey July 12, 2006 22:05

  - 0 +
• 
  Yes I have sent you the txt file.
  
  thanks

  angelgar July 13, 2006 09:54

  - 0 +
• 
  I was able to activate the license, so i thought, by using the productactivation.exe. The GUI is still showing "Expired Trial"

  angelgar July 13, 2006 10:48

  - 0 +
• 
  The error was traced to the naming of the service startup users for both SQL Server and the SQL Backup Agent service. Using .\sqladmin caused SQL Backup to resolve to the local computer user, instead of the domain user.

  petey July 13, 2006 12:59

  - 0 +
• 

  petey wrote:

  The error was traced to the naming of the service startup users for both SQL Server and the SQL Backup Agent service. Using .\sqladmin caused SQL Backup to resolve to the local computer user, instead of the domain user.

  
  So if my server is running agent under ./myuser should I use the same when I install/upgrade server components or can I use Local System?

  Kman July 14, 2006 19:48

  - 0 +
• 
  You can use any user that has the SQL Server sysadmin fixed server role, if you want the service application to connect to SQL Server using Windows authentication. You can use any other user if you want the service application to connect using SQL authentication.
  
  It is the naming of the user that SQL Backup had problems with in this case. Using .\myuser causes SQL Backup to try to look for a myuser account on the local machine, when it was intended to be a domain user.

  petey July 15, 2006 05:08

  - 0 +

Add comment

Please sign in to leave a comment.