Connection problem with ServicedComponents

Hot Topic

Vertical text in a graphic context.
bug in serialport.close() ?
How to use System.Net.Mail.SmtpClient via SSL and Authentication?
What is appropriate for this?
Backward compatibility for ADO.NET ??
xsd of xlink elements
Passport Authentication Setup
technical differences between JVM and CLR?
what is the right way to data access with sql server
Error 25015 while installing .NET Framework 2.0

.NET Development

FtpWebRequest re-sending USER and PASS commands half way through download loop
SqlConnection error
Client Certificate Storage Location
How to set bilingual or multi-language feature in the controls in Masterpage
Where is System.Speech.Dll????
ODBC .Net Data provider Is it still an Add-in for 2005?
SqlDataReader & an SQL statement problem
Plural of word
Help : "error: 40 - Could not open a connection to SQL Server"
Norton SystemWorks Basic One Touch Button Program Integrity Scan Microsoft.NET Framework v2.0

Connection problem with ServicedComponents

HI

I have written a Serviced Component with VS 2003 .NET 1.1 on XP Pro that creates a ditributed transaction between to SQL servers on the network.

I have it working on my dev pc fine..

When I try to deploy on Win Server 2003 I get an error

Target of an invocation etc etc

When debugging it is falling over on a Open method of my connection object. I am  connecting to a SQL Server V7 db. The same code runs as Win forms app fine

Is there any issue I should know about with Win 2003 and Serviced Components.

I have tried Windows Authentication and SQL Server authentication no luck.

Thanks if you can help
Malcolm




Answer this question

Connection problem with ServicedComponents

  • jaguiargn

     

    I have discovered that the DTC was not enabled on the Win2003 server.

    but now that I have enabled it I get this error

    An error occurred while enlisting in a distributed transaction.

    I have restarted some services that the msdn said to do after enabling DTC.

    This is a very general error.

    I am connectiing using sa user for now.

    Also I checked that the DTC was enabled on the server i am connecting too.

    Malcolm

     

     

     



  • Alex Iordan

    Thanks Joe

    The inner exception is

    Login failed for user 'NT Authority/Anonymous logon'

    My connection string is

    data source=SQLSERVER;initial catalog=tbrWebTest;integrated security=SSPI

    And I have tried to set the user id and password as well

     

    Any ideas what the problem is would be helpful

    Malcolm

     

     

     

     

     

     



  • pp11oo22

    You need to look at the InnerException of your TargetInvocationException to see tha underlying exception. 


  • Connection problem with ServicedComponents
Answer this question