Re: Microsoft JDBC Driver XA Problem

Jay Shen wrote: 
Hi,

I have applied XA support via the dll and script...but now I got the following error. Anyone can point me a direction to fix this?
Thanks,

j-

20:44:06 [tyrex.resource.n3-db] [main] [transaction server is recovering] [] [] ERROR - Failed to create connection for default user
java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC][SQLServer]xa_open (0) returns -3
at com.microsoft.jdbc.base.BaseExceptions.createException(Unknown 
Hi Jay,

Seems, that you haven't started the DTC (Distributed Transaction
Coordinator) service. This service is installed during the
MS SQL Server 2000 installation but with start type 'manual'.

BTW: which user do you use to connetc to the database ? If you don't
use sa (which would be a good idea) have in mind, that XA recovery is
only allowed for a system administrator. To allow all users to perform
XA recovery, you have to add the EXEC permission to PUBLIC for the stored procedure xp_jdbc_recover (part of extended stored procedures) in the master database.

Best,
Manfred
.

Relevant Pages

  • Re: Microsoft JDBC Driver XA Problem
    ... > MS SQL Server 2000 installation but with start type 'manual'. ... > XA recovery, you have to add the EXEC permission to PUBLIC for the stored ... > procedure xp_jdbc_recover (part of extended stored procedures) in the ... > master database. ...
    (microsoft.public.sqlserver.jdbcdriver)
  • Re: Recovery Console Perplexations and Woes
    ... You start the Recovery ... > the Windows XP Professional SP2 installation CD, with the appropriate Key, ... > specifically the Recovery Console, aside from, and in addition to, the ...
    (microsoft.public.windowsxp.general)
  • Re: I am DEAD
    ... You are right about the backups. ... installation you have to type in a number then press to log on ... Which Windows installation would you like to logon to? ... sufficient access privileges with the standard Recovery Console ...
    (microsoft.public.windowsxp.help_and_support)
  • Re: XP startup problem; wont start
    ... XP installation on my computer is of Windows XP professional edition (with ... Windows XP could not start because the following file is missing or corrupt: ... Typed 'R' to get recovery console ... bootcfg /rebuild ...
    (microsoft.public.windowsxp.help_and_support)
  • Re: More Problems - XP Will Not Boot - 2nd Computer - Following Up
    ... volumes available for the installation of XP. ... I have made sure to load current RAID drivers during the XP Set ... I created and two Windows XP system disks.) ... a screen that displays: "Microsoft Windows XPRecovery ...
    (microsoft.public.windowsxp.general)
Loading