Problems creating dSource for a SQL database

  • 0
  • 1
  • Question
  • Updated 3 years ago
  • Answered
dear all,
I'm trying to create a dSource from a SQLServer db and I get the login error reported in the error pane below.


the users provided by my customer are two: 
1. domain user with sysadmin priviledges fot the db
2. local sql user (testBU) 

when I try to use domain user for DBUsername, user verify credentials fails as in the pic below even If this user can access machin/databases via any sql client:

 

when I use local sql user, verify credentials is fine but the dSource creation fails as in the first pic:



does anybody have any idea?

hope I've been clear enough otherwise feel free to ask any further detail that can help.

Fabio
Photo of Fabio

Fabio

  • 486 Points 250 badge 2x thumb

Posted 3 years ago

  • 0
  • 1
Photo of Giorgio Segnato

Giorgio Segnato

  • 332 Points 250 badge 2x thumb
Hello Fabio,

please verify your user telecomitalia\10810900 is:
- a member of Backup Operators or Administrator on your source machine and also on staging/target machine
- has a login with windows authentication on source sqlserver instance
- has a database role of db_datareader for master database on source database instance
- has sufficent priviledges for starting a copy-only full backup on source database instance

Moreover,
please verify your staging/target windows user privileges:
- must be a member of local administrators group
- must have a sqlserver role of sysadmin
- must have a "Logon as Batch Job" priviledge

Regards,
Giorgio
Photo of Fabio

Fabio

  • 486 Points 250 badge 2x thumb
checks done, everything is as expected to be...

cheers,
Fabio
Photo of Giorgio Segnato

Giorgio Segnato

  • 332 Points 250 badge 2x thumb
Fabio,

could you run the hostchecker to validate your source host and post here the output?

Thanks
Giorgio
(Edited)
Photo of Fabio

Fabio

  • 486 Points 250 badge 2x thumb
this is what I get from the script: <Install Dir>\Delphix\Delphix Connector\etc\dlpx-host-checker.PS1

§§§§§§§§§§§§§§§§§§§§§§§§§§§§§§§§§§§§§§§§§§§

**********************Windows PowerShell transcript start
Start time: 20150612130937
Username  : TELECOMITALIA\10810900 
Machine  : GRFSQL013BA020 (Microsoft Windows NT 6.0.6002 Service Pack 2) 
**********************
Transcript started, output file is out.txt

Check Host Configuration
Check host configuration for:
[S] Source Host  [T] Target Host  [?] Help (default is "T"): S
Enter source host name or IP address: 10.51.30.89
Enter a database to validate or "ALL" to check all databases: All
Enter DB user name: telecomitalia\10810900
Enter DB user password: 

Validating host settings for source system GRFSQL013BA020
Validating using OS user: telecomitalia\10810900
Computer name:   GRFSQL013BA020
Current version: 6.0
Product name:    Windows Server (R) 2008 Enterprise without Hyper-V
Build:           6002.vistasp2_gdr.120402-0336
Memory:          8588455936
TimeZone:        W. Europe Standard Time

Host environment OK

Discovering MSSQL Instances

Instance Name: MSSQLSERVER
Port:          1433
instanceOwner: GRIFFON\grf_mpa_sp_sql
version: 11.0.2100.60
installationPath: E:\Program Files\Microsoft SQL Server\\110
Could not detect databases.


**********************
Windows PowerShell transcript end
End time: 20150612131016
**********************
Photo of Adam Bowen

Adam Bowen, Official Rep

  • 17,420 Points 10k badge 2x thumb
Fabio, validate it as a Target. (you chose source)
Photo of Fabio

Fabio

  • 486 Points 250 badge 2x thumb
done, this is what I get: 

§§§§§§§§§§§§§§§§§§§§§§§§§§§§§§§§§§§

**********************Windows PowerShell transcript start
Start time: 20150612150748
Username  : TELECOMITALIA\10810900 
Machine  : GRFSQL013BA020 (Microsoft Windows NT 6.0.6002 Service Pack 2) 
**********************
Transcript started, output file is out-t.txt

Check Host Configuration
Check host configuration for:
[S] Source Host  [T] Target Host  [?] Help (default is "T"): T
Validating host settings for target system GRFSQL013BA020
Using iSCSI initiator IQN iqn.1991-05.com.microsoft:grfsql013ba020.griffon.local
Validating using OS user: telecomitalia\10810900
Computer name:   GRFSQL013BA020
Current version: 6.0
Product name:    Windows Server (R) 2008 Enterprise without Hyper-V
Build:           6002.vistasp2_gdr.120402-0336
Memory:          8588455936
TimeZone:        W. Europe Standard Time

Host environment OK

Discovering MSSQL Instances

Instance Name: MSSQLSERVER
Port:          1433
instanceOwner: GRIFFON\grf_mpa_sp_sql
version: 11.0.2100.60
installationPath: E:\Program Files\Microsoft SQL Server\\110
OS user has sysadmin role.

**********************
Windows PowerShell transcript end
End time: 20150612150751
**********************
Photo of Giorgio Segnato

Giorgio Segnato

  • 332 Points 250 badge 2x thumb
Fabio, It seems your host user is from a "telecom" domain, which is a different one from "griffon" domain which is  the sqlserver instance owner.

So I think you have to apply appropriate cross-domain trust relationship between "telecom" and "griffon" domains.

Regards,
Giorgio
(Edited)
Photo of Fabio

Fabio

  • 486 Points 250 badge 2x thumb
I'm gonna do it... 
Photo of Adam Bowen

Adam Bowen, Official Rep

  • 17,420 Points 10k badge 2x thumb
Giorgio, there isn't an independent hostchecker for Windows systems. Fabio, after the verify credentials fails, where do you see a failed login in either of the Windows servers logs, or either of the SQL server logs?
Photo of Giorgio Segnato

Giorgio Segnato

  • 332 Points 250 badge 2x thumb
Hi Adam,

it should be the powershell script under <Install Dir>\Delphix\Delphix Connector\etc\dlpx-host-checker.PS1

I'm wrong?
Photo of Adam Bowen

Adam Bowen, Official Rep

  • 17,420 Points 10k badge 2x thumb
Nope. you are right and I am wrong. :)
Photo of Adam Bowen

Adam Bowen, Official Rep

  • 17,420 Points 10k badge 2x thumb
Also, out of curiosity, are you running on an Italian version of Windows, or US English?
Photo of Fabio

Fabio

  • 486 Points 250 badge 2x thumb
no, US English version... 
Photo of Adam Bowen

Adam Bowen, Official Rep

  • 17,420 Points 10k badge 2x thumb
On 10.51.30.89 in <Install Dir>\Delphix\Delphix\Connector\logs, can you post the last 50 lines of the debug log?
Photo of Fabio

Fabio

  • 486 Points 250 badge 2x thumb
it might be they are more than 50, anyway---

§§§§§§§§§§§§§§§§§§§§§§§§§§§§§§§§§§§§§§§§§§§§§§§§§§§§

[2015-06-12 14:53:19,409][DEBUG][com.delphix.appliance.server.connector.Connector][Thread-66206][ConnectorLogger.debug] /10.13.219.100:0/9fc9017e-2628-4213-a7d1-5a37b5aec076: [execute complete: 0]stdout
{

}
stderr
{

}
[2015-06-12 14:53:19,409][INFO][com.delphix.appliance.server.connector.Connector][Thread-66206][ConnectorLogger.info] /10.13.219.100:0/9fc9017e-2628-4213-a7d1-5a37b5aec076: [execute complete]
[2015-06-12 14:53:19,532][INFO][com.delphix.appliance.server.connector.Connector][Thread-66206][ConnectorLogger.info] /10.13.219.100:0/9cdd3058-924a-4d3f-a202-f8eeccf7d1de: [writefile] C:\Program Files\Delphix\DelphixConnector\420820d0-3763-029e-3acc-deae943db10e-staging-223\SCRIPT\temp\IsMemberOfDataReaderMaster.ab0a0276-9572-4828-8fe7-51f20dd30f5f.sql
[2015-06-12 14:53:19,663][INFO][com.delphix.appliance.server.connector.Connector][Thread-66206][ConnectorLogger.info] /10.13.219.100:0/79ade6cc-2b8b-495e-abc6-0afb0d529a43: [executing] dlpxrunas powershell -Version 2.0 -NonInteractive -InputFormat none -ExecutionPolicy RemoteSigned -Command $parent = Split-Path -Parent 'C:\Program Files\Delphix\DelphixConnector\420820d0-3763-029e-3acc-deae943db10e-staging-223\SCRIPT\temp\IsMemberOfDataReaderMaster.ab0a0276-9572-4828-8fe7-51f20dd30f5f.wrap.ps1'; if (!(Test-Path -Type container $parent)) { New-Item -type directory -path $parent }
[2015-06-12 14:53:20,142][DEBUG][com.delphix.appliance.server.connector.Connector][Thread-66207][ConnectorLogger.debug] /10.13.219.100:0/b09a320b-21c2-46d4-bd7d-675cbd56b7d7: [execute complete: 1]
stdout
{
?


Retrying to set the database offline...




}
stderr
{
Sqlcmd: Error: Microsoft SQL Server Native Client 11.0 : Login failed. The login is from an untrusted domain and cannot be used with Windows authentication..
Sqlcmd: Error: Microsoft SQL Server Native Client 11.0 : Login failed. The login is from an untrusted domain and cannot be used with Windows authentication..
Sqlcmd: Error: Microsoft SQL Server Native Client 11.0 : Login failed. The login is from an untrusted domain and cannot be used with Windows authentication..
Sqlcmd: Error: Microsoft SQL Server Native Client 11.0 : Login failed. The login is from an untrusted domain and cannot be used with Windows authentication..
?die : Error: offline_database failed
At C:\Program Files\Delphix\DelphixConnector\420820d0-3763-029e-3acc-deae943db10e-staging-223\SCRIPT\OfflineDatabase.ps1:81 char:4
+ die <<<<  "offline_database failed"
    + CategoryInfo          : NotSpecified: (:) [Write-Error], WriteErrorException
    + FullyQualifiedErrorId : Microsoft.PowerShell.Commands.WriteErrorException,die
 
Sqlcmd: Error: Microsoft SQL Server Native Client 11.0 : Login failed. The login is from an untrusted domain and cannot be used with Windows authentication..
Sqlcmd: Error: Microsoft SQL Server Native Client 11.0 : Login failed. The login is from an untrusted domain and cannot be used with Windows authentication..
die : Error: drop_database failed
At C:\Program Files\Delphix\DelphixConnector\420820d0-3763-029e-3acc-deae943db10e-staging-223\SCRIPT\DropDatabase.ps1:23 char:12
+         die <<<<  "$($args[0])"
    + CategoryInfo          : NotSpecified: (:) [Write-Error], WriteErrorException
    + FullyQualifiedErrorId : Microsoft.PowerShell.Commands.WriteErrorException,die
 

}
[2015-06-12 14:53:20,143][INFO][com.delphix.appliance.server.connector.Connector][Thread-66207][ConnectorLogger.info] /10.13.219.100:0/b09a320b-21c2-46d4-bd7d-675cbd56b7d7: [execute complete]
[2015-06-12 14:53:20,150][INFO][com.delphix.appliance.server.connector.Connector][Thread-66207][ConnectorLogger.info] /10.13.219.100:0/d2d8339d-2afc-4778-a9be-a40c7b5cf5fc: [executing] dlpxrunas powershell -Version 2.0 -NonInteractive -InputFormat none -ExecutionPolicy RemoteSigned -Command $parent = Split-Path -Parent 'C:\Program Files\Delphix\DelphixConnector\420820d0-3763-029e-3acc-deae943db10e-staging-223\SCRIPT\RemoveSMBShare.ps1'; if (!(Test-Path -Type container $parent)) { New-Item -type directory -path $parent }
[2015-06-12 14:53:20,717][DEBUG][com.delphix.appliance.server.connector.Connector][Thread-66206][ConnectorLogger.debug] /10.13.219.100:0/79ade6cc-2b8b-495e-abc6-0afb0d529a43: [execute complete: 0]
stdout
{

}
stderr
{

}
[2015-06-12 14:53:20,717][INFO][com.delphix.appliance.server.connector.Connector][Thread-66206][ConnectorLogger.info] /10.13.219.100:0/79ade6cc-2b8b-495e-abc6-0afb0d529a43: [execute complete]
[2015-06-12 14:53:20,840][INFO][com.delphix.appliance.server.connector.Connector][Thread-66206][ConnectorLogger.info] /10.13.219.100:0/9e8b0158-c9dd-4679-a1d9-21b37384a005: [writefile] C:\Program Files\Delphix\DelphixConnector\420820d0-3763-029e-3acc-deae943db10e-staging-223\SCRIPT\temp\IsMemberOfDataReaderMaster.ab0a0276-9572-4828-8fe7-51f20dd30f5f.wrap.ps1
[2015-06-12 14:53:20,959][INFO][com.delphix.appliance.server.connector.Connector][Thread-66206][ConnectorLogger.info] /10.13.219.100:0/d36ebae7-805b-43dc-8580-9f639b765dc1: [executing] dlpxrunas powershell -Version 2.0 -NonInteractive -InputFormat none -ExecutionPolicy RemoteSigned -Command & 'C:\Program Files\Delphix\DelphixConnector\420820d0-3763-029e-3acc-deae943db10e-staging-223\SCRIPT\temp\IsMemberOfDataReaderMaster.ab0a0276-9572-4828-8fe7-51f20dd30f5f.wrap.ps1'
[2015-06-12 14:53:21,132][DEBUG][com.delphix.appliance.server.connector.Connector][Thread-66207][ConnectorLogger.debug] /10.13.219.100:0/d2d8339d-2afc-4778-a9be-a40c7b5cf5fc: [execute complete: 0]
stdout
{

}
stderr
{

}
[2015-06-12 14:53:21,133][INFO][com.delphix.appliance.server.connector.Connector][Thread-66207][ConnectorLogger.info] /10.13.219.100:0/d2d8339d-2afc-4778-a9be-a40c7b5cf5fc: [execute complete]
[2015-06-12 14:53:21,249][INFO][com.delphix.appliance.server.connector.Connector][Thread-66207][ConnectorLogger.info] /10.13.219.100:0/cc392504-0b65-4fe4-b1f7-394344b25955: [writefile] C:\Program Files\Delphix\DelphixConnector\420820d0-3763-029e-3acc-deae943db10e-staging-223\SCRIPT\RemoveSMBShare.ps1
[2015-06-12 14:53:21,371][INFO][com.delphix.appliance.server.connector.Connector][Thread-66207][ConnectorLogger.info] /10.13.219.100:0/4e67ff7f-100f-4b42-bb30-3329438c3e72: [executing] dlpxrunas powershell -Version 2.0 -NonInteractive -InputFormat none -ExecutionPolicy RemoteSigned -Command & 'C:\Program Files\Delphix\DelphixConnector\420820d0-3763-029e-3acc-deae943db10e-staging-223\SCRIPT\RemoveSMBShare.ps1'
[2015-06-12 14:53:22,484][DEBUG][com.delphix.appliance.server.connector.Connector][Thread-66206][ConnectorLogger.debug] /10.13.219.100:0/d36ebae7-805b-43dc-8580-9f639b765dc1: [execute complete: 0]
stdout
{
Changed database context to 'master'.
1

}
stderr
{

}
[2015-06-12 14:53:22,485][INFO][com.delphix.appliance.server.connector.Connector][Thread-66206][ConnectorLogger.info] /10.13.219.100:0/d36ebae7-805b-43dc-8580-9f639b765dc1: [execute complete]
[2015-06-12 14:53:22,712][DEBUG][com.delphix.appliance.server.connector.Connector][Thread-66207][ConnectorLogger.debug] /10.13.219.100:0/4e67ff7f-100f-4b42-bb30-3329438c3e72: [execute complete: 0]
stdout
{
?Share 420820d0-3763-029e-3acc-deae943db10e-staging-223 not found.

}
stderr
{

}
[2015-06-12 14:53:22,712][INFO][com.delphix.appliance.server.connector.Connector][Thread-66207][ConnectorLogger.info] /10.13.219.100:0/4e67ff7f-100f-4b42-bb30-3329438c3e72: [execute complete]
[2015-06-12 14:53:22,860][INFO][com.delphix.appliance.server.connector.Connector][Thread-66207][ConnectorLogger.info] /10.13.219.100:0/358be868-9ef1-470e-acaf-7dc33d26a157: [executing] dlpxrunas powershell -Version 2.0 -NonInteractive -InputFormat none -ExecutionPolicy RemoteSigned -Command $parent = Split-Path -Parent 'C:\Program Files\Delphix\DelphixConnector\420820d0-3763-029e-3acc-deae943db10e-staging-223\SCRIPT\StartISCSIService.ps1'; if (!(Test-Path -Type container $parent)) { New-Item -type directory -path $parent }
[2015-06-12 14:53:22,883][INFO][com.delphix.appliance.server.connector.Connector][Thread-66206][ConnectorLogger.info] /10.13.219.100:0/811a5c74-5a66-4f09-af37-0dbe38ce75a9: [executing] dlpxrunas powershell -Version 2.0 -NonInteractive -InputFormat none -ExecutionPolicy RemoteSigned -Command $parent = Split-Path -Parent 'C:\Program Files\Delphix\DelphixConnector\420820d0-3763-029e-3acc-deae943db10e-staging-223\SCRIPT\temp\IsMemberOfDataReaderMsdb.e341900d-6ce0-42de-98ab-a11dbae7e839.sql'; if (!(Test-Path -Type container $parent)) { New-Item -type directory -path $parent }
[2015-06-12 14:53:24,029][DEBUG][com.delphix.appliance.server.connector.Connector][Thread-66206][ConnectorLogger.debug] /10.13.219.100:0/811a5c74-5a66-4f09-af37-0dbe38ce75a9: [execute complete: 0]
stdout
{

}
stderr
{

}
[2015-06-12 14:53:24,029][INFO][com.delphix.appliance.server.connector.Connector][Thread-66206][ConnectorLogger.info] /10.13.219.100:0/811a5c74-5a66-4f09-af37-0dbe38ce75a9: [execute complete]
[2015-06-12 14:53:24,143][DEBUG][com.delphix.appliance.server.connector.Connector][Thread-66207][ConnectorLogger.debug] /10.13.219.100:0/358be868-9ef1-470e-acaf-7dc33d26a157: [execute complete: 0]
stdout
{

}
stderr
{

}
[2015-06-12 14:53:24,144][INFO][com.delphix.appliance.server.connector.Connector][Thread-66207][ConnectorLogger.info] /10.13.219.100:0/358be868-9ef1-470e-acaf-7dc33d26a157: [execute complete]
[2015-06-12 14:53:24,150][INFO][com.delphix.appliance.server.connector.Connector][Thread-66206][ConnectorLogger.info] /10.13.219.100:0/4fb621d5-691f-4181-bf6f-5f29b1c2b784: [writefile] C:\Program Files\Delphix\DelphixConnector\420820d0-3763-029e-3acc-deae943db10e-staging-223\SCRIPT\temp\IsMemberOfDataReaderMsdb.e341900d-6ce0-42de-98ab-a11dbae7e839.sql
[2015-06-12 14:53:24,260][INFO][com.delphix.appliance.server.connector.Connector][Thread-66207][ConnectorLogger.info] /10.13.219.100:0/24e72ae9-061a-4908-8e17-17000153090e: [writefile] C:\Program Files\Delphix\DelphixConnector\420820d0-3763-029e-3acc-deae943db10e-staging-223\SCRIPT\StartISCSIService.ps1
[2015-06-12 14:53:24,279][INFO][com.delphix.appliance.server.connector.Connector][Thread-66206][ConnectorLogger.info] /10.13.219.100:0/3eca0710-51bc-4735-a9d6-da3a9a001889: [executing] dlpxrunas powershell -Version 2.0 -NonInteractive -InputFormat none -ExecutionPolicy RemoteSigned -Command $parent = Split-Path -Parent 'C:\Program Files\Delphix\DelphixConnector\420820d0-3763-029e-3acc-deae943db10e-staging-223\SCRIPT\temp\IsMemberOfDataReaderMsdb.e341900d-6ce0-42de-98ab-a11dbae7e839.wrap.ps1'; if (!(Test-Path -Type container $parent)) { New-Item -type directory -path $parent }
[2015-06-12 14:53:24,380][INFO][com.delphix.appliance.server.connector.Connector][Thread-66207][ConnectorLogger.info] /10.13.219.100:0/6352faf1-9c7c-4584-bc4f-2057b4d9e349: [executing] dlpxrunas powershell -Version 2.0 -NonInteractive -InputFormat none -ExecutionPolicy RemoteSigned -Command & 'C:\Program Files\Delphix\DelphixConnector\420820d0-3763-029e-3acc-deae943db10e-staging-223\SCRIPT\StartISCSIService.ps1'
[2015-06-12 14:53:25,316][DEBUG][com.delphix.appliance.server.connector.Connector][Thread-66206][ConnectorLogger.debug] /10.13.219.100:0/3eca0710-51bc-4735-a9d6-da3a9a001889: [execute complete: 0]
stdout
{

}
stderr
{

}
[2015-06-12 14:53:25,316][INFO][com.delphix.appliance.server.connector.Connector][Thread-66206][ConnectorLogger.info] /10.13.219.100:0/3eca0710-51bc-4735-a9d6-da3a9a001889: [execute complete]
[2015-06-12 14:53:25,437][INFO][com.delphix.appliance.server.connector.Connector][Thread-66206][ConnectorLogger.info] /10.13.219.100:0/b67ae283-dd25-4e62-9285-e89255b9d03e: [writefile] C:\Program Files\Delphix\DelphixConnector\420820d0-3763-029e-3acc-deae943db10e-staging-223\SCRIPT\temp\IsMemberOfDataReaderMsdb.e341900d-6ce0-42de-98ab-a11dbae7e839.wrap.ps1
[2015-06-12 14:53:25,557][INFO][com.delphix.appliance.server.connector.Connector][Thread-66206][ConnectorLogger.info] /10.13.219.100:0/6e2bc7fd-b67f-4d83-8e79-e023789bc484: [executing] dlpxrunas powershell -Version 2.0 -NonInteractive -InputFormat none -ExecutionPolicy RemoteSigned -Command & 'C:\Program Files\Delphix\DelphixConnector\420820d0-3763-029e-3acc-deae943db10e-staging-223\SCRIPT\temp\IsMemberOfDataReaderMsdb.e341900d-6ce0-42de-98ab-a11dbae7e839.wrap.ps1'
[2015-06-12 14:53:25,994][DEBUG][com.delphix.appliance.server.connector.Connector][Thread-66207][ConnectorLogger.debug] /10.13.219.100:0/6352faf1-9c7c-4584-bc4f-2057b4d9e349: [execute complete: 0]
stdout
{

}
stderr
{

}
[2015-06-12 14:53:25,995][INFO][com.delphix.appliance.server.connector.Connector][Thread-66207][ConnectorLogger.info] /10.13.219.100:0/6352faf1-9c7c-4584-bc4f-2057b4d9e349: [execute complete]
[2015-06-12 14:53:26,131][INFO][com.delphix.appliance.server.connector.Connector][Thread-66207][ConnectorLogger.info] /10.13.219.100:0/1d205633-23ae-41dd-a36c-c25db092cda7: [executing] dlpxrunas powershell -Version 2.0 -NonInteractive -InputFormat none -ExecutionPolicy RemoteSigned -Command $parent = Split-Path -Parent 'C:\Program Files\Delphix\DelphixConnector\420820d0-3763-029e-3acc-deae943db10e-staging-223\SCRIPT\UnmountLunData.ps1'; if (!(Test-Path -Type container $parent)) { New-Item -type directory -path $parent }
[2015-06-12 14:53:26,971][DEBUG][com.delphix.appliance.server.connector.Connector][Thread-66206][ConnectorLogger.debug] /10.13.219.100:0/6e2bc7fd-b67f-4d83-8e79-e023789bc484: [execute complete: 0]
stdout
{
Changed database context to 'msdb'.
1

}
stderr
{

}
[2015-06-12 14:53:26,971][INFO][com.delphix.appliance.server.connector.Connector][Thread-66206][ConnectorLogger.info] /10.13.219.100:0/6e2bc7fd-b67f-4d83-8e79-e023789bc484: [execute complete]
[2015-06-12 14:53:27,155][DEBUG][com.delphix.appliance.server.connector.Connector][Thread-66207][ConnectorLogger.debug] /10.13.219.100:0/1d205633-23ae-41dd-a36c-c25db092cda7: [execute complete: 0]
stdout
{

}
stderr
{

}
[2015-06-12 14:53:27,155][INFO][com.delphix.appliance.server.connector.Connector][Thread-66207][ConnectorLogger.info] /10.13.219.100:0/1d205633-23ae-41dd-a36c-c25db092cda7: [execute complete]
[2015-06-12 14:53:27,275][INFO][com.delphix.appliance.server.connector.Connector][Thread-66207][ConnectorLogger.info] /10.13.219.100:0/79d9ddf2-fed5-4e2d-abb0-cf9e2749ec98: [writefile] C:\Program Files\Delphix\DelphixConnector\420820d0-3763-029e-3acc-deae943db10e-staging-223\SCRIPT\UnmountLunData.ps1
[2015-06-12 14:53:27,334][INFO][com.delphix.appliance.server.connector.Connector][Thread-66206][ConnectorLogger.info] /10.13.219.100:0: java.io.EOFException:null
[2015-06-12 14:53:27,335][INFO][com.delphix.appliance.server.connector.Connector][Thread-66206][ConnectorLogger.info] /10.13.219.100:0: closing connection
[2015-06-12 14:53:27,392][INFO][com.delphix.appliance.server.connector.Connector][Thread-66207][ConnectorLogger.info] /10.13.219.100:0/4bc95337-6b3f-4a40-886f-fefb1b4663e6: [executing] dlpxrunas powershell -NonInteractive -InputFormat none -ExecutionPolicy RemoteSigned -Command & 'C:\Program Files\Delphix\DelphixConnector\420820d0-3763-029e-3acc-deae943db10e-staging-223\SCRIPT\UnmountLunData.ps1'
[2015-06-12 14:53:35,962][DEBUG][com.delphix.appliance.server.connector.Connector][Thread-66207][ConnectorLogger.debug] /10.13.219.100:0/4bc95337-6b3f-4a40-886f-fefb1b4663e6: [execute complete: 0]
stdout
{
Microsoft iSCSI Initiator Version 6.0 Build 6000

The operation completed successfully. 
Microsoft iSCSI Initiator Version 6.0 Build 6000

The operation completed successfully. 
Microsoft iSCSI Initiator Version 6.0 Build 6000

The operation completed successfully. 

Microsoft DiskPart version 6.0.6002
Copyright (C) 1999-2007 Microsoft Corporation.
On computer: GRFSQL013BA020

Please wait while DiskPart scans your configuration...

DiskPart has finished scanning your configuration.

Leaving DiskPart...
Discovered lun 0 is disk 2

Microsoft DiskPart version 6.0.6002
Copyright (C) 1999-2007 Microsoft Corporation.
On computer: GRFSQL013BA020

Disk 2 is now the selected disk.

DiskPart successfully offlined the selected disk.

Leaving DiskPart...

}
stderr
{

}
[2015-06-12 14:53:35,963][INFO][com.delphix.appliance.server.connector.Connector][Thread-66207][ConnectorLogger.info] /10.13.219.100:0/4bc95337-6b3f-4a40-886f-fefb1b4663e6: [execute complete]
[2015-06-12 14:53:36,083][INFO][com.delphix.appliance.server.connector.Connector][Thread-66207][ConnectorLogger.info] /10.13.219.100:0/3f2c8997-5425-412a-91cf-aa3e371b2273: [executing] dlpxrunas powershell -Version 2.0 -NonInteractive -InputFormat none -ExecutionPolicy RemoteSigned -Command $parent = Split-Path -Parent 'C:\Program Files\Delphix\DelphixConnector\420820d0-3763-029e-3acc-deae943db10e-staging-223\SCRIPT\StartISCSIService.ps1'; if (!(Test-Path -Type container $parent)) { New-Item -type directory -path $parent }
[2015-06-12 14:53:37,250][DEBUG][com.delphix.appliance.server.connector.Connector][Thread-66207][ConnectorLogger.debug] /10.13.219.100:0/3f2c8997-5425-412a-91cf-aa3e371b2273: [execute complete: 0]
stdout
{

}
stderr
{

}
[2015-06-12 14:53:37,250][INFO][com.delphix.appliance.server.connector.Connector][Thread-66207][ConnectorLogger.info] /10.13.219.100:0/3f2c8997-5425-412a-91cf-aa3e371b2273: [execute complete]
[2015-06-12 14:53:37,367][INFO][com.delphix.appliance.server.connector.Connector][Thread-66207][ConnectorLogger.info] /10.13.219.100:0/a09954bf-b6de-48ec-82a3-e8bcf77b4fa1: [writefile] C:\Program Files\Delphix\DelphixConnector\420820d0-3763-029e-3acc-deae943db10e-staging-223\SCRIPT\StartISCSIService.ps1
[2015-06-12 14:53:37,487][INFO][com.delphix.appliance.server.connector.Connector][Thread-66207][ConnectorLogger.info] /10.13.219.100:0/5aa9180e-5b55-4f2e-8eb0-49a3c91b63ef: [executing] dlpxrunas powershell -Version 2.0 -NonInteractive -InputFormat none -ExecutionPolicy RemoteSigned -Command & 'C:\Program Files\Delphix\DelphixConnector\420820d0-3763-029e-3acc-deae943db10e-staging-223\SCRIPT\StartISCSIService.ps1'
[2015-06-12 14:53:39,160][DEBUG][com.delphix.appliance.server.connector.Connector][Thread-66207][ConnectorLogger.debug] /10.13.219.100:0/5aa9180e-5b55-4f2e-8eb0-49a3c91b63ef: [execute complete: 0]
stdout
{

}
stderr
{

}
[2015-06-12 14:53:39,161][INFO][com.delphix.appliance.server.connector.Connector][Thread-66207][ConnectorLogger.info] /10.13.219.100:0/5aa9180e-5b55-4f2e-8eb0-49a3c91b63ef: [execute complete]
[2015-06-12 14:53:39,297][INFO][com.delphix.appliance.server.connector.Connector][Thread-66207][ConnectorLogger.info] /10.13.219.100:0/f43265c8-0bdb-44c8-b761-01c9b9a96396: [executing] dlpxrunas powershell -Version 2.0 -NonInteractive -InputFormat none -ExecutionPolicy RemoteSigned -Command $parent = Split-Path -Parent 'C:\Program Files\Delphix\DelphixConnector\420820d0-3763-029e-3acc-deae943db10e-staging-223\SCRIPT\UnmountLunTemp.ps1'; if (!(Test-Path -Type container $parent)) { New-Item -type directory -path $parent }
[2015-06-12 14:53:40,456][DEBUG][com.delphix.appliance.server.connector.Connector][Thread-66207][ConnectorLogger.debug] /10.13.219.100:0/f43265c8-0bdb-44c8-b761-01c9b9a96396: [execute complete: 0]
stdout
{

}
stderr
{

}
[2015-06-12 14:53:40,456][INFO][com.delphix.appliance.server.connector.Connector][Thread-66207][ConnectorLogger.info] /10.13.219.100:0/f43265c8-0bdb-44c8-b761-01c9b9a96396: [execute complete]
[2015-06-12 14:53:40,579][INFO][com.delphix.appliance.server.connector.Connector][Thread-66207][ConnectorLogger.info] /10.13.219.100:0/7e9bdbdb-54db-41cc-bbd7-73aec67010fa: [writefile] C:\Program Files\Delphix\DelphixConnector\420820d0-3763-029e-3acc-deae943db10e-staging-223\SCRIPT\UnmountLunTemp.ps1
[2015-06-12 14:53:40,699][INFO][com.delphix.appliance.server.connector.Connector][Thread-66207][ConnectorLogger.info] /10.13.219.100:0/65ca2ee6-6b9c-4349-b842-fe3ad63cca19: [executing] dlpxrunas powershell -NonInteractive -InputFormat none -ExecutionPolicy RemoteSigned -Command & 'C:\Program Files\Delphix\DelphixConnector\420820d0-3763-029e-3acc-deae943db10e-staging-223\SCRIPT\UnmountLunTemp.ps1'
[2015-06-12 14:53:49,922][DEBUG][com.delphix.appliance.server.connector.Connector][Thread-66207][ConnectorLogger.debug] /10.13.219.100:0/65ca2ee6-6b9c-4349-b842-fe3ad63cca19: [execute complete: 0]
stdout
{
Microsoft iSCSI Initiator Version 6.0 Build 6000

The system cannot find the file specified. 
Microsoft iSCSI Initiator Version 6.0 Build 6000

The operation completed successfully. 
Microsoft iSCSI Initiator Version 6.0 Build 6000

The operation completed successfully. 

Microsoft DiskPart version 6.0.6002
Copyright (C) 1999-2007 Microsoft Corporation.
On computer: GRFSQL013BA020

Please wait while DiskPart scans your configuration...

DiskPart has finished scanning your configuration.

Leaving DiskPart...
Discovered lun 2 is disk 4

Microsoft DiskPart version 6.0.6002
Copyright (C) 1999-2007 Microsoft Corporation.
On computer: GRFSQL013BA020

Disk 4 is now the selected disk.

DiskPart encountered an error while offlining the disk.

Leaving DiskPart...

}
stderr
{

}
[2015-06-12 14:53:49,922][INFO][com.delphix.appliance.server.connector.Connector][Thread-66207][ConnectorLogger.info] /10.13.219.100:0/65ca2ee6-6b9c-4349-b842-fe3ad63cca19: [execute complete]
[2015-06-12 14:53:50,047][INFO][com.delphix.appliance.server.connector.Connector][Thread-66207][ConnectorLogger.info] /10.13.219.100:0/6c9ff1c8-b87a-456e-b02d-f890b1de8670: [executing] dlpxrunas powershell -Version 2.0 -NonInteractive -InputFormat none -ExecutionPolicy RemoteSigned -Command $parent = Split-Path -Parent 'C:\Program Files\Delphix\DelphixConnector\420820d0-3763-029e-3acc-deae943db10e-staging-223\SCRIPT\StartISCSIService.ps1'; if (!(Test-Path -Type container $parent)) { New-Item -type directory -path $parent }
[2015-06-12 14:53:51,346][DEBUG][com.delphix.appliance.server.connector.Connector][Thread-66207][ConnectorLogger.debug] /10.13.219.100:0/6c9ff1c8-b87a-456e-b02d-f890b1de8670: [execute complete: 0]
stdout
{

}
stderr
{

}
[2015-06-12 14:53:51,347][INFO][com.delphix.appliance.server.connector.Connector][Thread-66207][ConnectorLogger.info] /10.13.219.100:0/6c9ff1c8-b87a-456e-b02d-f890b1de8670: [execute complete]
[2015-06-12 14:53:51,461][INFO][com.delphix.appliance.server.connector.Connector][Thread-66207][ConnectorLogger.info] /10.13.219.100:0/3e420654-60d8-4750-b522-73f0f6d50731: [writefile] C:\Program Files\Delphix\DelphixConnector\420820d0-3763-029e-3acc-deae943db10e-staging-223\SCRIPT\StartISCSIService.ps1
[2015-06-12 14:53:51,581][INFO][com.delphix.appliance.server.connector.Connector][Thread-66207][ConnectorLogger.info] /10.13.219.100:0/f4852931-aeea-4b29-a4a8-cd93bf433e3e: [executing] dlpxrunas powershell -Version 2.0 -NonInteractive -InputFormat none -ExecutionPolicy RemoteSigned -Command & 'C:\Program Files\Delphix\DelphixConnector\420820d0-3763-029e-3acc-deae943db10e-staging-223\SCRIPT\StartISCSIService.ps1'
[2015-06-12 14:53:53,254][DEBUG][com.delphix.appliance.server.connector.Connector][Thread-66207][ConnectorLogger.debug] /10.13.219.100:0/f4852931-aeea-4b29-a4a8-cd93bf433e3e: [execute complete: 0]
stdout
{

}
stderr
{

}
[2015-06-12 14:53:53,255][INFO][com.delphix.appliance.server.connector.Connector][Thread-66207][ConnectorLogger.info] /10.13.219.100:0/f4852931-aeea-4b29-a4a8-cd93bf433e3e: [execute complete]
[2015-06-12 14:53:53,386][INFO][com.delphix.appliance.server.connector.Connector][Thread-66207][ConnectorLogger.info] /10.13.219.100:0/20bd4d09-40a6-4bb6-b916-4f22bf323b7a: [executing] dlpxrunas powershell -Version 2.0 -NonInteractive -InputFormat none -ExecutionPolicy RemoteSigned -Command $parent = Split-Path -Parent 'C:\Program Files\Delphix\DelphixConnector\420820d0-3763-029e-3acc-deae943db10e-staging-223\SCRIPT\UnmountLunArchive.ps1'; if (!(Test-Path -Type container $parent)) { New-Item -type directory -path $parent }
[2015-06-12 14:53:54,441][DEBUG][com.delphix.appliance.server.connector.Connector][Thread-66207][ConnectorLogger.debug] /10.13.219.100:0/20bd4d09-40a6-4bb6-b916-4f22bf323b7a: [execute complete: 0]
stdout
{

}
stderr
{

}
[2015-06-12 14:53:54,442][INFO][com.delphix.appliance.server.connector.Connector][Thread-66207][ConnectorLogger.info] /10.13.219.100:0/20bd4d09-40a6-4bb6-b916-4f22bf323b7a: [execute complete]
[2015-06-12 14:53:54,563][INFO][com.delphix.appliance.server.connector.Connector][Thread-66207][ConnectorLogger.info] /10.13.219.100:0/f2ee44e1-f687-4fb7-ad17-df57cde92467: [writefile] C:\Program Files\Delphix\DelphixConnector\420820d0-3763-029e-3acc-deae943db10e-staging-223\SCRIPT\UnmountLunArchive.ps1
[2015-06-12 14:53:54,682][INFO][com.delphix.appliance.server.connector.Connector][Thread-66207][ConnectorLogger.info] /10.13.219.100:0/c88a06fe-96e2-487f-90cf-356e99ccd675: [executing] dlpxrunas powershell -NonInteractive -InputFormat none -ExecutionPolicy RemoteSigned -Command & 'C:\Program Files\Delphix\DelphixConnector\420820d0-3763-029e-3acc-deae943db10e-staging-223\SCRIPT\UnmountLunArchive.ps1'
[2015-06-12 14:54:04,119][DEBUG][com.delphix.appliance.server.connector.Connector][Thread-66207][ConnectorLogger.debug] /10.13.219.100:0/c88a06fe-96e2-487f-90cf-356e99ccd675: [execute complete: 0]
stdout
{
Microsoft iSCSI Initiator Version 6.0 Build 6000

The operation completed successfully. 
Microsoft iSCSI Initiator Version 6.0 Build 6000

The operation completed successfully. 
Microsoft iSCSI Initiator Version 6.0 Build 6000

The operation completed successfully. 

Microsoft DiskPart version 6.0.6002
Copyright (C) 1999-2007 Microsoft Corporation.
On computer: GRFSQL013BA020

Please wait while DiskPart scans your configuration...

DiskPart has finished scanning your configuration.

Leaving DiskPart...
Discovered lun 1 is disk 3

Microsoft DiskPart version 6.0.6002
Copyright (C) 1999-2007 Microsoft Corporation.
On computer: GRFSQL013BA020

Disk 3 is now the selected disk.

DiskPart successfully offlined the selected disk.

Leaving DiskPart...

}
stderr
{

}
[2015-06-12 14:54:04,119][INFO][com.delphix.appliance.server.connector.Connector][Thread-66207][ConnectorLogger.info] /10.13.219.100:0/c88a06fe-96e2-487f-90cf-356e99ccd675: [execute complete]
[2015-06-12 14:54:04,245][INFO][com.delphix.appliance.server.connector.Connector][Thread-66207][ConnectorLogger.info] /10.13.219.100:0/5435dfac-3bd9-4dc9-a126-ddefc91abfaf: [executing] dlpxrunas powershell -Version 2.0 -NonInteractive -InputFormat none -ExecutionPolicy RemoteSigned -Command if (Test-Path -literalPath 'C:\Program Files\Delphix\DelphixConnector\420820d0-3763-029e-3acc-deae943db10e-staging-223') { cmd /c rd /s /q 'C:\Program Files\Delphix\DelphixConnector\420820d0-3763-029e-3acc-deae943db10e-staging-223' }
[2015-06-12 14:54:05,464][DEBUG][com.delphix.appliance.server.connector.Connector][Thread-66207][ConnectorLogger.debug] /10.13.219.100:0/5435dfac-3bd9-4dc9-a126-ddefc91abfaf: [execute complete: 0]
stdout
{

}
stderr
{

}
[2015-06-12 14:54:05,465][INFO][com.delphix.appliance.server.connector.Connector][Thread-66207][ConnectorLogger.info] /10.13.219.100:0/5435dfac-3bd9-4dc9-a126-ddefc91abfaf: [execute complete]
[2015-06-12 14:54:05,583][INFO][com.delphix.appliance.server.connector.Connector][Thread-66207][ConnectorLogger.info] /10.13.219.100:0: java.io.EOFException:null
[2015-06-12 14:54:05,583][INFO][com.delphix.appliance.server.connector.Connector][Thread-66207][ConnectorLogger.info] /10.13.219.100:0: closing connection
[2015-06-12 14:55:32,676][INFO][com.delphix.appliance.server.connector.Connector][Thread-66112][ConnectorLogger.info] /10.13.219.100:0/49c99021-de7f-4e39-92ee-293dcec43e2b: [execute failed] java.util.concurrent.TimeoutException: [execute job timed out or failed]
[2015-06-12 14:55:32,677][INFO][com.delphix.appliance.server.connector.Connector][Thread-66112][ConnectorLogger.info] /10.13.219.100:0/49c99021-de7f-4e39-92ee-293dcec43e2b: [execute complete]
[2015-06-12 14:55:32,678][INFO][com.delphix.appliance.server.connector.Connector][Thread-66112][ConnectorLogger.info] /10.13.219.100:0: javax.net.ssl.SSLException: Connection has been shutdown: javax.net.ssl.SSLException: java.net.SocketException: Software caused connection abort: socket write error:Connection has been shutdown: javax.net.ssl.SSLException: java.net.SocketException: Software caused connection abort: socket write error
[2015-06-12 14:55:32,678][INFO][com.delphix.appliance.server.connector.Connector][Thread-66112][ConnectorLogger.info] /10.13.219.100:0: closing connection
[2015-06-12 14:56:22,150][INFO][com.delphix.appliance.server.connector.Connector][Thread-66277][ConnectorWorker.run] /10.13.219.100: starting new thread
[2015-06-12 14:56:22,486][INFO][com.delphix.appliance.server.connector.Connector][Thread-66277][ConnectorLogger.info] /10.13.219.100:0/e9bf4c2c-a8dd-4c34-948d-a0aa0b0341d8: authentication successful, user: telecomitalia\10810900
[2015-06-12 14:56:22,487][INFO][com.delphix.appliance.server.connector.Connector][Thread-66277][ConnectorLogger.info] /10.13.219.100:0: successfully authenticated, using version: 2
[2015-06-12 14:56:22,610][INFO][com.delphix.appliance.server.connector.Connector][Thread-66277][ConnectorLogger.info] /10.13.219.100:0/8a037007-b8ee-46e7-abce-462ddefeb39e: [executing] dlpxrunas tracert 10.13.219.100
[2015-06-12 15:01:33,100][INFO][com.delphix.appliance.server.connector.Connector][Thread-66277][ConnectorLogger.info] /10.13.219.100:0/8a037007-b8ee-46e7-abce-462ddefeb39e: [execute failed] java.util.concurrent.TimeoutException: [execute job timed out or failed]
[2015-06-12 15:01:33,100][INFO][com.delphix.appliance.server.connector.Connector][Thread-66277][ConnectorLogger.info] /10.13.219.100:0/8a037007-b8ee-46e7-abce-462ddefeb39e: [execute complete]
[2015-06-12 15:01:33,102][INFO][com.delphix.appliance.server.connector.Connector][Thread-66277][ConnectorLogger.info] /10.13.219.100:0: javax.net.ssl.SSLException: Connection has been shutdown: javax.net.ssl.SSLException: java.net.SocketException: Software caused connection abort: socket write error:Connection has been shutdown: javax.net.ssl.SSLException: java.net.SocketException: Software caused connection abort: socket write error
[2015-06-12 15:01:33,102][INFO][com.delphix.appliance.server.connector.Connector][Thread-66277][ConnectorLogger.info] /10.13.219.100:0: closing connection
Photo of Adam Bowen

Adam Bowen, Official Rep

  • 17,420 Points 10k badge 2x thumb
Fabio, are you doing this with the Landshark environment (obvious that your SQL servers are your own)?
(Edited)
Photo of Fabio

Fabio

  • 486 Points 250 badge 2x thumb
;)

Photo of Adam Bowen

Adam Bowen, Official Rep

  • 17,420 Points 10k badge 2x thumb
supreme
Photo of Fabio

Fabio

  • 486 Points 250 badge 2x thumb
did't get any news...
did you notice the failing script is a power shell script which is created under delphixconnector dir every time you try to linka dsource and it seems the sql quesy doesn't find what it expected to find...
Photo of Adam Bowen

Adam Bowen, Official Rep

  • 17,420 Points 10k badge 2x thumb
Did you get the domain trust setup since these machines are on two different domains?
Photo of Fabio

Fabio

  • 486 Points 250 badge 2x thumb
yes, I checked this with my customer and he told me the two domains have always been trusting each other...
anyway, as I toldbefore, we run some tests on the sql query run by the failing power shell, see the attached img for the results (we adde some comment lines too).

Photo of Adam Bowen

Adam Bowen, Official Rep

  • 17,420 Points 10k badge 2x thumb
Can you repeat the whole action. And then upload a support bundle with the case number "Adam", please? This way I can get a more complete view of what is going on.
Photo of Fabio

Fabio

  • 486 Points 250 badge 2x thumb
quite difficoult to do as I'm no longer at that customer site...
I'll check what I can do but really sure I can do anything...
F.
Photo of Venkat Navaneeth

Venkat Navaneeth, Employee

  • 86 Points 75 badge 2x thumb
Fabio, Can you verify they have proper spn setup for this server? you can check that by executing the below commands.

setspn -L GRFSQL013BA020
setspn -L GRIFFON\grf_mpa_sp_sql

Let us know what you see.