SQL Server Management Studio : Windows Authentication from a non-domain-joined computer.
When trying to connect with an Windows integrated account to a domain-joined Microsoft SQL Server 2017 from a non-domain-joined computer or a computer joined to another non-trusted domain, you get a "login failed" on every connection attempts.
The solution (or workaround) is to use the Windows Credential Manager to pre-configure the domain user account to be trusted by SSMS with the following steps:
Open Credential Manager (type Credential Manager from the Start Menu)
Click "Add A Windows Credential"
Populate the network address field with the name and port number of the SQL instance you wish to store credentials. For example: MyMSSQLServer.domain.org:1433 (1433 is the default port, you may need a different port, especially if you are connecting to a named instance).
Populate the "User Name" including the domain name: "DOMAIN\Username"
Enter the "Password"
Done! Restart SSMS, try connecting to the remote SQL Server from your non-domain joined machine and this time your login should work!
Need a high throughput WAN solution? If latency isn't much of a concern, consider IPoAC. Effective throughput can approach 600 Gb/sec (depending on configuration/equipment used). Implementation costs can be under $1000 with ongoing maintenance costs of less than $50/month.
Topics cover everything from those justarting out to advanced techniques. This webinars are free to join and recordings are made available afterwards, so if you missed one that interested you, you can still get some valuable info. Enjoy!