While Installing SQL 2005 Express Edition we hit the error — The SQL Server System Configuration Checker cannot be executed due to WMI configuration on the machine <Computer Name> Error:2147749896 (0x80041008)

Symptoms:   Application Popup Error: =========================== The SQL Server System Configuration Checker cannot be executed due to WMI configuration on the machine <Computer Name> Error:2147749896 (0x80041008).   [Environment] =========================== Windows XP home Edition Service Pack 2   SQL Version: SQL2005 Express Edition SQL Service Pack: RTM   Troubleshooting this Issue ======================= Application popup Error: —————————————-…


SQL Server 2005 setup fails on windows 2008 due to corrupt VC++ component

Here is a scenario where you might end up receiving a Fatal Error while installing SQL 2005 on Windows 2008 environments. Below is the snippet from the Setup logs:   Summary Log: ========== OS Version      : Server 4.0, Enterprise Edition Service Pack 2 (Build 6002) Time            : Sun Apr 18 07:45:43 2010   Machine         :…


BCP in SQL server 2005 does not truncate a column

BEHAVIOR/SYMPTOMS:During a BCP operation in SQL 2005, a column with less precision gets truncation errors.BCP in SQL Server 2000 didn’t report truncation errors which could affect business logic in applications where precision data up to a certain decimal value is required. BCP for SQL Server 2005 reports the truncation errors and will not round off/truncate…


Error messages and the solutions related to “distributor_admin” login

Error messages: The log reader fails with the following error message: ============================================== The process could not execute ‘sp_MSpub_adjust_identity’ on ‘PR2K8\YUKON’. (Source: MSSQL_REPL, Error number: MSSQL_REPL20011) Get help: http://help/MSSQL_REPL20011 Login failed for user ‘distributor_admin’. (Source: MSSQLServer, Error number: 18456) Get help: http://help/18456 Snapshot Agent may fail with this error: ========================================= Could not retrieve agent status. (Login…

5

Unable to view Error logs in SQL Server Management Studio on a cluster

While trying to view the SQL Error logs in SQL Server Management Studio or using xp_readerrorlogs it internally executes sp_enumerrorlogs. And sp_enumerrorlogs – tries to execute the below command:          serverproperty(‘ServerName’) – The command was providing the cluster name(CLUS180633) instead of the SQL virtual server name (SQL). – Further examination of the registry revealed the…

3

SQL 2005 (SQL 2008) Analysis Services Server Side Tracing

With Analysis Services 2005 (2008) you can collect traces without using gui this feature is known as Server Side Tracing. In this article we’ll talk about how to achieve Server Side Tracing. How to create a Server Side Trace Open SQL Server profiler connect to Analysis Services and in an Event Selection define the SSAS…

5

Installation of Service Pack 3 for Reporting Services 2005 fails on a cluster with an error code 2228

The setup of the Microsoft products is considered to be extremely easy. Mostly one need to click on few “Next” buttons and the setup is done. But when the setup fails, it can be extremely interesting. I encountered one such interesting setup failure. The installation of the SQL Server service pack 3 was failing for…

1

On a Clustered SQL Server 2005 running on Windows 2003 machine the maintenance plan MIGHT fail with: “The LoadFromSQLServer method has encountered OLE DB error code 0x80004005 (Login timeout expired)”

On a Clustered SQL Server 2005 running on Windows 2003 machine the maintenance plan fails with below error.  This issue is also seen on a newly created a maintenance plan as well. Executed as user: <Domain>\User. Microsoft (R) SQL Server Execute Package Utility  Version 9.00.4035.00 for 32-bit  Copyright (C) Microsoft Corp 1984-2005. All rights reserved.   …

5