Use SQL Server Management Studio to connect remotely to an SQL Server Express instance hosted on an Azure Virtual Machine
Use SQL Server Management Studio to connect remotely to an SQL Server Express instance hosted on an Azure Virtual Machine
Use SQL Server Management Studio to connect remotely to an SQL Server Express instance hosted on an Azure Virtual Machine
Re: Use SQL Server Management Studio to connect remotely to an SQL Server Express instance hosted on an Azure Virtual Machine
Here are the three web pages on which we found the answer. The most difficult part was setting up static ports for SQLEXPRESS.
[Provisioning a SQL Server Virtual Machine on Windows Azure](http://www.windowsazure.com/en-us/manage/windows/common-tasks/install-sql-server/). These initial instructions provided 25% of the answer.
[How to Troubleshoot Connecting to the SQL Server Database Engine](http://social.technet.microsoft.com/wiki/contents/articles/2102.how-to-troubleshoot-connecting-to-the-sql-server-database-engine.aspx). Reading this carefully provided another 50% of the answer.
[How to configure SQL server to listen on different ports on different IP addresses?](http://blogs.msdn.com/b/sqlblog/archive/2009/07/17/how-to-configure-sql-server-to-listen-on-different-ports-on-different-ip-addresses.aspx). This enabled setting up static ports for named instances (eg SQLEXPRESS.) It took us the final 25% of the way to the answer.
[Provisioning a SQL Server Virtual Machine on Windows Azure](http://www.windowsazure.com/en-us/manage/windows/common-tasks/install-sql-server/). These initial instructions provided 25% of the answer.
[How to Troubleshoot Connecting to the SQL Server Database Engine](http://social.technet.microsoft.com/wiki/contents/articles/2102.how-to-troubleshoot-connecting-to-the-sql-server-database-engine.aspx). Reading this carefully provided another 50% of the answer.
[How to configure SQL server to listen on different ports on different IP addresses?](http://blogs.msdn.com/b/sqlblog/archive/2009/07/17/how-to-configure-sql-server-to-listen-on-different-ports-on-different-ip-addresses.aspx). This enabled setting up static ports for named instances (eg SQLEXPRESS.) It took us the final 25% of the way to the answer.