Access SQl server on KING County RDP sessions

Access SQl server on KING County RDP sessions

How to access KING County database/run simple queries using rds

  1. login to KING County RDS session

    1. https://rds.kingcounty.gov/rdweb/webclient/

    2. use this documentation if you run into issues or call KING County User Desk- they are super helpful.

      1. Link

      2. user Desk - King County Help Desk = 206-263-4357

      3. Our Agency is 947

  2. After logging in, All Resources/Your landing page > Find Microsoft SQl Server. Login to check LIVE data to Server name KCITEC2SQEPRP per screenshot below. Your RDS login should work.

  3. After logging in, Navigate to the tables, and look for data for agency_id=947

 

image-20240628-151527.png

 

image-20240628-151441.png

 

image-20240628-151847.png