System Center SQL

From Help
Jump to: navigation, search

Format: Brief Scope

Return to Main Page

Current TPFND settings

Configuration Manager

Name: TUL - TPFND Rack Server: SC-01.TPFND.CAT Site Server: SC-01.tpfnd.cat Build number: 7958 Version: 5.00.7958.1000 SQL Server Computer: SC-01.tpfnd.cat Administrative users: TPFND\Administrator

Roles

  • Application Catalog web service point
  • Application Catalog website point
    • CMApplicationCatalogSvc
  • Component server
  • Distribution point
    • PXE support: No
    • Multicast: No
  • Management point
    • Databasae: Use the site database
    • Management Point Connection Account: Use the computer account of the management point
  • Site database server
    • SQL Broker point: 4022
    • Enable data compression: Yes
    • Data retention: 5
  • Site server
  • Site system
    • Name: SC-01.tpfnd.cat
    • Site code: TUL-TPFND Rack
    • FQDN: N/A
    • Require the site server to intiate connections: No
    • Site System Installation accout: Site Server's computer account
    • AD forest: tpfnd.cat
    • AD domain: tpfnd.cat
    • Proxy: None

Operations Manager

SC-01 MSSQL

  • Microsoft SQL Server 2012 (SP4) (KB4018073) - 11.0.7001.0 (X64)
  • Standard Edition (64-bit) on Windows NT 6.3 <X64> (Build 9600: ) (Hypervisor)

Database name: CM_TUL Service Broker: Enabled Trusted: Yes Service Broker ID: a2215251-dd6d-42de-b582-9c80ef71c9c2

  • Permissions:
    • NT AUTHORITY\NETWORK SERVICE
      • Connect | dbo |Grant
      • View Definition
    • NT AUTHORITY\SYSTEM
      • all (effective)


Other

  • instance ID MSSQLSERVER
  • Data root directory: C:\Program Files\Microsoft SQL Server\
  • System database directory: C:\Program Files\Microsoft SQL Server\MSSQL12.MSSQLSERVER\MSSQL\Data
  • User database directory: C:\Program Files\Microsoft SQL Server\MSSQL12.MSSQLSERVER\MSSQL\Data\user
  • User database log directory: C:\Program Files\Microsoft SQL Server\MSSQL12.MSSQLSERVER\MSSQL\Logs\user
  • Temp DB Directory: C:\Program Files\Microsoft SQL Server\MSSQL12.MSSQLSERVER\MSSQL\Data\temp
  • Temp DB log directory: C:\Program Files\Microsoft SQL Server\MSSQL12.MSSQLSERVER\MSSQL\Logs\temp
  • Backup directory: C:\MSSQL11.MSSQLSERVER\Backup

Return to Top

Configuration Manager 2012

  • Database Engine Services
  • Reporting Services-Native and Management Tools – Complete.

Return to Top

Operations Manager 2012

  • Database Engine Services - Full-Text and Semantic Extractions for Search
  • Reporting Services - Native

Return to Top

Service Manager

  • Database Engine Services
  • Full-Text and Semantic Extractions for Search
  • Analysis Services
  • Reporting Services - Native


Return to Top

References

Return to Top