Home > SSIS Best Practices > Untrusted Domains – Need SQL Account because Windows Authentication will not work

Untrusted Domains – Need SQL Account because Windows Authentication will not work

I think it’s common for different domains in enterprise network not to trust each other fully. What does that mean to SQL developers who need to work from their local PC and be able to reach out to SQL servers on different domains?

A basic rule here is that we need a SQL account when crossing untrusted domains, because Windows Authentication will not work.

Your DBA or system admin can create a SQL account for you, or you can create one for yourself if you have the RDP right to remote into the box and be able to use Windows Authentication to login to the SQL server.   

Categories: SSIS Best Practices
  1. No comments yet.
  1. No trackbacks yet.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: