Showing posts with label Windows. Show all posts
Showing posts with label Windows. Show all posts

Thursday, 21 December 2017

Test SQL Server connectivity from a Windows Server without installing another package

Recently I wanted to test whether a Windows 2016 server could connect to a SQL Server endpoint (happened to be an Azure SQL Database), but I was on a customers production web server and I didn't want to install tools (e.g. SSMS) to test, a quick google found this great solution, so I wanted to re-post it, many thanks to steverac for this gem.

https://blogs.msdn.microsoft.com/steverac/2010/12/13/test-remote-sql-connectivity-easily/

Monday, 14 August 2017

Stuck! How to change both the local admin account password and account name for an Azure Windows VM

I recently had to change both the account name and account password for a Windows VM running in Azure. Luckily, help is at hand thanks to some PowerShell and the VM Access Virtual Machine extension. No point in re-inventing the wheel, details are in the articles below...

https://blogs.technet.microsoft.com/askpfeplat/2016/02/08/resetting-the-local-admin-name-and-password-for-azure-arm-virtual-machines-with-powershell/

https://docs.microsoft.com/en-us/powershell/module/azurerm.compute/set-azurermvmaccessextension?view=azurermps-4.2.0