Memorise

Archive for March 9th, 2020

Remove an old RDS from Server Pool (2012 R2)

First you have to install SQL Server Management studio on your RDS management/licensing server/all of your RDS connection brokers (if your have more than one, follow the below steps, rinse and repeat…):https://docs.microsoft.com/en-us/sql/ssms/download-sql-server-management-studio-ssms?view=sql-server-2017 Open up SSMS RUN AS ADMINISTRATOR and connect here:\\.\pipe\MICROSOFT##WID\tsql\query Open a query window, run this query: SELECT TOP 1000 [Id],[Name] FROM [RDCms].[rds].[Server] Look at the list […]