November 3, 2015 at 3:34 pm
There is an SSIS package on a laptop which is not in a domain. I am trying to use SQL authentication to get connected from my laptop to the server and debug the package. It runs fine. When i try to deploy it to a server in a domain it is not recognizing the server. So i was not able to deploy the SSIS package.
I am getting the below mentioned Error Message.
Failed to connect to server. Microsoft sqlserver.ConnectionInfo)
Login failed. The login is from an untrusted domain and cannot be used with windows authentication. (Microsoft sql Server,Error :18452)
Destination server:
SQL Server 2012 Enterprise edition 64 bit version 11.0.2100.60)
Windows and SQL Server Authentication
Named Instance
SQL Server Browser is started and is setup to running , automatic
all services are running. Protocols are enabled. The service accounts are nt service accounts. They are not domain user accounts.
Source server:
SQL Server 2012 Enterprise edition 64 bit version 11.0.2100.60)
The sys admins may not honor the request to keep the server and the latop in a same domain.
If they are in the same domain there would not be a problem.
Am i missing any checks. I checked the SQL Server logs and Windows Application Logs.
Can you help me please.
Thank You
November 3, 2015 at 3:40 pm
I was able to deploy the package using ISDeploymentWizard.exe on the destination server. There is a flat file which is used as a source in the package. when the package is deployed on the destination server there are problems when connecting to that file. As a result the deployed package is failing.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply