To help you to write SQL statements for Configuration Manager reports, you can use the query design tool found in SQL Server Management Studio. For some administrators, it is much easier to use Query ...
This part covers the SQL Server installation and configuration for a SCCM 2012 R2 environment. SQL server will be installed on a dedicated server. (If SQL server is installed on the same server as the ...
1. Change registry key SqlCluster in HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL.x\Setup\ from 1 to 0 2. Disable TCP/IP in Server Network Protocols and enabled Named Pipes from ...
I am installing SQL server 2000 (standard edition) to support several different 'Administrative' packages I use at work.<BR><BR>Namely, Altiris, Mcafee Management Console, OpenManage to name a ...