Delphix Products

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
#DemoEnvironment
#Tip

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

checks done, everything is as expected to be...

cheers,
Fabio

Fabio,

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

Thanks
Giorgio

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?

Also, out of curiosity, are you running on an Italian version of Windows, or US English?

On 10.51.30.89 in <Install Dir>\Delphix\Delphix\Connector\logs, can you post the last 50 lines of the debug log?

Hi Adam,

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

I'm wrong?

Nope. you are right and I am wrong. :)

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
**********************

no, US English version... 

Fabio, validate it as a Target. (you chose source)

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

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
**********************

Fabio, are you doing this with the Landshark environment (obvious that your SQL servers are your own)?

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

I'm gonna do it... 

;)

">https://d2r1vs3d9006ap.cloudfront.net/s3_images/1219956/RackMultipart20150612-18862-nb5hnq-landshark_inline.JPG?1434120129">

supreme

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...

Did you get the domain trust setup since these machines are on two different domains?

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).

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.

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.

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.