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

Server 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 2016ActiveA 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