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 install SQL Server 2005 on a Windows XP machine

When we try to install SQL Server 2005 on a Windows XP with Service pack 3, we get the following error :   ————————— setup.exe – Application Error ————————— The application failed to initialize properly (0xc0150004). Click on OK to terminate the application. ————————— OK   ————————— We get this error message as soon as we…

2

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

Data Capturing and Analysis using SQL Server 2008 Activity Monitor and SQL DMV’s

In this blog, I will be sharing a unique instance of data capturing and analysis using SQL Activity monitor ,SQL DMV’s and also their correlation. We usually tend to see Activity monitor for a quick understanding of SQL health and resource consumption. Here is a scenario very close to Network IO in Activity monitor. Below…

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

Connectivity fails while executing queries against SQL through VBA code

Connectivity fails while executing queries against SQL through VBA code ************************************************************* When we execute queries against the SQL through VBA code generates the below error – and fails to complete the code execution. This issue occurs only while executing against the SBS Server: "[Microsoft][SQL Native Client]TCP Provider: A connection attempt failed because the remote host…

0

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

How to change Date Format after installing SQL server

In the below blog, I am going to share my experience on one of the unique case which I have worked couple of days back. The issue will arise if you have installed SQL with the default collation and your machine is using English (US). Now say for example you want to do business in…

16