Delphix Products

Expand all | Collapse all

Problems creating dSource for a SQL database

Jump to Best Answer

Adam Bowen06-12-2015 11:44:00 AM

Fabio Iovine06-12-2015 11:52:00 AM

Fabio Iovine06-12-2015 01:42:00 PM

Fabio Iovine06-12-2015 01:42:00 PM

Adam Bowen06-12-2015 02:22:00 PM

  • 1.  Problems creating dSource for a SQL database

    Posted 06-12-2015 09:02:00 AM
    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


  • 2.  RE: Problems creating dSource for a SQL database

    Posted 06-12-2015 09:38:00 AM
    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


  • 3.  RE: Problems creating dSource for a SQL database

    Posted 06-12-2015 10:13:00 AM
    checks done, everything is as expected to be...

    cheers,
    Fabio


  • 4.  RE: Problems creating dSource for a SQL database

    Posted 06-12-2015 11:03:00 AM
    Fabio,

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

    Thanks
    Giorgio


  • 5.  RE: Problems creating dSource for a SQL database

    Posted 06-12-2015 11:11:00 AM
    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?


  • 6.  RE: Problems creating dSource for a SQL database

    Posted 06-12-2015 11:15:00 AM
    Also, out of curiosity, are you running on an Italian version of Windows, or US English?


  • 7.  RE: Problems creating dSource for a SQL database

    Posted 06-12-2015 11:18:00 AM
    On 10.51.30.89 in <Install Dir>\Delphix\Delphix\Connector\logs, can you post the last 50 lines of the debug log?


  • 8.  RE: Problems creating dSource for a SQL database

    Posted 06-12-2015 11:41:00 AM
    Hi Adam,

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

    I'm wrong?



  • 9.  RE: Problems creating dSource for a SQL database

    Posted 06-12-2015 11:44:00 AM
    Nope. you are right and I am wrong. :)


  • 10.  RE: Problems creating dSource for a SQL database

    Posted 06-12-2015 11:50:00 AM
    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
    **********************




  • 11.  RE: Problems creating dSource for a SQL database

    Posted 06-12-2015 11:52:00 AM
    no, US English version... 


  • 12.  RE: Problems creating dSource for a SQL database

    Posted 06-12-2015 11:57:00 AM
    Fabio, validate it as a Target. (you chose source)


  • 13.  RE: Problems creating dSource for a SQL database

    Posted 06-12-2015 11:57:00 AM
    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




  • 14.  RE: Problems creating dSource for a SQL database

    Posted 06-12-2015 12:00:00 PM
    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
    **********************


  • 15.  RE: Problems creating dSource for a SQL database

    Posted 06-12-2015 12:02:00 PM
    Fabio, are you doing this with the Landshark environment (obvious that your SQL servers are your own)?


  • 16.  RE: Problems creating dSource for a SQL database

    Posted 06-12-2015 12:03:00 PM
    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


  • 17.  RE: Problems creating dSource for a SQL database

    Posted 06-12-2015 01:42:00 PM
    I'm gonna do it... 


  • 18.  RE: Problems creating dSource for a SQL database

    Posted 06-12-2015 01:42:00 PM
    ;)

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


  • 19.  RE: Problems creating dSource for a SQL database

    Posted 06-12-2015 02:22:00 PM
    supreme


  • 20.  RE: Problems creating dSource for a SQL database

    Posted 07-02-2015 02:47:00 PM
    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...


  • 21.  RE: Problems creating dSource for a SQL database

    Posted 07-02-2015 02:58:00 PM
    Did you get the domain trust setup since these machines are on two different domains?


  • 22.  RE: Problems creating dSource for a SQL database

    Posted 07-03-2015 06:37:00 AM
    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).





  • 23.  RE: Problems creating dSource for a SQL database
    Best Answer

    Posted 07-08-2015 11:08:00 AM
    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.


  • 24.  RE: Problems creating dSource for a SQL database

    Posted 07-08-2015 11:24:00 AM
    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.


  • 25.  RE: Problems creating dSource for a SQL database
    Best Answer

    Posted 07-09-2015 01:43:00 PM

    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.