Hello All,

I have setup TDP on server 2008 R2 sql version as well 2008 all has been setup correctly but when I am trying to backup it is throwing an error not able to understand from where I start troubleshooting.

Error- 10/16/2017 06:01:46 ACO5424E Could not connect to SQL server; SQL server returned:
10/16/2017 06:01:46 Failed to connect to server .
10/16/2017 06:01:46 A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server) (HRESULT:0x80131501)

What I am guessing is SQL server name and register node name is different.

Prem

Hello Prem,

There is no relation with SQL name and node name. Do you kow the instance name of your MSSQL database? You can  find this name at SQL management studio or check the name in Windows service.

ie (looking at Windows Service):

• SQL Server Agent (MSSQLSERVER): This is the default instance
• SQL Server (TEST): The instance name is TEST

After that, change the parameter "SQLSERVer" in tdpsql.cfg configuration file. 

ie:

• SQLSERVer   HOSTNAME:
• Use it for default instance
• SQLSERVer HOSTNAME\TEST
• Use it for TEST instance.

I hope this can help you.

Thanks!

Marcel Sampaio Tubini

Partner IT Consultoria em Serviços

11 3636-8989 / 11 99429-7714
marcel@partner-it.com.br

https://goo.gl/3B3UZi

Hi Marcel,

Thank you for the help I have updated this in cfg file as below, earlier it use to system hostname in the agentnode, i have given proxy job authorization to node which is from system host name against the sql virtual node, will it work before applying into production i want to double sure, I have a confusion how proxy job will work now.

LOCALDSMAgentnode GD02MSSQLSERVER
BACKUPMETHod vss
LASTPRUNEDate     10/18/2017 10:05:51

Hi Marcel,

I tried but still same error attaching the snapshot of TDP how does it look by name. and below node will do proxy job.

Target Node                     Agent Node                  

DCRSPLGD02_SQL      DCRSPLGD02
DCRSPLGD01_SQL      DCRSPLGD01

Thanks

Prem

Hi Guys,

Any suggestion I am sure name is the issue but not able to figure out in cfg what should I enter and which node I should register for doing proxy job for virtual sql node.

Thanks

Prem

Thank you all now it is been solved.

Thanks

Prem