Browsing articles in "Tips & Tricks"
Jul
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 […]

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

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

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

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

Sep
18
2015

Outlook360: Lost emails older than 6 months after moving between folders

Faced unique issue when updating my outlook desktop client (Outlook 2013) linked to outlook360 account, issue and fix is as below,   Issue: I created a new temp folder in my inbox and moved all my items including the items older than 6 months from inbox to temp, after 1 day again move them back to inbox, the number of emails remained same. I had to move again for some work but when I moved […]

Jul
24
2015

Shrink Data file failed with Error 3140

While shrinking a large (950GB) database file to move data to a secondary NDF, got below 3140 error, it is a normal error occurs while shrinking files of that capacity, please find resolution below,   Error:   Environment: SQL Server 2005 ENT. ed.   Issue: Data file shrink fails for large data file size with Error: 3140   Fix: The following example query truncates the primary data file in the AdventureWorks2008R2 database. The sys.database_files catalog […]

Jul
20
2015

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

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

Apr
23
2015

SQL Server Configuration Manager – Cannot connect to WMI provider – Invalid class [0x80041010]

Error Screenshot:       Resolution: Open command prompt and execute below command,   mofcomp.exe “C:\Program Files (x86)\Microsoft SQL Server\100\Shared\sqlmgmproviderxpsp2up.mof”   Note: to cross verify, ensure that sqlmgmproviderxpsp2up.mof exists as above said location, if you are using SQL 2012 or later, go to appropriate shared folder on C: and update the command and execute   This will show results like below,     Now, SQL Server configuration manager should open fine without any issues.   […]

Dec
29
2014

SQL Server 2005 Reporting Services – Configuration Issues and Fixes

While dealing with a SQL Server 2005 Reporting configuration, faced multiple issues, below is list of issues and applied fixes along with some useful link to redirect in case freshly setting up SSRS.   Main issue which arises is Authentication, SSRS 2005 authentication is handled via IIS manager, and there are multiple options available for e.g. Integrated Windows authentication, Basic authentication, Anonymous Authentication. Based on security requirement one of these can be setup, easiest one […]

Subscribe to this blog via Email

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

Join 254 other subscribers

Translate this blog!

EnglishFrenchGermanItalianPortugueseRussianSpanish

Calender

August 2020
M T W T F S S
« Nov    
 12
3456789
10111213141516
17181920212223
24252627282930
31  

View Post by Categories

%d bloggers like this: