Home » Posts tagged 'windows'
Tag Archives: windows
Write-Host || Cannot invoke this function because the current host does not implement it
Issue: While running powershell in SQL job step, I am getting below error: – A job step received an error at line 13 in a PowerShell script. The corresponding line is ‘Write-Host “ServerName: ” $comp’. Correct the script and reschedule the job. The error information returned by PowerShell is: ‘Cannot invoke this function because the … Continue reading
What’s new in SQL Server 2016 installation?
1) As MS is kept increasing number of option while installation. To reduce no. of click, if setup pass Rules it will automatically moves to Next window. 2) On Server Configuration page, MS specifically ask to GRANT PERFORM VOLUME MAINTENANCE TASK permission to service account. SQL Services needs this access to perform instant file initialization … Continue reading
Add Node to Windows Server 2008 Cluster
Steps : Add Node to Windows Server 2008 Cluster 1) Open Cluster Administration wizard > Right click on Windows Cluster & select Add Node 2) Add Node Wizard appears, Click Next to start 3) Browse Node to add, We select Node 3 to add 4) Select if you want to validate cluster settings or not … Continue reading
Steps for Windows Cluster Installation on Windows Server 2008
Here, You have steps with screenshot to install 2 Nodes windows cluster on Windows Server 2008. Step 1: Validate Cluster Configuration a) Open Cluster Administrator & click on “Validate a Configuration” b) Wizard for cluster validation appears, click Next c) Add Node to create cluster d) Select Type of test want to perform e) Confirmation … Continue reading
Connect PerfMon to a Remote Server
It seems to be a simple & easy thing to connect Perfmon to a remote server. GO TO RUN > Perfmon > Right Click “Connect to Another Computer” > Enter server name & you are done But I face several connectivity issue during connecting Perfmon from remote server. ISSUE 1: DNS not able to resolve … Continue reading