MSDTC unavailable? - Visual Basic .NET

dgk

I installed SQLServer2005 but I still get the message that MSDTC
(transaction stuff) is unavailable. Any ideas how to fix it? Perhaps
find a SQL Server group I guess.

Dec 7 '05 #1

Subscribe Reply

1163

dgk

On Wed, 07 Dec 2005 08:48:05 -0500, dgk <dg*@somewhere.com> wrote:

I installed SQLServer2005 but I still get the message that MSDTC
(transaction stuff) is unavailable. Any ideas how to fix it? Perhaps
find a SQL Server group I guess.

Ah, I think I see the reason. Even though I thought that I had
successfully installed SQLServer 2005, Microsoft thought otherwise.
Apparently I have 2000 Enterprise installed, and was trying to install
2005 Standard. So, hidden in a Details button, was the information
that the Database portion of the upgrade was blocked by versioning
issues.

Very well, but shouldn't the fact that the Database component isn't
being upgraded create something like WARNING WARNING Will Robinson
instead of hiding in a details report? Yes, the upgrade went fine but
the database died.

So instead of upgrading I'm now just installing another version. I am
guessing that the problem will be solved.

Dec 7 '05 #2

Similar topics

8176

SQL Server Enterprise Manager could not start the service 'MSDTC'

by: KO | last post by:

SQL Server Enterprise Manager could not start the service 'MSDTC' on server 'NTAS21'. 1722 - (The RPC server is unavailable) I Setup A publication on a server called NTAS4D, then Pushed The...

Microsoft SQL Server

3720

MSDTC error on Windows 2003

by: Gary | last post by:

All, I am experiencing an error using MSDTC with SQL Server 2000 on Windows 2003 server. The code in question is a stored procedure that does a query within a transaction using linked servers....

Microsoft SQL Server

9736

MSDTC is unavailable.

by: tperovic | last post by:

The following code: DECLARE @tsql varchar(1000) CREATE TABLE #Test (...) SET @tsql = 'SELECT * FROM OPENQUERY(MyDataSource, ...)' INSERT INTO #Test EXEC(@tsql) generates the following error...

Microsoft SQL Server

2189

MSDTC and Delete transactions

by: sjoshi | last post by:

Hello I had a question reagrding MSDTC usage. I know that MSDTC will enlist each connection transactions as it's own (take ownership) and commit/abort accordingly. However I'm not sure what...

Microsoft SQL Server

2548

MSDTC error in Windows xp environment.

by: hafeez | last post by:

Hi, I am using SQL SERVER 2005 standard edition in windows xp environment. And remote system also have same SQL SERVER 2005 standard edition windows xp environment. I am using LINKED SERVER...

Microsoft SQL Server

3398

MSDTC?

by: Jimbo | last post by:

I keep getting this error on my application server...what does it mean? The description for Event ID ( 0 ) in Source ( ODBC ) cannot be found. The local computer may not have the necessary...

Microsoft SQL Server

2903

Cannot escalate to MSDTC when using CommitableTransaction class on

by: =?Utf-8?B?YWJheWVy?= | last post by:

In short: I have an application using the CommittableTransaction class that works fine when run locally, but does not escalate to MSDTC when deployed to a Windows 2003 R2 server. More...

.NET Framework

1986

MSDTC Error after applying W2K3 SP2

by: =?Utf-8?B?UGF1bCBQcmV3ZXR0?= | last post by:

Hi - I have 4 webservers in my webfarm. All Win2k3 web edition. Before yesterday, none of them were service packed. I have now applied SP2 to two of them, and I'm getting a very weird MSDTC...

ASP.NET

2006

MSDTC config for transfaction scope?

by: =?Utf-8?B?QmlsbHkgWmhhbmc=?= | last post by:

I have two web server, one DB server with two Database. I used MS enterprise transaction with transfaction scope. How to config MSDTC between the web server and DB to make it work? any...

ASP.NET

7125

What is ONU?

by: marktang | last post by:

ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...

General

7002

Changing the language in Windows 10

by: Hystou | last post by:

Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...

Windows Server

7205

Maximizing Business Potential: The Nexus of Website Design and Digital Marketing

by: jinu1996 | last post by:

In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...

Online Marketing

6887

The easy way to turn off automatic updates for Windows 10/11

by: Hystou | last post by:

Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...

Windows Server

7379

Discussion: How does Zigbee compare with other wireless protocols in smart home applications?

by: tracyyun | last post by:

Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...

General

3093

Trying to create a lan-to-lan vpn between two differents networks

by: TSSRALBI | last post by:

Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The...

Networking - Hardware / Configuration

3085

Windows Forms - .Net 8.0

by: adsilva | last post by:

A Windows Forms form does not have the event Unload, like VB6. What one acts like?

Visual Basic .NET

1419

transfer the data from one system to another through ip address

by: 6302768590 | last post by:

Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated ...

C# / C Sharp

656

How to add payments to a PHP MySQL app.

by: muto222 | last post by:

How can i add a mobile payment intergratation into php mysql website.

PHP