poniedziałek, 28 listopada 2016

If after configuring Event subscription, you see in Event Viever event with description "The description for Event ID XXX from source Microsoft-Windows-EventForwarder cannot be found. Either the component that raises this event is not installed on your local computer or the installation is corrupted. You can install or repair the component on the local computer." to solve this problem you should execute this command from Command Line (CMD) on machine who is collector:

wecutil ss YOUR_SUBCRIPTION_NAME /l:en-US

This method was tested on Windows Server 2008 R2 x64 SP1 with English United States regional / language settings.

sobota, 26 listopada 2016

On Windows Server 2012 R2 you should: 1) insert virtio-win ISO into optical drive, 2) browse content optical drive for find NetKVM driver for your operating system, right click on netkvm.inf and select Install. On Windows Server 2008 R2 after select Install from right click on netkvm.inf you see error The INF file you selected does not support this method of installation.

English version

I place below script in PowerShell.

Presented script executes the query SELECT * FROM [dbo].[TEST] to to SQL Server 2014 database named M03 on server: named LAB01 and instance named TEST01 using SQL Server authentication as user01 with password YourPassword!1. Before running the script, you should create a test table in the database from which will read the data.

If you run multiple times this script from another script (see below on the screen), you can test high availbility of your SQL Server 2014 SP2 databases (for example if you use AlwaysOn solution with automatic failover option).

English version

In order to prepare unattend installtion when you want install SQL Server many times, you can run the graphical installer and proceed to "Ready to install" page on which the is "Configuration file path".

ConfigurationFile.ini can be used to prepare unattend installation SQL Server - made of from command line (CMD) and not requiring answers to questions in graphical installer. To do this:
1. Copy ConfigurationFile.ini to - for example - local disk C.
2. Edit ConfigurationFile.ini - remove UIMODE="Normal" and save it
3. Open Command Line (CMD.EXE) and run follow command:

If during the validation of the failover cluster on Windows Server 2012R2 you see an error:"validate Active Directory Configuration - It cold not be determined whether node XXXXXX is a read-only domain controller because of this error: the object does not exists"

or during the create failover cluster you see an error:"There was an error cleaning up the cluster nodes. Use Clear-ClusterNode to manually clean up the nodes."

This means that you should update your server with Windows Update and you should not install failover cluster node on server who is domain controller.

Source: KB281662 - "It is not supported to combine the Active Directory Domain Services role and the Failover Cluster feature on Windows Server 2012"