11
2016
List of Free Database and PowerShell Tools
This Article covers the list of Free database and PowerShell tools I come across time to time, this list will keep growing as I discover them, leave comments if you like any one tool better than other. SQL Server Database Health – dashboard overview for quick database health checks (http://databasehealth.com) Idera Free tools for SQL server: https://www.idera.com/productssolutions/freetools, below are some of best which I like, they are not totally free but works for […]
14
2015
SQL Server to Oracle Linked server error 7303: ORA-12504 listener was not given the service_name in connect_data
While configuring Linked server to oracle database from SQL server, faced following error, Error: “ORA-12504: TNS: listener was not given the SERVICE_NAME in CONNECT_DATA” (Microsoft SQL Server Error: 7303) I did following validation checks to ensure things are in place: Tnsnames.ora – validated that SID is present in tnsnames.ora file which is generally located in C:\Oracle\product\11.2.0\client_1\network\admin\ folder Validate syntax of connection string, it should be in below format, ORA123 = (DESCRIPTION = […]
24
2012
Get-WmiObject: The RPC server is unavailable (Exception from HRESULT: 0x80070721)
While I tried to use PowerShell to find disk space of a remote server using WMI query, Get-WmiObject -computer <myservername> win32_volume …faced following error/s, ——- Error 1: Get-WmiObject : The RPC server is unavailable Error 2: Get-WmiObject : A security package specific error occurred. (Exception from HRESULT: 0x80070721) —— After some Googling and search found some useful tips to troubleshoot the issue, please find below the consolidated troubleshooting steps, 1) Check that DCOM is enabled […]
4
2012
How to execute VBScript through a PowerShell Script
I was eagerly searching for a solution to call a VBScript through PowerShell script, after going through several articles and collecting information in bits and pieces from various sources written a very small and useful code, you can use it at your wish, My requirement: Call vbscript along with passing two arguments to it, one is server name and other one is a folder name. Command: 1. Declare $args to collect arguments (in this […]
19
2012
Powershell Connection Error: A security package specific error occurred. (Exception from HRESULT: 0x80070721)
Condition: When you are trying to execute any WMI command against a computer, it is resulting in following error, ————- PS C:\Users\testuser\desktop> Get-WmiObject -computer xxxxxxx win32_volume Get-WmiObject : A security package specific error occurred. (Exception from HRESULT: 0x80070721) At line:1 char:14 + Get-WmiObject <<<< -computer 162.53.32.223 win32_volume | Where-object {$_.DriveType -eq 3 -and $_.Label -ne “System Reserved”} + CategoryInfo : InvalidOperation: (:) [Get-WmiObject], COMException + FullyQualifiedErrorId : GetWMICOMException,Microsoft.PowerShell.Commands.GetWmiObjectCommand ————- Error: Get-WmiObject: A security package specific […]
Subscribe to this blog via Email
Old Posts
- November 2017 (3)
- October 2017 (4)
- September 2017 (2)
- May 2017 (1)
- April 2017 (1)
- July 2016 (3)
- May 2016 (1)
- April 2016 (1)
- February 2016 (2)
- January 2016 (1)
- October 2015 (1)
- September 2015 (1)
- August 2015 (1)
- July 2015 (2)
- June 2015 (3)
- April 2015 (1)
- March 2015 (1)
- December 2014 (1)
- September 2014 (2)
- April 2014 (1)
- January 2014 (3)
- October 2013 (2)
- September 2013 (2)
- August 2013 (4)
- July 2013 (1)
- June 2013 (2)
- May 2013 (5)
- April 2013 (3)
- March 2013 (1)
- February 2013 (9)
- January 2013 (11)
- December 2012 (14)
- November 2012 (3)
- October 2012 (4)
- July 2012 (2)
- June 2012 (3)
- May 2012 (2)
- April 2012 (8)
- March 2012 (6)
- February 2012 (3)
- January 2012 (1)
- December 2011 (5)
- November 2011 (8)
- October 2011 (5)
- September 2011 (3)
- August 2011 (3)
- July 2011 (3)
- May 2011 (1)
- November 2010 (1)
Tags
Calender
M | T | W | T | F | S | S |
---|---|---|---|---|---|---|
« Nov | ||||||
1 | 2 | 3 | ||||
4 | 5 | 6 | 7 | 8 | 9 | 10 |
11 | 12 | 13 | 14 | 15 | 16 | 17 |
18 | 19 | 20 | 21 | 22 | 23 | 24 |
25 | 26 | 27 | 28 | 29 | 30 | 31 |
View Post by Categories
Recent Articles
- Setting up Always ON Availability Group in Multi Subnet Cluster – Recommendations
- Configuring Replication with Always ON Availability Group
- Login failed for user ‘DOMAIN\COMPUTER$’. Reason: Could not find a login matching the name provided. [CLIENT: ]
- Modern Servicing Model (Service Pack and Cumulative Updates) for SQL Server 2017 and onwards
- Fix: SSMS 2012 opening Debug window when pressing F5