if you are using this connection string in SSIS using windows authentication
Data Source=myserver;Initial Catalog=mydb; Integrated Security=SSPI;Connect Timeout=15;You will be able to develop your package and run. When it’s get deployed to SQL Server and someone try to run the package, they will get this error.
The reason, windows computer is not joined with Active Directory.
If you still want to run your SSIS package on server, use SQL Server authentication and use this connection string;
Data Source=myserver;Initial Catalog=mydb;User Id=myuser;password=mypassword;Connect Timeout=15;Hope this will help
Add to favorites
