I am attempting to execute a DTS package from a client computer using visual basic and the SQLNS object.
I wish to use SQLServer authentication.
When I execute a function that calls the DTS package the initialisation of the SQLNamespace object executes successfully. However, when the ExecuteCommandByID method is called & the DTS progress window is displayed i get an error stating that the first task failed due to not having a trusted connection.
When I execute this function when a trusted connection is in place it runs successfully.
I ran a trace to investigate this issue.
It appears that the initialisation runs with the SQLServer login supplied to the Initialize method and the application name of Visual Basic.
When the ExecuteCommandByID method is called, the SQLServer account logs out, a trusted connection logs in and executes the DTS steps with an application name of DTS Designer. Therefore if a trusted connection is not in place the DTS fails.
Can anyone tell me how to make the DTS Designer log in using SQL Server authentication?
I wish to use SQLServer authentication.
When I execute a function that calls the DTS package the initialisation of the SQLNamespace object executes successfully. However, when the ExecuteCommandByID method is called & the DTS progress window is displayed i get an error stating that the first task failed due to not having a trusted connection.
When I execute this function when a trusted connection is in place it runs successfully.
I ran a trace to investigate this issue.
It appears that the initialisation runs with the SQLServer login supplied to the Initialize method and the application name of Visual Basic.
When the ExecuteCommandByID method is called, the SQLServer account logs out, a trusted connection logs in and executes the DTS steps with an application name of DTS Designer. Therefore if a trusted connection is not in place the DTS fails.
Can anyone tell me how to make the DTS Designer log in using SQL Server authentication?
