Versions Compared

Old Version 23

changes.mady.by.user Gary S. Chaika

Saved on

compared with

New Version 24

changes.mady.by.user Garry Chen

Saved on

Key

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

...

  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

Server Inventory

Customer/ProspectContactServer LocationServiceCloudReleaseLevelAuth. ModeNOTES
         
CRISJeffrey Silbersf-dfacit-db-02CRISNo2008 R2ProdWindows 
CALS Mike Barresf-cals-dbstage.serverfarm.cornell.edu EC2 - Dedicated 2017Prod/TestWindows 
CALS Mike Barreadmincomp-proddb1.cals.cornell.eduCALSPRODNo2008 R2ProdWindowsGroup: CornellVPN Username: netid@AG-vpn-admin-it: access through Dublin14/15 MS-Studio-Man
CALS Mike Barreadmincomp-db1.cals.cornell.eduCALS_RS_TESTNo2008 R2TestWindowsGroup: CornellVPN Username: netid@AG-vpn-admin-it: access through Dublin14/15 MS-Studio-Man
CALS Mike Barreadmincomp-devdb2.cals.cornell.eduCALS_SANDBOXNo2008 R2SandboxWindowsGroup: CornellVPN Username: netid@AG-vpn-admin-it: access through Dublin14/15 MS-Studio-Man
Media SiteAndy Pagesf-dublin07Media SiteNo2008 R2ProdWindows 
Crestron Room ViewAndy Pagesf-dublin08Crestron Room ViewNo2008 R2ProdWindows 
Extron GVEAndy Pagesf-dublin09Extron GVENo2008 R2DevWindowsRetired Aug/2017: DB backed up to E:\MSSQL_RDBMS_BACKUP_KEEP\ on Dublin16
TMS DatabaseAndy Pagesf-dublin10TMS DatabaseNo2008 R2ProdWindows 
Crestron Room ViewAndy Pagesf-dublin11Crestron Room ViewNo2008 R2TestWindows 
CU View Digital Signage
ODAA/SandBox 
Andy Page
sf-dublin12
CU View Digital Signage
SF-DUBLIN12\ODAAMSSQLSERVERNo
2008 R2
2016SandboxWindows 
Video Software TMSAndy Pagesf-york21.serverfarm.cornell.eduCU View Digital SignageNo2008 R2ProdWindows 
Facilities DB's (four apps)Dan Klingersf-dublin17Dublin17EC2 - Dedicated 2017ProdWindows 
FitProDan KlingerSF-FS-DBS-004  No2017ProdWindowsWill Go away once moved to cloud
Josh Woodard - CALSJosh Woodardsf-lobster01MSSQLSVRAGNo2014Dev/TestWindows 

 

 

Older inventory ...

Server NameServiceEnvironmentReleaseManagerDateStatusNote
        
sf-lobster01SF-LOBSTER01\MSSQLSVRAGDev/Test2014

Joshua Woodard

July 2016ActiveRDP through hopperrdp
admincomp-proddb1.cals.cornell.eduCALSPRODProd2008 R2Mike BarreMay 2016Active

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.eduCALS_SANDBOXSandBox2014Mike BarreMay 2016Active

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.eduCALS_RS_TESTTest2008 R2Mike BarreMay 2016Active

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-dublin07Media site Prod2008 R2Andrew M. PageJan 2016Active 
sf-dublin08Crestron Room ViewProd2008 R2Andrew M. PageJan 2016Active 
sf-dublin09Extron GVEDev2008 R2Andrew M. PageJan 2016Active

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-dublin10TMS DatabaseProd2008 R2Andrew M. PageJan 2016Active 
sf-dublin11Crestron Room ViewTest2012 R2Andrew M. PageJan 2016Active 
sf-york21CU View Digital SignageProd2008 R2Andrew M. PageJan 2016Active 
sf-dublin12SF-DUBLIN12\ODAAMSSQLSERVERSandBox2016 April 2016Activeaccess through hopperrdp