Tuesday, 4 April 2017
Installing SCCM 1606 Secondary Site
Sunday, 2 April 2017
SQL Ports and sql collation
netsh advfirewall firewall add rule name="SQL Admin Connection" dir=in action=allow protocol=TCP localport=1434
netsh advfirewall firewall add rule name="SQL Service Broker" dir=in action=allow protocol=TCP localport=4022
netsh advfirewall firewall add rule name="SQL Debugger/RPC" dir=in action=allow protocol=TCP localport=135
netsh advfirewall firewall add rule name="Analysis Services" dir=in action=allow protocol=TCP localport=2383
netsh advfirewall firewall add rule name="SQL Browser" dir=in action=allow protocol=TCP localport=2382
netsh advfirewall firewall add rule name="HTTP" dir=in action=allow protocol=TCP localport=80
netsh advfirewall firewall add rule name="SSL" dir=in action=allow protocol=TCP localport=443
netsh advfirewall firewall add rule name="SQL Browser" dir=in action=allow protocol=TCP localport=1434
netsh advfirewall firewall add rule name="ICMP Allow incoming V4 echo request" protocol=icmpv4:8,any dir=in action=allow
if you still get error like below " path not found" it means SMB ports are not open..
just enable file and print services in the firewall exception of SQL Server... see my youtube videos for this...
error:
sccm 2012 / 1511 /1606 Install Site Server Prerequisites
Install Site Server Prerequisites
The following roles and features need to be installed onto the SCCM Site Server prior to installation:
- BITS
- Remote Differential Compression
- IIS Components*
- .Net Framework 3.5
- .Net Framework 4.5
*Add the following IIS components
Common HTTP Features Default Document Directory Browsing HTTP Errors Static Content HTTP Redirection Health and Diagnostics HTTP logging Logging tools Request Monitor Tracing Performance Static Content Compression Security Request Filtering Basic Authentication IP and Domain Restrictions URL Authorization Windows Authentication Application Development .NET Extensibility 3.5 .NET Extensibility 4.5 ASP ASP.NET 4.5 ISAPI Extensions ISAPI Filters Management Tools IIS Management Console IIS 6 Management Compatibility IIS 6 Metabase Compatibility IIS 6 Management Console IIS 6 Scripting Tools IIS 6 WMI Compatibility IIS Management Scripts and Tools Management Service |