Jun
7
2012

SQL 2005/2008/R2 N/W connection error troubleshooting steps

You may see 1001 n/w connection error when trying to connect remote sql server from ssms, I have compiled some best troubleshooting steps I am aware and few collected from various references,   First try to use one of five ways to connect SQL Server using SSMS, (for e.g. let’s say server name is ngmssql and instance name is sql001 and domain is ad.in.com and port is 1433 and ip address is 10.26.27.28)   • […]

Jun
1
2012

task completed with exit code of (1)

While executing a batch job (which I calling other files) using windows scheduler you may start receiving error as (in scenario where your job was running absolutely fine, this error started occurring suddenly),   task completed with exit code of (1)   Now on further investigation, found a link to describe the meaning of code,   0x0: The operation completed successfully. 0x1: An incorrect function was called or an unknown function was called. 0xa: The […]

May
22
2012

Error message on installing SQL Server 2005 service pack, hotfix, or cumulative update: “The Transaction Manager is not available”

Error Description from SUMMARY.txt file of service pack upgrade : Machine : < ;server_name>; Product : Client Components Error : MSP Error: 29549 Failed to install and configure assemblies C:\Program Files\Microsoft SQL Server\90\NotificationServices\9.0.242\Bin\microsoft.sqlserver.notificationservices.dll in the COM+ catalog. Error: -2146233087 Error message: Unknown error 0x80131501 Error description: The Transaction Manager is not available. (Exception from HRESULT: 0x8004D01B) ————— Other errors logged in Windows Event logs:   System Log Error: 7024: The Distributed Transaction Coordinator (MS DTC) […]

May
1
2012

sqlstate = HYT00; native error = 0; message = [Microsoft][ODBC SQL Server Driver]Timeout expired

Error in windows event logs: [sqsrvres] CheckQueryProcessorAlive: sqlexecdirect failed [sqsrvres] printODBCError: sqlstate = HYT00; native error = 0; message = [Microsoft][ODBC SQL Server Driver]Timeout expired  —————————- Suggestions from MSDN forum link: Reference link: http://social.msdn.microsoft.com/Forums/en-US/sqldisasterrecovery/thread/e5b8d938-e529-40f5-bdaa-601a8f6d7aca/ From the error it looks like there was issue with your network. Make sure you have a dedicated Heartbeat Network configured and that it is designated as such in Cluster Administrator. The public facing network can be configured for both Public […]

Apr
23
2012

Unable to do MSTSC/RDP – terminal services hanged after startup

Issue: Server is rebooted and after reboot it is responding via ping command but users/administrator unable to connect to server via MSTSC or RDP Scenario: Windows 2003 SP2 server, terminal services are enabled, remote session control is enabled

Apr
17
2012

Command Line utility “sc” to manage windows services

If you have been working with Windows then you are aware of command line utility which can be run by going to RUN > type “cmd” and a black window open’s up, now you can do several activities using command lines, let’s take example of managing services. Microsoft provided a GUI for same as well which will open-up by typing “services.msc” in RUN window. Managing services using command line is simple and efficient as you […]

Apr
17
2012

MSDTC and SQL Server 2005 Clustering

While searching for questions, Why MSDTC is required, in which it needs to be configured, is it must for SQL Clustering, etc. Please find below the analysis done by going through several forums and msdn articles,

Apr
8
2012

SQL Server 2000 Replication and Agents

General Replication concept and guide to set Up Snapshot Replication http://www.databasejournal.com/features/mssql/article.php/1458491/Setting-Up-Snapshot-Replication-A-Step-by-step-Guide.htm This article talks about general concept of replication, various topologies and also a guide to setup snapshot replication

Apr
8
2012

SQL Server 2008 and R2 Cluster Best Practices

http://blogs.msdn.com/b/pamitt/archive/2010/11/06/sql-server-clustering-best-practices.aspx Read about this in above article, few highlights to remember,

Apr
8
2012

Replication failure: Unable to start a DCOM Server

Error: Unable to start a DCOM Server: {08B0B2D9-3FB3-11D3-A4DE-00C04F610189}. The error: “The system cannot find the path specified. ” Happened while starting this command: C:\PROGRA~1\MICROS~3\80\COM\snapshot.exe -Embedding

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: