After MS SQL server was updated to 2005 from 2003, the backup job on Backup exec 10d started to fail because of a logon failure. There are 2 servers, the SQL server and the backup server. Both servers are domain controller. The SQL server is running as Domain Administrator account and Backup exec is also running as Domain Administrator but Backup exec could not connect to SQL server.
Here is the error.
An error occurred while attempting to log in to the following server: "Domain\ServerNAME".
SQL error number: "4818".
SQL error message: "Login failed for user 'Domain\Administrator'.
".
How can we allow Administrator to access SQL server? I hope someone can help us.
Thank you.
Start Free Trial