Running SQL Server Databases in the Amazon Cloud (Part 1)

By: Sadequl Hussain

http://www.mssqltips.com/sqlservertip/3251/running-sql-server-databases-in-the-amazon-cloud-part-1/?utm_source=dailynewsletter&utm_medium=email&utm_content=headline&utm_campaign=20140616

Connect to SQL Servers in another domain using Windows Authentication by Aaron Bertrand

By: Aaron Bertrand  http://www.mssqltips.com/sqlservertip/3250/connect-to-sql-servers-in-another-domain-using-windows-authentication/?utm_source=dailynewsletter&utm_medium=email&utm_content=headline&utm_campaign=20140610 Problem You may find that you need to connect remotely to a SQL Server that is in another domain. Since I work from home, I face this challenge all the time - almost every SQL Server I connect to is in another domain (and usually behind a VPN, a stingy firewall, and a stingier network team). This is a problem when SQL authentication is not an option, because my Windows machine is in its own domain; Management Studio cannot directly override the local Windows credentials and pass the credentials for a remote domain user. The easy answer is to simply establish a remote desktop session to the machine in question, and use Management Studioand other tools locally, but there are several challenges with that. Many corporations have policies in place that prevent tools like SSMS from being installed on the server, and some even resort to Server Core at least in part as a means to enforce this policy. They may not have a dedicated "jump" box to support remote desktop connections to the SQL Server machine, or they may have such a box, but without all of the tools you require. Solutions Read on Aaron's post....