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 (as of November 02, 2018)
| Customer/Prospect | Contact | Server Location | Service | DB Name/Count | Cloud (Y/N) | Release | OS | Level | Auth. Mode | NOTES |
| CRIS | Jeffrey Silber | sf-dfacit-db-02 | SF-DFACIT-DB-02 | multiple (41) | No | 2008 R2 | W2012 | Prod | Windows | |
| CALS | Mike Barre | sf-cals-dbstage.serverfarm.cornell.edu | SF-CALS-DBSTAGE | multiple (9) | EC2 - Dedicated | 2017 | W2016 | Prod/Test | Windows | |
| CALS | Mike Barre | admincomp-proddb1.cals.cornell.edu | CALSPROD | multiple | No | 2008 R2 | W2008 | Prod | Windows | See Comment - Being replaced |
| CALS | Mike Barre | admincomp-db1.cals.cornell.edu | CALS_RS_TEST | multiple | No | 2008 R2 | W2008 | Test | Windows | See Comment - Being replaced |
| CALS | Mike Barre | admincomp-devdb2.cals.cornell.edu | CALS_SANDBOX | multiple | No | 2008 R2 | W2008 | Sandbox | Windows | See Comment - Being replaced |
| Media Site | Andy Page | sf-dublin07.serverfarm.cornell.edu | SF-DUBLIN07 | multiple | No | 2008 R2 | W2008 | Prod | Windows | Retired Sept 2018 |
| Crestron Room View | Andy Page | sf-dublin08.serverfarm.cornell.edu | SF-DUBLIN08 | multiple(2) | No | 2008 R2 | W2008 | Prod | Windows | |
| Extron GVE | Andy Page | sf-dublin09.serverfarm.cornell.edu | SF-DUBLIN09 | multiple | No | 2008 R2 | W2008 | Dev | Windows | Retired Aug/2017 See Comments |
| TMS Database | Andy Page | sf-dublin10.serverfarm.cornell.edu | SF-DUBLIN10 | multiple | No | 2008 R2 | W2008 | Prod | Windows | Retired Sept 2018 |
| TMS Database | Andy Page | sf-zappa004.serverfarm.cornell.edu | SF-ZAPPA004 | multiple (2) | No | 2016 | W2012 | Prod | Windows | |
| Crestron Room View | Andy Page | sf-dublin11.serverfarm.cornell.edu | MSSQLSERVER | multiple (4) | No | 2008 R2 | W2012 | Test | Windows | |
| ODAA/SandBox | N/A | sf-dublin12.serverfarm.cornell.edu | SF-DUBLIN12 | multiple | No | 2016 | W2012 | Sandbox | Windows | |
| Video Software TMS | Andy Page | sf-york21.serverfarm.cornell.edu | SF-YORK21 | multiple (3) | No | 2008 R2 | W2008 | Prod | Windows | |
| Security (Remedy Scan) | Eric Nobel | sf-dublin16.serverfarm.cornell.edu | SF-DUBLIN16 | cornell_prd_ar | No | 2012 | W2012 | Prod | Windows | |
| Facilities DB's (four apps) | Dan Klinger | sf-dublin17.serverfarm.cornell.edu | SF-DUBLIN17 | c2cbus | EC2 - Dedicated | 2017 | W2016 | Prod | Windows | |
| Facilities DB's (four apps) | Dan Klinger | sf-dublin17.serverfarm.cornell.edu | SF-DUBLIN17 | cupd_gisdb | EC2 - Dedicated | 2017 | W2016 | Prod | Windows | |
| Facilities DB's (four apps) | Dan Klinger | sf-dublin17.serverfarm.cornell.edu | SF-DUBLIN17 | FitProData | EC2 - Dedicated | 2017 | W2016 | Prod | Windows | |
| Facilities DB's (four apps) | Dan Klinger | sf-dublin17.serverfarm.cornell.edu | SF-DUBLIN17 | FS-PROSAFE | EC2 - Dedicated | 2017 | W2016 | Prod | Windows | |
| Facilities DB's (four apps) | Dan Klinger | sf-dublin17.serverfarm.cornell.edu | SF-DUBLIN17 | gisdb | EC2 - Dedicated | 2017 | W2016 | Prod | Windows | |
| Facilities DB's (four apps) | Dan Klinger | sf-dublin17.serverfarm.cornell.edu | SF-DUBLIN17 | MCMG2 | EC2 - Dedicated | 2017 | W2016 | Prod | Windows | |
| Facilities DB's (four apps) | Dan Klinger | sf-dublin17.serverfarm.cornell.edu | SF-DUBLIN17 | public_gisdb | EC2 - Dedicated | 2017 | W2016 | Prod | Windows | |
| Facilities DB's (four apps) | Dan Klinger | sf-dublin17.serverfarm.cornell.edu | SF-DUBLIN17 | tmsfuelmaster | EC2 - Dedicated | 2017 | W2016 | Prod | Windows | |
| FitPro | Dan Klinger | SF-FS-DBS-004 | SF-FS-DBS-004 | multiple (2) | No | 2017 | W2008 | Prod | Windows | Being Replaced |
| Josh Woodard - CALS | Josh Woodard | sf-lobster01 | MSSQLSVRAG | multiple | No | 2014 | W2008 | Dev/Test | Windows | |
| College Human Ecology | Randi Rainbow | sf-hanover01.serverfarm.cornell.edu | HANOVER01\PROD | multiple | EC2 - Dedicated | 2017 | W2016 | Prod | Windows | Installed as "Named Instances" |
| College Human Ecology | Randi Rainbow | sf-hanover01.serverfarm.cornell.edu | HANOVER01\ACA | multiple | EC2 - Dedicated | 2017 | W2016 | Dev/Test | Windows | Installed as "Named Instances" |
| College Human Ecology | Randi Rainbow | sf-hanover01.serverfarm.cornell.edu | HANOVER01\DEV | multiple | EC2 - Dedicated | 2017 | W2016 | Prod | Windows | Installed as "Named Instances" |
| College Human Ecology | Randi Rainbow | sf-hanover01.serverfarm.cornell.edu | HANOVER01\DEVGIT | multiple | EC2 - Dedicated | 2017 | W2016 | Dev/Test | Windows | Installed as "Named Instances" |
| College Human Ecology | Randi Rainbow | sf-hanover01.serverfarm.cornell.edu | HANOVER01\NADGAN | multiple | EC2 - Dedicated | 2017 | W2016 | Dev/Test | Windows | Installed as "Named Instances" |
| Police | David Brooks | acp-jarvis.acp.cornell.edu | ACP-JARVIS | multiple | No | 2012 | W2008 | Prod | Windows | Must be logged in via VPN |
| Police | David Brooks | acp-birch.acp.cornell.edu | ACP-BIRCH | multiple | No | 2012 | W2008 | Dev/Test | Windows | Must be logged in via VPN |
| Customer/Prospect | Contact | Server Location | Service | Cloud | Release | Level | Auth. Mode | NOTES |
| CRIS | Jeffrey Silber | sf-dfacit-db-02 | CRIS | No | 2008 R2 | Prod | Windows | |
| CALS | Mike Barre | sf-cals-dbstage.serverfarm.cornell.edu | EC2 - Dedicated | 2017 | Prod/Test | Windows | ||
| CALS | Mike Barre | admincomp-proddb1.cals.cornell.edu | CALSPROD | No | 2008 R2 | Prod | Windows | Group: CornellVPN Username: netid@AG-vpn-admin-it: access through Dublin14/15 MS-Studio-Man |
| CALS | Mike Barre | admincomp-db1.cals.cornell.edu | CALS_RS_TEST | No | 2008 R2 | Test | Windows | Group: CornellVPN Username: netid@AG-vpn-admin-it: access through Dublin14/15 MS-Studio-Man |
| CALS | Mike Barre | admincomp-devdb2.cals.cornell.edu | CALS_SANDBOX | No | 2008 R2 | Sandbox | Windows | Group: CornellVPN Username: netid@AG-vpn-admin-it: access through Dublin14/15 MS-Studio-Man |
| Media Site | Andy Page | sf-dublin07 | Media Site | No | 2008 R2 | Prod | Windows | |
| Crestron Room View | Andy Page | sf-dublin08 | Crestron Room View | No | 2008 R2 | Prod | Windows | |
| Extron GVE | Andy Page | sf-dublin09 | Extron GVE | No | 2008 R2 | Dev | Windows | Retired Aug/2017: DB backed up to E:\MSSQL_RDBMS_BACKUP_KEEP\ on Dublin16 |
| TMS Database | Andy Page | sf-dublin10 | TMS Database | No | 2008 R2 | Prod | Windows | |
| Crestron Room View | Andy Page | sf-dublin11 | Crestron Room View | No | 2008 R2 | Test | Windows | |
| ODAA/SandBox | sf-dublin12 | SF-DUBLIN12\ODAAMSSQLSERVER | No | 2016 | Sandbox | Windows | ||
| Video Software TMS | Andy Page | sf-york21.serverfarm.cornell.edu | CU View Digital Signage | No | 2008 R2 | Prod | Windows | |
| Facilities DB's (four apps) | Dan Klinger | sf-dublin17 | Dublin17 | EC2 - Dedicated | 2017 | Prod | Windows | |
| FitPro | Dan Klinger | SF-FS-DBS-004 | No | 2017 | Prod | Windows | Will Go away once moved to cloud | |
| Josh Woodard - CALS | Josh Woodard | sf-lobster01 | MSSQLSVRAG | No | 2014 | Dev/Test | Windows |
Older 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 | Retired: August 2017 A database backup named "GVE_backup_2017_08_02_000054_0577600.bak" taken on 2017/08/02@11:29 was saved at dublin16 E:\MSSQL_RDBMS_BACKUP_KEEP\dublin09_GVE_save for 1 year |
| 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 |