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

Nov
6
2012

How to: create Filter on Undelivered Emails in MS Outlook

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

Nov
1
2012

Fix Msvcp71.dll And Msvcr71.dll Missing Error In Windows 7

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!

Oct
30
2012

The prelogin packet used to open the connection is structurally invalid; Error: 17828

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

Oct
25
2012

Microsoft SQL Server Build chart and links – all versions from 7.0 to 2012

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

Oct
25
2012

SQLServer Error: 17750, Could not load the DLL xpstar90.dll

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

Oct
19
2012

How to: Check full source of email sender in Outlook 2010

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

Jul
3
2012

SSIS package 2k5-> 2k8 R2 upgrade failed with error – Failed to decrypt protected XML node “DTS:Property”…

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

Jul
2
2012

Configure SQL Mail on SQL Server 2000 with Outlook 2007 client

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

Jun
29
2012

Changing SQL Server Collation / Rebuilding system databases

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

Subscribe to this blog via Email

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

Join 260 other subscribers

Translate this blog!

EnglishFrenchGermanItalianPortugueseRussianSpanish

Calender

September 2020
M T W T F S S
« Nov    
 123456
78910111213
14151617181920
21222324252627
282930  

View Post by Categories

%d bloggers like this: