Faced with a problem during prerequisite check of SCCM 2012 R2 installation.
what i have:
Remote SQL server - MS SQL 2012 CU11 on Windows Server 2012 R2
SCCM R2 server - SCCM R2 on Windows Server 2012 R2
on Database Information page i enter SQL server FQDN and database name; instance is default. Service Broker Port is by default 4022.
when i press Next error dialog appears:"Requested registry access is not allowed".
Firewall on both SCCM and on SQL server is OFF from beginning.
I tried with firewall on and rules for incoming session for all SQL ports but no way.
Port 1433 is open and OK but 4022 is not accessible and I think error above is because of this. SQL Dynamic ports is disabled also.
I added user account to local admin group on remote SQL but did not add server computer. After adding server account as local admin on remote SQL issue seems to be solved.
Also on SQL instance I already
With cloud storage prices going down a growing number of SMBs start to use it for backup storage. Unfortunately, business data volume rarely fits the average Internet speed. This article provides an overview of main Internet speed challenges and reveals backup best practices.
Load balancing is the method of dividing the total amount of work performed by one computer between two or more computers. Its aim is to get more work done in the same amount of time, ensuring that all the users get served faster.
Familiarize people with the process of utilizing SQL Server functions from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Ac…