Browsing articles in "Issues and Resolutions"

Cannot connect to named instances of Analysis Services after fresh installation or rename of server

Many a times when a new SQL Server 2008 R2 analysis services instance is installed or a server is renamed then following error is received while trying to connect to named instance of analysis service,     ADDITIONAL INFORMATION:A connection cannot be made to redirector. Ensure that ‘SQL Browser’ service is running. (Microsoft.AnalysisServices.AdomdClient)——————————No connection could be made because the target machine actively refused it ::1:2383 (System)   This is mostly because of browser service account […]


Transaction rollback in progress. Estimated rollback completion: 0%. Estimated time remaining: 0 seconds

While dealing with a rollback/kill process (in SQL Server 2005 SP4 + CU3 environment) which is stuck for more than 10 days, it was a VERITAS NetBackup (DB tape backup) process,     On checking the DMV’s dm_exec_requests and dm_exec_sessions using below query, SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED SELECT db_id(DB_NAME(er.[database_id])) [DBID] ,er.[session_id] AS [SessionID] ,er.[command] AS [CommandType] ,est.[text] [StatementText] ,er.[status] AS [Status] ,CONVERT(DECIMAL(5, 2), er.[percent_complete]) AS [Complete_Percent] ,CONVERT(DECIMAL(38, 2), er.[total_elapsed_time] / 60000.00) AS [ElapsedTime_m] […]


SQL Server Installation failed with error status: 1639

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


SQL SERVER 2008 R2 not able to come online – Initializing the FallBack certificate failed

While applying a service pack on SQL Server 2008 R2, after server reboot, SQL service were unable to start and following error noted in SQL Error log, ———– Error: 17190, Severity: 16, State: 1. Initializing the FallBack certificate failed with error code: 1, state: 1, error number: -2146893788. Unable to initialize SSL encryption because a valid certificate could not be found, and it is not possible to create a self-signed certificate.   Error: 17182, Severity: […]


MAP toolkit v6.5 task generator failure error: Document Generator: An exception occurred – Unable to determine the identity of domain

In one of my environment MAP toolkit v6.5 is configured, when I ran discovery for SQL server, it resulted in around 1000+ SQL servers, now while generating SQL Server discovery proposal report task generator started failing and following error was found logged in file Microsoft.AssessmentPlatform.UI.Console.log located in %Program Files%\Microsoft Assessment and Planning Toolkit\bin\log\,     Note: We are not able to upgrade to latest MAP version (v8.0 at the time of writing this post) because […]


NetBackup ERR – Error in VxBSADeterminePolicy: 26 and ERR – Error in CryptAcquireContext : 2148073508

Kind of unique issue faced today, SQL Server backup job was continuously failing (with ERROR(-1) and exit status 2) to take database backups on Symantec NetBackup Utility. In GUI console following error was logged in,   USER – Verify that an active SQL Server policy exists for this client. ERR – Error in VxBSADeterminePolicy: 26. CONTINUATION: – There is no copy of the requested object.   This is not first time we were running backup, […]


Troubleshooting NetBackup Issues and Error Exit Codes

While working with Symantec NetBackup utility for SQL Server encountered several errors where backups are hanging in middle or failing with absurd error codes, below are some useful references and links which helps in troubleshooting such errors,   1. VDI related error:   Error message 1 2007-06-18 11:21:00.83 spid820 BackupVirtualDeviceFile::ClearError: failure on backup device ‘VDI_DeviceID‘. Operating system error 995(The I/O operation has been aborted because of either a thread exit or an application request.). Error […]


Write a Batch (.bat) file error handler for SQL instance down when fetching details from several SQL Servers

I have written several batch files to automate activities in SQL Server environment and send HTML reports over email on completion; but whenever SQL Server is down or server is unavailable then the HTML output get disturbed as no error handling is being done. When tried to write error handling to fix the issue, faced trouble as was using following code as part of an error handling,   FOR /F “tokens=1,2 delims=,” %%G in (%CD%\SQLServerList_SQLReport.txt) […]


Fix: Issue with SQL Agent not coming up due to agent error log path incorrect

SQL Server Agent was unable to come up and no error was being reported (only error we found as “SQL agent services started and then stopped”, nothing was logged in Event viewer as well), hence was unable to identify the actual error with which agent was failing, following is done to fix it,   1. Ran following command to read agent error log using query analyzer,                                 EXEC sys.xp_readerrorlog 0,2                 Output was: Msg 22004, […]


Service Unavailable : HTTP Error 503. The service is unavailable

After applying SQL Server service pack on one of SQL Server 2008, faced situation when user reporting then he is unable to open his webpage, he was receiving following error,   HTTP Error 503. The service is unavailable     After restarting OS, IIS 7.5 services as well received same error, finally found the solution as,   1. Open the Internet Information Services (IIS) Manager 2. Select the Application Pools node under the root node […]


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!



December 2020
« Nov    

View Post by Categories

%d bloggers like this: