Browsing articles in "Windows"
May
25
2017

Antivirus Exclusion List for SQL Server

052517_1645_AntivirusEx1.png

After struggling a lot and working with vendor, identified list of exclusions for SQL Server related to Anti Virus Software (McAfee, Symantec, etc.), the details can be found in this link, last one is important as it impacts performance.   https://support.microsoft.com/en-us/help/309422/how-to-choose-antivirus-software-to-run-on-computers-that-are-running-sql-server   Directories and file-name extensions to exclude from virus scanning When you configure your antivirus software settings, make sure that you exclude the following files or directories (as applicable) from virus scanning. Doing this […]

Apr
10
2017

Error 17182 – TDSSNIClient initialization failed with error 0xd, status code 0x10

041017_1527_Error17182T1.png

Issue: While trying to restart SQL Service, it failed and following error found in error logs,   yyyy-mm-dd hh:mm:ss.xx Server Error: 17182, Severity: 16, State: 1. yyyy-mm-dd hh:mm:ss.xx Server TDSSNIClient initialization failed with error 0xd, status code 0x10. Reason: Unable to retrieve registry settings from TCP/IP protocol’s ‘IPAll’ configuration key. The data is invalid.   yyyy-mm-dd hh:mm:ss.xx Server Error: 17182, Severity: 16, State: 1. yyyy-mm-dd hh:mm:ss.xx Server TDSSNIClient initialization failed with error 0xd, status code […]

Jul
25
2016

Windows Task Scheduler Error – transaction support within the specified resource manager is not started

072516_1642_WindowsTask1.png

While deleting a task in task manager, received following error reported by my team,   Error: “transaction support within the specified resource manager is not started or was shutdown due to an error”     We tried multiple options to modify job and delete but nothing worked, On further google search found that issue is similar to found on following forum,   http://answers.microsoft.com/en-us/windows/forum/windows_7-performance/transaction-support-within-the-specified-resource/fba64f34-4c16-4551-82d7-f22169be0d97?auth=1   Executed following command on server, fsutil resource setautoreset true c:\   […]

May
11
2016

Fix: Issue with Remote Desktop screen resolution while working from a high resolution system

051116_1340_FixIssuewit1.png

Came across a unique issue on a friend’s laptop where he has high resolution screen but when trying to remote desktop any server then the remote server also inheriting the same resolution and text looks very small, MSTSC settings, desktop resolution settings, etc. everything is tried what possible but it didn’t fixed the issue. To resolve this, he found following solution to fix. Note: I am writing this post to keep a record of this […]

Jul
20
2015

SQL server setup failure – Updating permission setting for file E:\**** failed

072015_1536_SQLserverse1.png

While re-installing SQL server, got below error,       To fix this execute below commands with elevated access in command prompt so that permissions get applied to respective path,   Eg: takeown /F c:\Windows\system32\drivers /D y /R    In our scenario commands are provided below:   Here path is “F:” which is a parent folder.   takeown /F F: /D y /R   cacls F: /E /T /C /G “<<<user_AD_account_name>>>“:F

Jun
10
2015

Virtual Numa Overview – links

061015_1819_VirtualNuma1.png

Came across following links relevant to Virtual NUMA, read for additional knowledge,     Vmware: https://pubs.vmware.com/vsphere-55/index.jsp?topic=%2Fcom.vmware.vsphere.resmgmt.doc%2FGUID-A80A6337-7B99-48C8-B024-EE47E2366C1B.html     Hyper-v https://technet.microsoft.com/en-ca/library/dn282282.aspx

Oct
7
2013

Fix: Operating System Error 5 (failed to retrieve text for this error. Reason: 15105). (Microsoft.SQLServer.Smo)

100713_1042_FixOperatin4.png

When trying to take Microsoft SQL Server database backup to a network shared disk then receiving following error,     Error text: Cannot open backup device “\\xxxxxxxx\xxxx.bak” . Operating System Error 5 (failed to retrieve text for this error. Reason: 15105). (Microsoft.SQLServer.Smo)   The error may vary, you may also receive Operating system error 5(Access denied) and that too for local disk instead of network disk. But symptom is same.   Solution to fix this […]

Aug
20
2013

SQL Server Installation failed with error status: 1639

082013_1119_SQLServerIn1.png

Today while installing SQL Server 2008 R2 with SP1, installation failed with following error code, —————— MSI (s) (4C:9C) [04:51:32:016]: Product: SQL Server 2008 R2 SP1 Database Engine Services – Update ‘Service Pack 1 for SQL Server Database Services 2008 Core Instance (64-bit) (KB2528583)’ could not be installed. Error code 1639. Additional information is available in the log file C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log\20130820_043842\sql_engine_core_inst_Cpu64_1.log.   MSI (s) (4C:9C) [04:51:32:016]: Windows Installer installed an update. Product […]

Jul
12
2013

How to use NET USE and fix related errors

071213_1315_HowtouseNET1.png

NET USE command syntax:   net use [{devicename | *}] [\\computername\sharename[\volume] [{password | *}]] [/user:[domainname\]username] [/user:[dotteddomainname\]username] [/user:[[email protected]] [/home {devicename | *} [{password | *}]] [/persistent:{yes | no}] [/smartcard] [/savecred] [/delete] [/help] [/?]   Refer for more details: http://pcsupport.about.com/od/commandlinereference/p/net-use-command.htm   Examples of NET USE: Net Use Command Examples: net use * “\\server\my media” /persistent:no In this example, net use command is used to connect to the my media shared folder on a computer named server. The […]

May
29
2013

How to read/edit LARGE text files (size in GB ~ +50GB)

052913_0827_Howtoreaded3.png

When you try to open a text or some kind of text based log file of size in GB’s say 51GB in NOTEPAD or NOTEPAD++ or WORDPAD, you will get following error,     Now the question is how to read or edit such large file, answer is,   1. If you are just interested in reading it page by page without impacting any CPU or memory, the do following, Start > Run > type […]

Pages:123»

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: