Hi All ,

I have setup a tdp for sql below are the details of setup all of a sudden it stopped and not able to see database name under protect.

Volume Shadow Copy Service (VSS) Information
--------------------------------------------

ACO5098E Error obtaining VSS information from Local DSMAgent Node: 'dcprcbsdbs01'.
ACO5424E Could not connect to SQL server; SQL server returned:
Failed to connect to server DCPRCBSDBSC1SQL.
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)
The system cannot find the file specified (HRESULT:0x80131501)

sql server -2008 R2

Windows Server 2008 R2

TDP - 7.1.6

One backup also I have tested but now it is showing failed. I have tested this from foreground also here is the error from foreground.

ACO5424E Could not connect to SQL server; SQL server returned:
Failed to connect to server DRPRCBSDBS01.
A network-related or instance-specific error occurred while establishing a conne
ction 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 conne
ction to SQL Server)
The system cannot find the file specified (HRESULT:0x80131501)

The name which is showing that is a hostname of server but node name is different.

Prem

Hi,

This is the new error which I found on log.

06/22/2017 12:22:58 ANS2250W  A TSM core file or crash report was found: C:\Program Files\Tivoli\TSM\baclient\dsmcrash.dmp
06/22/2017 13:40:59 ANS5216E Could not establish a TCP/IP connection with address '10.101.7.21:1500'. The TCP/IP error is 'No connection could be made because the target machine actively refused it.' (errno = 10061).
06/22/2017 13:40:59 ANS9201W LAN-free path failed.
06/22/2017 13:41:18 ANS5216E Could not establish a TCP/IP connection with address '10.101.7.21:1500'. The TCP/IP error is 'No connection could be made because the target machine actively refused it.' (errno = 10061).
06/22/2017 13:41:18 ANS9201W LAN-free path failed.

When I am doing telnet against this port from this server to TSM server and TSM server to this server it is accepting the connection.

Prem

I found one more issue according to my understanding which node I am using for on that node one tcp/ip name address is coming as below, that is a host name of server where sql is installed but I am not using this node name anywhere my node name is DCPRCBSDBS01 and sql node name is DCPRCBSDBS01_SQL and getting below error now.

Connecting to SQL Server, please wait...

Volume Shadow Copy Service (VSS) Information
--------------------------------------------

ACO5098E Error obtaining VSS information from Local DSMAgent Node: 'DRPRCBSDBS01'.
ACO0501E Invalid Proxy Configuration Detected:
Target Node 'DCPRCBSDBS01_SQL' is not listed as a valid node to proxy to for Node Name 'DRPRCBSDBS01'.

Completed

tsm: SPINST1>q node DCPRCBSDBS01_SQL f=d

                            Node Name: DCPRCBSDBS01_SQL
                             Platform: TDP MSSQL Win64
                      Client OS Level: 6.01
                       Client Version: Version 7, release 1, level 6.2
                  Application Version: Version 7, release 1, level 6.0
                   Policy Domain Name: SQLDOM
                Last Access Date/Time: 06/22/2017 17:30:27
               Days Since Last Access: <1
               Password Set Date/Time: 06/13/2017 11:49:34
              Days Since Password Set: 9
                Invalid Sign-on Count: 0
                              Locked?: No
                              Contact:
                          Compression: Client
              Archive Delete Allowed?: Yes
               Backup Delete Allowed?: No
               Registration Date/Time: 06/13/2017 11:49:34
            Registering Administrator: SPINST1
       Last Communication Method Used: Tcp/Ip
          Bytes Received Last Session: 113,105.90 M
              Bytes Sent Last Session: 5,417
             Duration of Last Session: 1,474.00
          Pct. Idle Wait Last Session: 0.14
         Pct. Comm. Wait Last Session: 44.78
         Pct. Media Wait Last Session: 4.21
                            Optionset:
                                  URL:
                            Node Type: Client
           Password Expiration Period:
                    Keep Mount Point?: No
         Maximum Mount Points Allowed: 3
               Auto Filespace Rename : No
                    Validate Protocol: No
                          TCP/IP Name: DRPRCBSDBS01
                       TCP/IP Address: 10.101.7.21
                   Globally Unique ID: f0.ff.bb.40.50.1b.11.e7.ab.fd.08.94.ef.16.88.21
                Transaction Group Max: 0
more...   (

I believe that is happening because of service account doesn't exist attaching the snapshot for your reference, now I have added a hit and trail one domain admin account but i believe we need the same service account which own sql server and their services. as of now I can't see that account under local user and group which should be there ideally.

Prem

https://www.ibm.com/support/knowledgecenter/en/SSGSG7_6.4.0/com.ibm.itsm.db.orc.msgs.doc/msgs_orc82.html

On TSM server check "grant proxy" command output and verify the relationship.

Bharat

Bharat,

Thanks it is resolved when I configure after that someone restarted the server because it is on cluster it moved into next active one because it is configure active passive now all back to normal thanks

Prem