0

Code snippets : Enable remote administration on Windows Server 2012 Core

-

By default remote management on Windows Server 2012 Core can be blocked by firewall.

In order to enable this functionality, issue following command from Command Prompt window:


Netsh.exe firewall set service remoteadmin enable ALL

Once it’s done you should be able to manage server remotely.

0

How-To : SharePoint Foundation 2010 Installation

-

Screenshots from SharePoint Foundation 2010 installation process.

(more…)

0

Tips & Tricks : SQL Server “Cannot connect to WMI provider”

-

Recently I had issue which occured without any particular reason on SQL Server 2012. All of the sudden I start getting error message:

Cannot connect to WMI provider. You do not have permission or the server is
unreachable.
Note that you can only manage SQL Server 2005 servers with SQL
Server Configuration Manager.
Invalid Namespace.

when tried to run SQL Server Configuration Tools.

What resolved situation is command:

mofcomp C:\Program Files\Microsoft SQL Server\100\Shared\sqlmgmproviderxpsp2up.mof
25

How-to : Use SQL Server to query Active Directory

-

I think it’s common problem as Active Directory gets bigger in organizations, control over content of that mission-critical component seems to be lost. Same happened in my place. In addition to that we had to provide information from AD on a regular basis in a form of report. We had no tools to pull all data from AD, process it and present in some readable format. However, I was working with skilled SQL guy who was also very good in Reporting Services. So, I proposed that we can link Active Directory with SQL Server and use Transact-SQL to pull information from AD, process it on SQL and then make it readable and presentable through Reporting Services. That would allow SQL guy to process all information and do all kind of reporting required.

Here are components of our LAB environment before solution went to production:

And below steps how we made SQL Server 2008 R2 to work with Active Directory to use Transact-SQL queries to pull information from directory database.

(more…)

0

First look : System Center Operations Manager 2012 RC installation screenshots

-

As we can download SCOM 2012 RC from Microsoft, I decided to do quick installation in LAB environment. Whole test environment is based on VMware Workstation 8. Deployment of SCOM 2012 will be spread across few servers to separate certain functions (in fact similar to real-life deployments). For SCOM2012 deplyoment I will use following servers:

  • lab-dc-01 – Domain Controller – Windows Server 2008 R2
  • lab-sql-01 – SQL Server – Windows Server 2008 R2 + SQL Server 2008 R2
  • lab-net-01 – SCOM 2012 Management Server – Windows Server 2008 R2 + SCOM 2012 Management Server
  • lab-wks-01 – SCOM 2012 Management Console – Windows 7 x64 Ultimate + SCOM 2012 Management Console

This will be mainly screenshot tour through installation phases of SCOM2012.

Here is schematics of the lab:

(more…)