Deploy An SSIS Project To A Different Domain

Occasionally I run into a situation where I need to deploy an SSIS Project to a server on a different domain than my local PC is on. A lot of my work is done over VPN, so it’s pretty common for me to have my laptop on one domain and the SQL Server I need to deploy to is on another domain. This can get tricky, as I usually run in to the dreaded “Login is from an untrusted domain” error.

Thankfully, I’ve been able to find a handy little trick that allows me to easily deploy packages across a VPN to a different domain. It is called Runas. Runas is a command-line tool that is built into Windows, and as Microsoft states, it:

allows a user to run specific tools and programs with different permissions than the user’s current logon provides

By specifically using the /netonly and /user parameters of Runas, you can tell Visual Studio to use your Active Directory credentials for the domain you want to deploy to, and that should allow you to deploy successfully. It is actually incredibly simple to use, all you have to do is use Runas to open Visual Studio, and then you will be able to deploy across the VPN as normal.

Now, before I show you the code I use, I want to clarify a couple of things:

  1. I am testing this using Visual Studio 2015 on Windows 10. I have no idea if this works with other VS/Windows combinations
  2. You have to have a working AD account with appropriate permissions on the domain you’re trying to deploy to

Below is the command I run to open Visual Studio with Runas. Simply replace YourDomain\YourUser with your Active Directory account for the domain you want to access, and you may need to modify the path to VS if you are using a different version.

That’s it. When I run that command, it asks for the password for the AD account I specified, and thens open Visual Studio after I supply the password.  Once VS opens, I am then able to go through the deployment wizard as usual. I actually have this saved as a batch file that I can click whenever I’m ready to deploy my SSIS project.  That way it’s not even really an extra step, I just click the batch file instead of the Visual Studio icon.

 

(Visited 4,445 times, 1 visits today)

4 thoughts on “Deploy An SSIS Project To A Different Domain

  1. Boyd

    Brilliant! Thank you for showing me this little trick!

    • Boyd

      One minor caveat: typing your password when prompted by the command line does not check your credentials to make sure they are valid. If you enter an incorrect password, the program will still load, but you will be unable to connect once you try to deploy. Make sure the password is correct.

      • Eric Cobb Post author

        Thanks Boyd! I never realized that, that’s good to know!

  2. Hans Lindgren

    Thank you so much! This has bothered me for many many years…
    I do not know how much time I have been wasting trying to find alternate solutions until you explained how to do it the correct way!

Comments are closed.