Browsing articles in "Issues and Resolutions"
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 […]

Apr
21
2014

SSRS 2008R2 Error: This implementation is not part of the Windows Platform FIPS validated cryptographic algorithms

While trying to open Report Manager URL via IE received HTTP STATUS CODE 500 error   In order to troubleshoot further, reporting log files are analyzed present in MSSRS root folder   Log file folder: <driver>:\Program Files\Microsoft SQL Server\MSRS10.MSSQLSERVER\Reporting Services\LogFiles\   Error logged: Error resolution: As per link, this error is because FIPS (Federal Information Processing Standard 140-1) Compliance was enabled and in order to meet certain standards this is required for audits. One option […]

Jan
1
2014

SQL Server CXPACKET waittype and MAXDOP settings – Tips

  Recently while troubleshooting performance issue on a server, found that the CXPACKET waittype is high,   WaitType Wait_S Percentage AvgWait_S AvgRes_S AvgSig_S CXPACKET 1402132.06 56.82 0.0067 0.0063 0.0004   CXPACKET waits in the server are not an immediate sign of problem; they may indicate another problem, associated with one of the other high value wait types in the instance for e.g. Queries are executing with parallelism   Now when dealing with CXPACKET waittype do […]

Oct
9
2013

How to restore SQL database on network share (UNC path) – SQL Server 2005

As it is known fact that by default SQL Server 2008 and below does not support database files on network shared path \\<sharepath>\<databaseFileName>.<mdf /ldf>, this is done because of certain performance and stability factor (read more about this in links present in reference section of this article). But in case if there is requirement to do a temporary restore on a network share then the below tip will come handy.   Note: SQL Server 2008R2 […]

Oct
7
2013

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

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

Pages:«12345»

Subscribe to this blog via Email

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

Join 263 other subscribers

Translate this blog!

EnglishFrenchGermanItalianPortugueseRussianSpanish

Calender

December 2020
M T W T F S S
« Nov    
 123456
78910111213
14151617181920
21222324252627
28293031  

View Post by Categories

%d bloggers like this: