.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Register
 
Win Surprise Gifts!!!
Congratulations!!!


Top 5 Contributors of the Month
MarieAdela
Imran Ghani
Post New Web Links

Regarding using MSDTC with and TransactionScope

Posted By:      Posted Date: October 09, 2010    Points: 0   Category :.NET Framework
 

We have a web application, .Net Framework 3.5, OS=Win2003 SP2 (which we are planning to move to win2k8 soon). We are using MS DTC (Distributed transaction enabled).
 
Now the thing is, I am using the NLog. There is a property ${windows-identity}, I am using this property to log users NTAccount. Now this property required <identity impersonate="true">. But as soon as when I put <identity impersonate="true"> in web.config file, I am getting below MS DTC related error. Removing the <identity impersonate="true"> from web.config file resolves the error, but the log file fails to log users NTAccount as we have removed the <identity impersonate="true"> from the web.config file (the log file logs "NT AUTHORITY\NETWORK SERVICE" in log file as user NTAccount).

The interesting part is, the issue occurs if we use TransactionScope. With normal Transaction (SqlConnection.BeginTransaction), the issue doesnt occurs.
 
Is there really any issue using <identity impersonate="true"> with MSDTC with TransactionScope for windows 2003\2008 OS?
 
System.Data.SqlClient ---> System.UnauthorizedAccessException: Access is denied. (Exception from HRESULT: 0x80070005 (E_ACCESSDENIED))
at System.Transactions.Oletx.IDtcProxyShimFactory.ConnectToProxy(String


View Complete Post


More Related Resource Links

impersonate="true"

  

Hi i need to impersionate a windows user in a web application, i am using the examplein the url below, the issue i have is to get this working i have to set the <identity impersonate="true"> in the web.config. i cant do this as it stop my ad login working.

is there another way to set this in code so only my block of code with use impersonate="true"


http://www.java2s.com/Code/CSharp/Windows/WindowsImpersonationContext.htm


system.diagnotics.process Cannot work after Impersonate set to True

  

Dear All proferssional,

I need all ur help, i new in Visual Studio, currently just doing some modification on other person project due to some security issues. This application can run fine before i set the Impersonate to true in Web.Config, but after i set Impersonate = true, i get this information in Event Log

Faulting application java.exe, version 6.0.210.7, faulting module ntdll.dll, version 5.2.3790.3959, fault address 0x000000000003a7c0

In web.config, i set this tag

<identity impersonate="true" />

And inside my login screen, the below code have apply

        Dim strArgu As String = ""
        Dim processJar = New System.Diagnostics.Process()
        strArgu = " -classpath cryptcare.jar;commons-codec-1.3.jar com.maybank.care.ldapcontrols.LDAPConnector ""LOGON""" & " " & txtPFNo.Text.Trim() & " " & txtPwd.Text.Trim()

        processJar.StartInfo.FileName = "java"
        processJar.StartInfo.CreateNoWindow = True
        processJar.StartInfo.Arguments = strArgu
        processJar.StartInfo.WorkingDirectory = strWorkingDir
        processJar.StartInfo.UseShellExecute = False
        processJar.StartInfo.RedirectStandardOutput = True
        processJar.startInfo.UserName() = Syste

Aajaxtoolkit control +

  
dear all,   i have propblem, when i put  <identity impersonate="true" userName="domain\username" password="password" />   i have the following erro: Could not load file or assembly 'AjaxControlToolkit' or one of its dependencies. Access is denied.   but if i remove this tag : <identity impersonate="true" userName="domain\username" password="password" /> this site work normally. and i need to put this tag in web.config.

FormView KeepInEditMode=true isn't retaining values

  


I have an "Edit Page" in my application. It uses a FormView bound to an EntityDataSource.

I have a handler setup for the FormView OnItemUpdated event. If an exception occurs (such as foreign key constraints or non date vales entered in a date colum, etc.), then I set the "KeepInEditMode=true". This is SUPPOSED to retain the user entered values on all of the text boxes instead of rebinding the FormView to the data again and clearing those text boxes. (Right?)

Well, it isn't working...

I have stepped through the code via the debugger and the "KeepInEditMode" does get set to true, but as soon as the page reloads, the values revert back to the original database values (the data is being rebound).

I should also mention that I am setting "ExceptionHandled" to true. I am doing this because I am handling the Exception by displaying an error in a specific area of the page and if I dont mark it as handled, IE generates an Exception popup.

Any ideas?
 


Error "user does not have permission to perform this operation" with User Instance = True.

  

I setup SQL Server 2005 / SQL Express. All works fine in SQL Server 2005.

I am connecting to a SQL Database from VS 2005,  Tools/Connect to Database. I set the Data Source to "Microsoft SQL Server Database File (SqlClient)" (meaning SQL Server Express) and User Instance = True, and Integrated Security = True.

The above is working successfully on all machines except my Laptop. On my Laptop, I am getting this error "user does not have permission to perform this operation". On my Laptop, if I change User Instance = False, it works fine. Also, If I connect to SQL Server 2005 it works fine only if User Instance = False.

I tried all kind of security changes, nothing worked. For example, I setup Everyone as Full Control for the Folder and the MDF File of SQL Server. I gave my user ID as sysadmin role in SQL Server Express. Also, I enabled creating User Instance form SQL Server Express, Nothing is working.

Appreciate your help.

Tarek.


How To Access Datakeys In Javascript...and How To make gridview Column Visible true in javascript

  

How To Access Gridview's Datakeys In Javascript...and How To make gridview Column Visible true in javascript



Reply me..


Menu doesn't popup when WIndow style set to AllowsTransparency="True" WindowStyle="None"

  
Hi,I'm facing an issue, when using Window style set to AllowsTransparency="True" WindowStyle="None", my menus in menubar doesn't popup, rather they gets hidden (not visible) and if you just click by guess then menu item will be executed, its just that menu item is not shown visisble.However, if I revert back the Window style to normal without Transparency then menus visible(popup) perfectly.I'm not sure what could be an issue?San

How to Consume (Cookieless =true) Session Enabled Web services

  
  Hi, I need to use cookieless=true in web.config and enablesession=true in web methods.   I've two web methods like, [WebMethod(EnableSession=true)] public void SetName(string Name) { Session["Name"] =Name; } [WebMethod(EnableSession=true)} public string GetName() { return (string)Session["Name"] }   In my aspx.cs, using proxy I want to call SetName in button 1 click, and retrieve the name (which i put it into web service session on button 1 click ) in button 2 click like,   protected void Button1_Click(sender o, eventargs e) { webserviceproxy proxy =new webserviceproxy(); proxy.SetName("Prabhu"); } protected void Button2_Click(sender o, eventargs e) { webserviceproxy proxy =new webserviceproxy(); Response.Write( proxy.GetName()); } Here, How can I use cookie container and how can i achieve what Im expecting to do?   Please help me on this. thanks Prabhu P Work Smart, Not Hard

How can I show INSTEAD OF in XML output?

  
I am trying to create an XML document as the result of queries against our database tables. In some cases I need fields (usually INT) to display as <FieldName xsi:nil ="true" /> and that seems to work just fine if I used "ELEMENTS XSINIL"   However, I need to be able to chose (basically on a field by field basis in my SELECT statements) to return a blank field when the database holds a NULL value such as: <FieldName></FieldName>  (Or <FieldName/> either way would be fine).   How can I do that? Thank you for your help!   SELECT RecordCode, FieldToBeBlank, [Year] , [Month] FROM dbo.SomeTable FOR XML PATH('CustomRootName'), ELEMENTS XSINIL

Facing MSDTC related issues while archiving data from one database server machine to another databas

  
I have a question with respect to distributed transactions when carried out between two database server machines on the same network.   Consider there are two database server machines \SOURCE_DATABASE_SERVER\ and \DESTINATION_DATABASE_SERVER\. Now we have to archive the data from one database server to other database server.   Let us suppose the database server \SOURCE_DATABASE_SERVER\ is the live production database server and \DESTINATION_DATABASE_SERVER\ is Long term storage database server. Now data from \SOURCE_DATABASE_SERVER\ needs to be archived into the database server \DESTINATION_DATABASE_SERVER\.   So I have written a dynamic stored procedure which includes distributed transaction (begin Tran, commit Tran, rollback            Tran) coding in it.   Now initially when I executed the procedure, it gave some of the following errors   1) OLE DB provider "SQLNCLI" for linked server "\DESTINATION_DATABASE_SERVER\" returned message "The partner transaction manager has disabled its support for remote/network transactions.". Msg 7391, Level 16, State 2, Line 1 The operation could not be performed because OLE DB provider "SQLNCLI" for linked server "\DESTINATION_DATABASE_SERVER\" was unable to begin a distributed transaction.    

How large do you make your MSDTC Physical Disk Resource?

  
MSDTC requires a physical disk resource for the 4mb log it uses.  How large do you typically make the disk used as the MSDTC Physical Disk resource?  I don't know if there is a need to go beyond 4MB.  I'm guessing 100MB is a safe number.  Do you agree? Thanks,    Dave

Error "user does not have permission to perform this operation" with User Instance = True.

  
I setup SQL Server 2005 / SQL Express. All works fine in SQL Server 2005. I am connecting to a SQL Database from VS 2005,  Tools/Connect to Database. I set the Data Source to "Microsoft SQL Server Database File (SqlClient)" (meaning SQL Server Express) and User Instance = True, and Integrated Security = True. I am using Windows Authentication mode in SQL Server Express. The above is working successfully on all machines except my Laptop. On my Laptop, I am getting this error "user does not have permission to perform this operation". On my Laptop, if I change User Instance = False, it works fine. Also, If I connect to SQL Server 2005 it works fine only if User Instance = False. I tried all kind of security changes, nothing worked. For example, I setup Everyone as Full Control for the Folder and the MDF File of SQL Server. I gave my user ID as sysadmin role in SQL Server Express. Also, I enabled creating User Instance form SQL Server Express, Nothing is working. I am already added to the Administrator Group locally on my Laptop. Still same problem. Checked this article: http://msdn.microsoft.com/en-us/library/ms254504.aspx, same problem. I enabled User Instances and also tried to Disable User Instances. When I disable user instances, and then try to connect from VS, I get a different error, which is asking to enable user instances.

Values in user control fields empty when AutoEventWireup=true ?

  
As a BizTalk developer I'm trying to build a ASP.NET website so some obvious things might be new to me (so please be gentle). I have a web form and I have a user control on it. This user control contains a panel with some user properties that are to be stored in a database. So far nothing fancy. The user control itself contains a panel and is working fine (all code to retrieve and store the values is working). I used the default settings of creating a user control and one of them was AutoEventWireup=true. This works fine because I also have some dropdown boxes (and other fields) that need to be filled with values from the database and that happens in the Page_load event. The panel specifies the 'DefaultButton' which calls a method when clicked to save the values after the user has changed them. On this click the code of the method is called, I confirmed that, but I found out that the values of my controls on the user control (for example the Textbox control) are empty. As a non-ASP.NET developer I couldn't figure out why. So I changed some settings like AutoEventWireup to false. Off course this resulted in my dropdown boxes no longer to be initially filled, but my surprise was big to find out my controls actually contained the values the user typed in. Logically I need both the values and th

radiobutton list item make visible true or false in javascript

  
in my project i have used one radiobuttonlist according different user login , i want to make one of radiobuttonlist item visible true or false..   please help me to solve this issue.   thanks in advance.  

Behaviour of WPF ComboBox with IsTextSearchEnabled=true and isEditable=true is not quite understanda

  
Hi, imagine you have a ComboBox with the following entries in the DropDown list: 1, 5, 10, 15 Now follow up this scenario: - open DropDown list - type 13 in the edit field -> 10 is selected in DropDown list - press "Enter" As result DropDown list is closed and 10 is placed in the edit field. How to override this behaviour so that 13 would be not overwritten after pressing "Enter"? Regards Efim

How to impersonate a connection to SQL server under IIS app pool account if Windows Authentication i

  
I have a requirement I should connect to MS SQL server under IIS Application pool account from ASP.NET application where Windows Authentication is enabled. I cannot use user name and password in connection string. ASP.NET application should use Entity Framework 4.0 to work with data. Any ideas how to do it?    

Dependency of IP , n/w , Disk in MSDTC.

  
have installed sql server 2005 cluster but never 2008 ,now I have got this chance but I am not understanding how to create dependency of IP , n/w , Disk in MSDTC. What are the domain user rights ?Actually my previous site was given the writes of domain admin to the sqluser now it is giving me problem.??"SQLSERVER DBA" "INDIA"
Categories: 
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend