Forum Discussion

Sergey_Korshuno's avatar
Sergey_Korshuno
Level 4
13 years ago

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: ------...
7.1.x and Earlier
Agent for Microsoft SQL Server
Backup and Recovery
NetBackup
Windows
  • MKT's avatar
    MKT
    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.

Sergey_Korshuno's avatar
Sergey_Korshuno
Level 4
13 years ago

If you are using Windows Authentication mode

Server in mixed mode

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.

I can use "sa" accuont from any other apps, it works.