Sergey_Korshuno
13 years agoLevel 4
MS SQL Agent: Application connection failed for servername\.
Hi
We have deployed new server:
OS: Windows Server 2008 R2 x64
DB: MS SQL Server 2008 R2 x64 Express
But netbackup SQL Agent can't connect to the instance with correct sa account:
------...
- 13 years ago
If you are using Windows Authentication mode,SQL Server ignores the user ID and password
that you provided in the SQL Server connection properties dialog box. The 'sa' account becomes irrelevant as it is not being used. What is being used is the account you logged into the box with. Check that account in SQL and give it 'sa' rights and the connection should be successful.