Module: Developers - Patterns & Practices

πŸ“– Using Windows Credential Manager to access domain resources

Created 5 years ago by Kiki Biancatti|

Modified 3 years ago by Tom Iwainski

If your machine is not domain-joined, it is common to have troubles to access resources at SSW's domain, or even client's domains...

E.g. a recurring pain at SSW is not being able to use SSMS (SQL Server Management Studio) from your machine to connect to our on-premises SQL servers using Windows Authentication:

Figure: None of the options let you run the authentication as a domain user

To fix this, you can use Windows Credential Manager! You can configure it to use a specific username and password when connecting to a specific server:

  1. Start Menu | Search Credential Manager;
  2. Windows Credentials | Add a Windows credential;
  3. Internet or network address: the specific server name/IP address you are trying to access e.g. SYDSQL2016P01.sydney.ssw.com.au
  4. User name: SSW2000\YourUsername (This needs to be the domain user)
  5. Password: Your domain password
  6. Hit Ok
  7. Go back to SSMS | Windows Authentication (to the exact server you just filled at SSMS) | Connect
  8. You should be connected to the SQL database correctly on your computer's SSMS!

This works for other resources as well, SQL is just an example.