March, 2010

One of the Best practice for database mirroring(DBM) is to setup DBM on dedicated NIC card\Network adapter, as mentioned in http://msdn.microsoft.com/en-us/library/cc917681.aspx The idea is to transport the mirroring traffic via a dedicated network...

Problem Description =============== Not able to connect to SQL Server 2008 instance after applying SP1. Connection would fail with the following error TITLE: Connect to Server ------------------------------ Cannot connect to <Server...

I have been asked by many customers and seen in many social sites, people were asking about the procedure of scheduling SSAS profiler traces so one fine day thought of writing a utility. I have developed a small application which will help in scheduling...

SQL Server 2008 setup may fail with the following error even though you are running the setup as administrator. You might get these kind of errors in Detail.txt after you cleaned up an failed setup (from Add/Remove Programs) and try to run the setup again...

We are starting a series for DBAs and others who want to create a SQL Cluster on Hyper-V. This series would help you to create a play ground using Hyper-V and creating Windows 2008 Cluster and installing SQL Server 2008 on top of it. To get started, we...

Problem Description =============== Encountered the following error message when tried to connect to Enterprise manager in SQL Server 2000 A connection could not be established to (LOCAL). Reason: Client unable to establish connection Unable...

Problem Description: =============== While connecting to SQL Server 2005 Express instance through BackupExec application , we might encounter a connection failure. And the following error message would be logged in the Application event viewer logs...

Here is one of the rare scenario on SQL Server memory issue (701 error) caused due service broker misconfiguration or incorrectly used, causing memory object OBJECTSTORE_SERVICE_BROKER to grow and not releasing memory back. Below is the memory error,...

SYMPTOMS: ========== Installation for SQL Server 2008 Management studio fails with the MSI error code: 0x5EBE5729 //////////////From Summary.txt//////////////////// Feature: Management Tools - Complete Status: Failed: see logs for details...

Installation of SQL Server 2000 Service Pack 4 on cluster environment may appear hung while installing MDAC Component on the remote machine Consider a scenario wherein the Service Pack 4 on SQL Server 2000 Enterprise Edition is failing or get hung...

Recently I encountered an issue where the in-place upgrade of the SQL Server 2005 to SQL Server 2008 on the Windows Server 2003 cluster failed with following error: TITLE: Microsoft SQL Server 2008 Setup ------------------------------ The...

Recently we have encountered the following error message while configuring Database Mail in SQL server 2005. Create new account 'XXXX' for SMTP server 'XXXX' (Error) Messages Unable to update account XXXX for SMTP server Microsoft.SqlServer...

I had a situation where I needed to install SQL Server 2008 Express edition with management studio and also upgrade it to SP1 using just one installer. It does not sound impossible as we already have a similar installer that can install SQL Server 2005...

Some of you may experience problems while using Database Mail on SQL Server 2005 or SQL Server 2008 which will not be able to send emails to the database users. The SQL Server error logs will log following errors: The activated proc [dbo].[sp_sysmail_activate...

BEHAVIOR/SYMPTOMS: We recently had a customer come to us seeking help on a performance issue that he was experiencing. Understood, that there’s a web-application written in ASP.Net and was using SQL Server at the backend. During the peak usage hours...

PROBLEM: When you open SQL Server 2008 configuration manager you do not see the following options : Scenario 1 (64 bit options): 1) SQL Native Client 10.0 configuration 2) SQL Server Network configuration Scenario 2 (32 bit...

When we use the option of -UseInProcLoader in Distribution agent profile, the distribution agent might fail with the following messages Cannot bulk load because the file %s could not be opened. Operating system error code 3(The system cannot find the...

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...