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 | 2012 | 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 | Being replaced end of 2019 |
| CALS | Mike Barre | admincomp-db1.cals.cornell.edu | CALS_RS_TEST | multiple | No | 2008 R2 | W2008 | Test | Windows | Being replaced end of 2019 |
| 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 | |
| Facilities DB (one app) | Dan Klinger | sf-hanover02.serverfarm.cornell.edu | HANOVER02 | mail metering | EC2 - Dedicated | 2014 | W2016 | Prod | Windows | App would only run on SQL 2014 |
| Cindy Sedlacek/Tableau | Cindy Sedlacek | sf-hanover03.serverfarm.cornell.edu | HANOVER03 | multiple | EC2 - Dedicated | 2017 | W2016 | Prod | 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 | 2014 | W2012 | Prod | Windows | Must be logged in via VPN |
| Police | David Brooks | acp-birch.acp.cornell.edu | ACP-BIRCH | multiple | No | 2014 | W2012 | Dev/Test | Windows | Must be logged in via VPN |
Older inventory ...