10
2017
Error 17182 – TDSSNIClient initialization failed with error 0xd, status code 0x10
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 […]
25
2016
Windows Task Scheduler Error – transaction support within the specified resource manager is not started
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:\ […]
15
2016
Transaction log file full because of log_reuse_wait_desc=replication, CDC, goldengate
Came across weird situation where received alert for SQL Server transaction log file full and found log_reuse_wait_desc=replication from sys.databases Now before mentioning troubleshooting step, setup of the database is question is little bit complex because Database is part of SQL Server replication where database publisher is at vendor side and we don’t have access to publisher DB 🙁 Oracle Golden Gate replication is configured from this database to Oracle DB Database in question is […]
11
2016
How to: Run NETSH trace for Network monitoring/timeout captures
While trying to troubleshoot the mirroring timeout issues which was in milliseconds, came across recommendation by a MS engineer to enable NetSH, below are instructions on how to enable it and capture logs, the logs can be supplied to Network vendor for further analysis. Run following command to enable Netsh Netsh trace start capture=yes scenario=netconnection maxsize=2000 filemode=circular overwrite=yes report=no persistent=yes tracefile=c:\%computername%.etl Note: Please make sure you place this on a drive which […]
11
2016
Fix: Issue with Remote Desktop screen resolution while working from a high resolution system
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 […]
4
2016
Microsoft Announced updates to the SQL Server Incremental Servicing Model (ISM)
A good news for those who manage SQL releases, now CU updates are backed by Microsoft and one should not wait for SP releases, CU should be applied as early as possible, https://blogs.msdn.microsoft.com/sqlreleaseservices/announcing-updates-to-the-sql-server-incremental-servicing-model-ism/ Updates to Cumulative Update Messaging and Guidance: Over the years, as we released CUs (Cumulative Updates), you have become familiar with a certain type of deterrent messaging around those updates. Examples like the below messages often lead DBA’s to plan […]
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 […]
2
2016
Basic MySQL commands
While working on a simple data import from MySQL to MSSSQL, have to install MySQL as there is no workaround to import MySQL dump directly to SQL server, below are few commands used, Note: There is no way you can EASILY import MySQL dump in .sql format directly to any other data source like MSSQL or Access DB, better to have MySQL installed locally and import MySQL dump there and then link it to […]
19
2016
Fix: Cannot drop server because it is used as a Distributor in replication
While trying to drop a linked server received following error, Drop failed for LinkedServer ‘XYZ.ABC.COM’. (Microsoft.SqlServer.Smo)For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=10.50.6000.34+((KJ_SP3).140819-1214+)&EvtSrc=Microsoft.SqlServer.Management.Smo.ExceptionTemplates.FailedOperationExceptionText&EvtID=Drop+LinkedServer&LinkId=20476—————————–ADDITIONAL INFORMATION:An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)——————————Cannot drop server ‘XYZ.ABC.COM’ because it is used as a Distributor in replication. (Microsoft SQL Server, Error: 20581)For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=10.50.6525&EvtSrc=MSSQLServer&EvtID=20581&LinkId=20476 After going through online posts, found following script to drop distributor settings on Pinal Dave site (link), EXEC sp_dropdistributor @no_checks = 1, @ignore_distributor = 1 […]
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 = […]
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