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

If you are frustrated with others not keeping their mailbox clean and you are landing up with 10’s to 100’s of undelivered mail notifications landing up directly to your inbox, then don’t worry this post may be useful for you to some extent 🙂 Note: this is not a tool tip, but usage of a very well-known feature of outlook i.e. Rules Here is a short, simple and clean method to create a filter i.e. […]

My BMC client tool was not working and giving one of dll missing error, so I fixed it by following, Follow link: http://www.addictivetips.com/windows-tips/fix-msvcp71-dll-and-msvcr71-dll-missing-error-in-windows-7/ Download dll files from the Mirror 1 link given in above link It fixed the said issue for me, it’s tried and tested! so no harmful affect. Hope it helps!

Found following error in SQL Server 2008 R2 error logs, Error: 17828, Severity: 20, State: 4. The prelogin packet used to open the connection is structurally invalid; the connection has been closed. Please contact the vendor of the client library. [CLIENT: <IP Address>] Although various blogs and articles says that this is timeout error and generally be seen if your SQL Server is evaluation copy which got expired, but I didn’t found any of such […]

If you are a DBA and you need to track the current release of SQL Server build then this link will come handy, use it at your wish as it’s not official page but a blog community page, http://sqlserverbuilds.blogspot.ca/ Excerpt as of writing this article, Quick summary:   RTM (Gold, no SP) SP1 SP2 SP3 SP4 SQL Server 2012codename Denali 11.00.2100.60 CTP       SQL Server 2008 R2codename Kilimanjaro 10.50.1600.1 10.50.2500 10.50.4000     […]

Environment: SQL Server 2005 x64 SP3 Issue: While checking a SQL Agent status, found it stopped and when tried to start it is giving following error, The SQL Server Agent (MSSQLSERVER) service on Local Computer started and then stopped. Error: When checked SQLAgent error log file SQLAgent.out (generally located at: %ProgramFiles%\Microsoft SQL Server\<InstanceName>\MSSQL\Log\ or you can check the location of error logs in the startup parameters in advanced tab of SQL services or in Windows […]

You might be wondering that in Microsoft Outlook 2010 where we can find the source of message sender, please find the simple tip below to understand how this can be done. Note: For those who are wondering what is source, it is a way to identify the ip address of sender and this is one way the junk/spam mails are detected, you can read more about it on internet. 1. Within Outlook 2010, open an […]

Scenario is when you are trying to open or upgrade SSIS package created in SQL 2005 to SQL 2008 R2 then you may encounter below error and your package upgrade will fail, please find few tips on resolving this error below.   Error Description: Failed to decrypt protected XML node “DTS:Property” with error 0x8009000B “Key not valid for use in specified state.”. You may not be authorized to access this information. This error occurs when […]

Scenario is, we have SQL 2000 as database engine and outlook 2007 as mail client, now as we know SQL 2000 requires MAPI client for SQL mail configuration and from records we need minimum Outlook 2000 client, in this case we have outlook 2007 client present. I was skeptical initially that whether SQL mail will at all work with outlook 2007 or not, by going through several articles and forums, I found it to be […]

You may find yourself in situation where you need to change Server level collation or need to rebuild system databases, then following article will be helpful, 1. First detach all user databases 2. Script any logins (if exists) using sp_help_revlogin (get one from MSDN for e.g. http://support.microsoft.com/kb/246133 , http://support.microsoft.com/kb/918992 3. Script Maintenance plans/Jobs (if can’t be created again) 4. Execute following on command line by going to the folder where appropriate setup of SQL Server […]