Browsing articles in "Powershell"
Feb
11
2016

List of Free Database and PowerShell Tools

021116_1954_ListofFreeD1.png

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 […]

Oct
14
2015

SQL Server to Oracle Linked server error 7303: ORA-12504 listener was not given the service_name in connect_data

101415_1631_SQLServerto1.png

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 = […]

Dec
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 […]

Dec
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 […]

Nov
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

Enter your email address to subscribe to this blog and receive notifications of new posts by email.

Join 457 other subscribers

Translate this blog!

EnglishFrenchGermanItalianPortugueseRussianSpanish

Calender

August 2017
M T W T F S S
« May    
 123456
78910111213
14151617181920
21222324252627
28293031  

View Post by Categories

%d bloggers like this: