Sometimes you have the need to connect to a SQL Server (or another resource) in another domain and you have(or want) to use windows authentication. This is possible by using the windows credential manager.

  • Open Credential Manager
  • Go to Windows Credentials
  • Click “Add a Windows credential”
  • Fill in the servername (and port-number when connecting to SQL) in the “internet of network adrress”-field.
  • In the username field fill in the windows account you want to use, don’t forget to include the domain eg YOURDOMAIN\USERNAME.
  • Populute the “Password” field with the correct password.
  • Click Ok

The only thing you might still have to do is add the servername (add corresponding IP) to your host file because your DNS-Server probably won’t be able to resolve the servername.