Home » Windows
Category 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 current host does not implement it. ‘. Process Exit Code -1. The step failed.
Solution: SQL Server Agent allows users to directly run PowerShell scripts in SQL Server Agent. Internally this is implemented by reusing the SQLPS.EXE shell. When SQL Server Agent starts SQLPS.EXE, it does not do this through the console (there is no console attached).
When you run Write-Host, PowerShell asked to write on host console but due to no availability of HOST console, we got error.
I removed Write-Host to resolve issue.
Reference: Rohit Garg (http://mssqlfun.com/)
You can find and follow MSSQLFUN:-
http://www.facebook.com/mssqlfun
Other Linked Profiles :-
http://www.sqlservercentral.com/blogs/mssqlfun/
http://social.msdn.microsoft.com/Profile/rohitgarg
http://www.toadworld.com/members/rohit-garg/blogs/default.aspx
Error While running PowerShell code from SQL Agent job – “Path Does Not Exist”
Issue: When I am running code from PowerShell console its running fine but when I execute it through SQL agent job step, I am getting below error: –
The job script encountered the following errors. These errors did not stop the script: A job step received an error at line 14 in a PowerShell script. The corresponding line is ‘$files = Get-ChildItem “\\$comp\D$\*.xls”‘. Correct the script and reschedule the job. The error information returned by PowerShell is: ‘An object at the specified path \\ServerName\D$ does not exist. ‘ A job step received an error at line 43 in a PowerShell script. The corresponding line is ‘ $str = Get-Content $i.FullName | Where-Object { ($_ -match ‘Alive’) }’. Correct the script and reschedule the job. The error information returned by PowerShell is: ‘Cannot bind argument to parameter ‘Path’ because it is null. ‘. Process Exit Code -1. The step failed.
Solution: SQL Server Agent allows users to directly run PowerShell scripts in SQL Server Agent. Internally this is implemented by reusing the SQLPS.EXE shell. When SQL Server Agent starts SQLPS.EXE, It cannot access file system.
To access file system, you need to change the scope from SQL to filesystem.
You can do it by adding “cd C:” before executing filesystem commands.
Reference: Rohit Garg (http://mssqlfun.com/)
You can find and follow MSSQLFUN:-
http://www.facebook.com/mssqlfun
Other Linked Profiles :-
http://www.sqlservercentral.com/blogs/mssqlfun/
http://social.msdn.microsoft.com/Profile/rohitgarg
http://www.toadworld.com/members/rohit-garg/blogs/default.aspx
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 for data files instead of zero file initialization. (For information read – https://msdn.microsoft.com/library/ms175935)
3) 2 New Tabs in Database Engine Configuration page. One is TempDB configuration & other is User Instance feature.
4) Separate Acceptance page for Microsoft R.
Step by Step Installation :-
1. Setup Page, Choose First option
2. Setup checks for Global Rules and moves to next page, if all rules passed
3. Option to choose, if you want setup to download latest update and install
4. Initial Setup files installed
5. Check for installation rules and moves to next page, if all rules passed
6. Accept terms and condition, Click to Next
7. Select features you want to install
8. Check feature rule and moves to next page, if all rules passed
9. Select Instance name
10. Specify service accounts, you can also select collation from collation tab.
Here, MS specifically ask to GRANT PERFORM VOLUME MAINTENANCE TASK permission to service account. (For information read – https://msdn.microsoft.com/library/ms175935)
https://msdn.microsoft.com/library/ms175935
11. Select Authentication type
12. Select Data Directories
13. New Tab introduced to provide TempDB configuration at time of installation only
14. New Tab introduced for “User Instance” feature. Although, MS marked this feature to be removed. After this special tab, It seems MS changed his mind.
Refer – https://technet.microsoft.com/en-us/library/ms143684
15. Option to enable FileStream
16. Option for SSRS installation and configuration
17. New Page added for Microsoft R acceptance
18. Installation on the way
19. Installation Completed Successfully
Reference: Rohit Garg (http://mssqlfun.com/)
You can find and follow MSSQLFUN:-
http://www.facebook.com/mssqlfun
Other Linked Profiles :-
http://www.sqlservercentral.com/blogs/mssqlfun/
http://social.msdn.microsoft.com/Profile/rohitgarg
http://www.toadworld.com/members/rohit-garg/blogs/default.aspx
SQL Server Cluster LooksAlive and IsAlive Check
Windows Cluster Service use the “heartbeat” process to check whether each node is alive at both the OS level and SQL Server level. Heartbeat signals works on UDP.
Microsoft Windows Cluster service perform 2 health checks to perform node & resource availability check.
LooksAlive Health Check
1) LooksAlive is a quick lightweight health check
2) Run at interval of 5 Seconds
3) Does not impact performance but does not perform a thorough check
4) The check will succeed if the service appears to be running even though it might not be operational
5) If Fails calls “IsAlive” health check
6) Polling interval can be changed by adjusting LooksAlivePollInterval property of Cluster service
IsAlive Health Check
1) Run at interval of each 60 Second
2) Perform more detail check then LooksAlive
3) Run @@SERVERNAME to ensure that SQL Server is responding to queries
4) Does not ensure that all user databases are operational
5) Retired 5 times & then try to reconnect SQL Server
6) If all 5 retry fails, the SQL Server resource fails & Windows Cluster service will try to bring it online on other node as per configuration
7) Polling interval can be changed by adjusting IsAlivePollInterval property of Cluster service
Reference : Rohit Garg (http://mssqlfun.com/)
You can find and follow MSSQLFUN :-
http://www.facebook.com/mssqlfun
http://mssqlfun.com/feed
https://twitter.com/Rgarg86
Other Linked Profiles :-
http://www.sqlservercentral.com/blogs/mssqlfun/
http://social.msdn.microsoft.com/Profile/rohitgarg
http://www.toadworld.com/members/rohit-garg/blogs/default.aspx
http://beyondrelational.com/members/RohitGarg/default.aspx
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 & click Next
Note : Validation cluster settings is recommended
5) Validation a Configuration wizard will come, Click Next to start validation
6) Select type of test & click Next
7) Click Next to start Validation
8) Validation completed successfully(Warning to re configure quorum comes, we can ignore that), Click Finish to continue add node process
9) Click Next to start add process
10) Add node in process
11) Node 3 successfully added to cluster
Note : We need to reconfigure quorum to clear this warning.
If you liked this post, do like on Facebook at http://www.facebook.com/mssqlfun
Reference : Rohit Garg (http://mssqlfun.com/)