How to login to the Ms SQL Server
- Request a local server admin account
- VPN to the server or RDP through hopperrdp.cit.cornell.edu
- Using Microsoft SQL Server Management Studio and enter information
Server Inventory
| Server Name | Service | Environment | Release | Manager | Date | Status | Note |
|---|---|---|---|---|---|---|---|
| sf-lobster01 | SF-LOBSTER01\MSSQLSVRAG | Dev/Test | 2014 | Joshua Woodard | July 2016 | Active | RDP through hopperrdp |
| admincomp-proddb1.cals.cornell.edu | CALSPROD | Prod | 2008 R2 | Mike Barre | May 2016 | Active | Group: CornellVPN (cit.staff) Username: netid@AG-vpn-admin-it access through dublin02 using MS management Studio by windows authentication. CALS BDA: Velvet L. Saunders |
| admincomp-devdb2.cals.cornell.edu | CALS_SANDBOX | SandBox | 2014 | Mike Barre | May 2016 | Active | Group: CornellVPN (cit.staff) Username: netid@AG-vpn-admin-it access through dublin02 using MS management Studio by windows authentication. OR RDP to the server CALS BDA: Velvet L. Saunders |
| admincomp-db1.cals.cornell.edu | CALS_RS_TEST | Test | 2008 R2 | Mike Barre | May 2016 | Active | Group: CornellVPN (cit.staff) Username: netid@AG-vpn-admin-it access through dublin02 using MS management Studio by windows authentication. CALS BDA: Velvet L. Saunders |
| sf-dublin07 | Media site | Prod | 2008 R2 | Andrew M. Page | Jan 2016 | Active | |
| sf-dublin08 | Crestron Room View | Prod | 2008 R2 | Andrew M. Page | Jan 2016 | Active | |
| sf-dublin09 | Extron GVE | Dev | 2008 R2 | Andrew M. Page | Jan 2016 | Active | |
| sf-dublin10 | TMS Database | Prod | 2008 R2 | Andrew M. Page | Jan 2016 | Active | |
| sf-dublin11 | Crestron Room View | Test | 2012 R2 | Andrew M. Page | Jan 2016 | Active | |
| sf-york21 | CU View Digital Signage | Prod | 2008 R2 | Andrew M. Page | Jan 2016 | Active | |
| sf-dublin12 | SF-DUBLIN12\ODAAMSSQLSERVER | SandBox | 2016 | April 2016 | Active | access through hopperrdp |