You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 17 Next »

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
  PROD2014 SP1Christina Jane BuckoSept 2016 

Access through RDP servers.

Sensitive data environment

Keep 7 years of backup

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 
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-dublin12 SandBox2016 April 2016Activeaccess through hopperrdp
  • No labels