Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

How to login to the Ms SQL Server

  1. Request a local server admin account
  2. VPN to the server or RDP through hopperrdp.cit.cornell.edu
  3. Using Microsoft SQL Server Management Studio and enter information

Image Added

Server Inventory (as of November 02, 2018)

Customer/ProspectContactServer LocationServiceDB Name/CountCloud (Y/N)ReleaseOSLevelAuth. ModeNOTES
CRISJeffrey Silbersf-dfacit-db-02SF-DFACIT-DB-02multiple (41)No2012W2012ProdWindows 
CALS Mike Barresf-cals-dbstage.serverfarm.cornell.eduSF-CALS-DBSTAGEmultiple (9)EC2 - Dedicated 2017W2016Prod/TestWindows 
CALS Mike Barreadmincomp-proddb1.cals.cornell.eduCALSPRODmultipleNo2008 R2W2008ProdWindowsBeing replaced end of 2019
CALS Mike Barreadmincomp-db1.cals.cornell.eduCALS_RS_TESTmultipleNo2008 R2W2008TestWindowsBeing replaced end of 2019
CALS Mike Barreadmincomp-devdb2.cals.cornell.eduCALS_SANDBOXmultipleNo2008 R2W2008SandboxWindowsSee Comment - Being replaced
Media SiteAndy Pagesf-dublin07.serverfarm.cornell.eduSF-DUBLIN07multipleNo2008 R2W2008ProdWindowsRetired Sept 2018
Crestron Room ViewAndy Pagesf-dublin08.serverfarm.cornell.eduSF-DUBLIN08multiple(2)No2008 R2W2008ProdWindows 
Extron GVEAndy Pagesf-dublin09.serverfarm.cornell.eduSF-DUBLIN09multipleNo2008 R2W2008DevWindowsRetired Aug/2017 See Comments
TMS DatabaseAndy Pagesf-dublin10.serverfarm.cornell.eduSF-DUBLIN10multipleNo2008 R2W2008ProdWindowsRetired Sept 2018
TMS DatabaseAndy Pagesf-zappa004.serverfarm.cornell.eduSF-ZAPPA004multiple (2)No2016W2012ProdWindows 
Crestron Room ViewAndy Pagesf-dublin11.serverfarm.cornell.eduMSSQLSERVERmultiple (4)No2008 R2W2012TestWindows 
ODAA/SandBoxN/Asf-dublin12.serverfarm.cornell.eduSF-DUBLIN12multipleNo2016W2012SandboxWindows 
Video Software TMSAndy Pagesf-york21.serverfarm.cornell.eduSF-YORK21multiple (3)No2008 R2W2008ProdWindows 
Security (Remedy Scan)Eric Nobelsf-dublin16.serverfarm.cornell.eduSF-DUBLIN16cornell_prd_arNo 2012W2012ProdWindows 
Facilities DB's (four apps)Dan Klingersf-dublin17.serverfarm.cornell.eduSF-DUBLIN17c2cbusEC2 - Dedicated 2017W2016ProdWindows 
Facilities DB's (four apps)Dan Klingersf-dublin17.serverfarm.cornell.eduSF-DUBLIN17cupd_gisdbEC2 - Dedicated 2017W2016ProdWindows 
Facilities DB's (four apps)Dan Klingersf-dublin17.serverfarm.cornell.eduSF-DUBLIN17FitProDataEC2 - Dedicated 2017W2016ProdWindows 
Facilities DB's (four apps)Dan Klingersf-dublin17.serverfarm.cornell.eduSF-DUBLIN17FS-PROSAFEEC2 - Dedicated 2017W2016ProdWindows 
Facilities DB's (four apps)Dan Klingersf-dublin17.serverfarm.cornell.eduSF-DUBLIN17gisdbEC2 - Dedicated 2017W2016ProdWindows 
Facilities DB's (four apps)Dan Klingersf-dublin17.serverfarm.cornell.eduSF-DUBLIN17MCMG2EC2 - Dedicated 2017W2016ProdWindows 
Facilities DB's (four apps)Dan Klingersf-dublin17.serverfarm.cornell.eduSF-DUBLIN17public_gisdbEC2 - Dedicated 2017W2016ProdWindows 
Facilities DB's (four apps)Dan Klingersf-dublin17.serverfarm.cornell.eduSF-DUBLIN17tmsfuelmasterEC2 - Dedicated 2017W2016ProdWindows 
Facilities DB (one app)Dan Klingersf-hanover02.serverfarm.cornell.eduHANOVER02mail meteringEC2 - Dedicated2014W2016ProdWindowsApp would only run on SQL 2014
Cindy Sedlacek/TableauCindy Sedlaceksf-hanover03.serverfarm.cornell.eduHANOVER03multipleEC2 - Dedicated2017W2016ProdWindows 
College Human EcologyRandi Rainbowsf-hanover01.serverfarm.cornell.eduHANOVER01\PRODmultipleEC2 - Dedicated 2017W2016ProdWindowsInstalled as "Named Instances"
College Human EcologyRandi Rainbowsf-hanover01.serverfarm.cornell.eduHANOVER01\ACAmultipleEC2 - Dedicated 2017W2016Dev/TestWindowsInstalled as "Named Instances"
College Human EcologyRandi Rainbowsf-hanover01.serverfarm.cornell.eduHANOVER01\DEVmultipleEC2 - Dedicated 2017W2016ProdWindowsInstalled as "Named Instances"
College Human EcologyRandi Rainbowsf-hanover01.serverfarm.cornell.eduHANOVER01\DEVGITmultipleEC2 - Dedicated 2017W2016Dev/TestWindowsInstalled as "Named Instances"
College Human EcologyRandi Rainbowsf-hanover01.serverfarm.cornell.eduHANOVER01\NADGANmultipleEC2 - Dedicated 2017W2016Dev/TestWindowsInstalled as "Named Instances"
Police David Brooksacp-jarvis.acp.cornell.eduACP-JARVISmultipleNo2014W2012ProdWindowsMust be logged in via VPN
Police David Brooksacp-birch.acp.cornell.eduACP-BIRCHmultipleNo2014W2012Dev/TestWindowsMust be logged in via VPN

 

Older inventory ...

 

 

...