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


Top 5 Contributors of the Month
david stephan
Santhakumar Munuswamy
Asad Ali
Fauzul Azmi
Post New Web Links

Decryption problem at different machine.

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

Hi

I have one problem with encrypting data at one server and decrypting that on other server.

We have Sql server 2008 Cluster on Win2K3 64 bit server. and client machines are 32 bit XP machines.

I also have a library that encrypt and decrypt data using AES 128 bit using RijndaelManaged class.  I have registered this Dll in SQL Sever and using this dll at client application as well.

now problem is that when I encrypt the data at SQL Server using a fix key and IV, the encrypted data is not decrypted at client machine. It throws the error "Padding is invalid and cannot be removed."

Though when decrypting the same text at SQL Server end, it works fine.

How can this  be achieved?

 

Regards,

Lalit




View Complete Post


More Related Resource Links

Problem with decryption data in stored procedure if local date on my machine was changed

  

Hi people!

Can anybody help me with my problem?

I have one machine (Server 2003 x64 SP2, SQL Server Standard Edition (64-bit) version 9.00.4053.00). Also I have a stored procedure in database that doing a validation of users, and contains the next code:

OPEN SYMMETRIC KEY PasswordFieldSymmetricKey
DECRYPTION BY CERTIFICATE PasswordFieldCertificate;
  SELECT
  [UserId],
  [AccountNumber],
  [Login],
  CONVERT(varchar, DecryptByKey(EncryptedPassword)) AS 'Password'
  FROM [User]
  WHERE ([Login] = @Login)
        AND (CONVERT(varchar, DecryptByKey(EncryptedPassword)) = @Password);
CLOSE SYMMETRIC KEY PasswordFieldSymmetricKey;

All works correctly but if i change the "Date and Time Properties" on my machine i receive the next error

(0 row(s) affected)
Msg 15315, Level 16, State 1, Procedure user_login, Line 111
The key 'PasswordFieldSymmetricKey' is not open. Please open the key before using it.

If i set the current date it will work correctly again.
One strange thing:
if execute the query "SELECT * FROM sys.symmetric_keys" i have the next date of creation for my symmetric keys

2010-11-04 11:18:49.300

And if i set a date less then date of

Problem with .Net framework 4.0 on IIS 7 on Windows Server v2008 64 bit machine

  
Hi, I have installed .Net framework 4.0, i have added one application in default website, now when i brows the login page, it take some time and at the end displays nothing, in the event viewer in system log it says myApplicationName crashed.And also i get folllowing in event viewer Application LogLog Name:      ApplicationSource:        Application ErrorDate:          7/29/2010 11:39:31 AMEvent ID:      1000Task Category: (100)Level:         ErrorKeywords:      ClassicUser:          N/AComputer:      dev-appDescription:Faulting application name: w3wp.exe, version: 7.5.7600.16385, time stamp: 0x4a5bd0ebFaulting module name: clr.dll, version: 4.0.30319.1, time stamp: 0x4ba21eebException code: 0xc00000fdFault offset: 0x000000000000400cFaulting process id: 0xad8Faulting application start time: 0x01cb2ef990316804Faulting application path: c:\windows\system32\inetsrv\w3wp.exeFaulting module path: C:\Windows\Microsoft.NET\Framework64\v4.0.30319\clr.dllReport Id: ce52c718-9aec-11df-8551-00155d701c03Event Xml:<Event xmlns="http://schemas.microsoft.com/win/2004/08/events/event">  <System>  

problem in Transferring a large dataset to remote machine by using the NetTcpBinding

  
i am developing an WCF application, in which i have to transfer a large dataset to the remote machine!! for that im using nettcpbinding in WCF but i got this exception ' The socket connection was aborted. This could be caused by an error processing your message or a receive timeout being exceeded by the remote host, or an underlying network resource issue. Local socket timeout was '10:29:59.4140000'. at my sender side.   Sender/Client side code   // Object for sending to remote client using (_dpParameters = new DPParameters()) { _dpParameters.SequenceFieldName = "Sequence"; _dpParameters.Size = 10; _dpParameters.SubjectsForFiles = "S,Y,T"; _dpParameters.SubjectNames.Equals(SubjectNames); _dpParameters.FilePath = " E:\\Source\\Phospho.xml"; // this dataset can be in GBs but for testing me using jst 6.78mb DataSet ds = new DataSet(); ds.ReadXml(_dpParameters.FilePath); _dpParameters.Usd = ds.Tables[0]; } /// This is the binding settings NetTcpBinding tcpBinding = new NetTcpBinding(); tcpBinding.ReceiveTimeout = new TimeSpan(10, 30, 00); tcpBinding.SendTimeout = new TimeSpan(10, 30, 00); tcpBinding.MaxBufferSize.Equals(67108864); tcpBinding.MaxBufferPoolSize.Equals(67108864); tcpBinding.MaxReceivedMessageSize.E

WCF Windows Auth (NTLM) Problem when Client and Server are on the same machine

  

I have WCF service being hosted in IIS with windows auth enabled, it is running under NetworkService account .  I have a simple method on my WCF service which just reflects the identity of who is calling it.

 

public string RefelctIdentity()

{

 

return HttpContext.Current.User.Identity.Name;

}

I am using IIS to authenticate the user and pass me the WindowsPrincipal in the HTTP context.

I am consuming the WCF service witha client used in a WindowsService that is being run under the NetworkService account.  When the WindowsService.  When running b

problem in reading event logs of remote machine

  

hi,

I work on application which connects to remote machine and retrieves all event logs from it using EventLogReader and EventLogQuery classes.

I use the API EventLogReader.ReadEvent() for it. It works fine on all platforms except on Windows 7 machine. If I run my application on Windows 7 machine, EventLogReader.ReadEvent() throws an EventLogException with the error message - "The array bounds are invalid"

Have anyone faced this issue before? How I can overcome this problem and continue reading next event logs?

Please let me know.

 

Thanks!

Amit


Problem connecting to report server from client machine

  

We've deployed some reports from a server machine which can be accessed without any problems if you are logged onto the server itself by going to the URL of http://servername/ReportServer. However if we try and access the reports from a client machine (even if we use the same administrator Windows account) we get the Windows security window appear asking for a Username and Password to be entered in order to connect to the server. We've tried entering this but we then just get a blank screen after being re prompted a few times to enter the details.
Now I'm not sure whether this will be a Reporting Services or a Windows issue. Could it be a setting within IIS? It can't really be a user thing as the same user works on the server but not on the Client machine so it's more of a machine problem. It's as if there are some authentication settings somewhere that need to be set.
We are using SQL Server 2008 on Windows 7.
 
Thanks a lot
Steve


Problem accessing Report Server from client machine

  

We've deployed some reports from a server machine which can be accessed without any problems if you are logged onto the server itself by going to the URL of http://servername/ReportServer. However if we try and access the reports from a client machine (even if we use the same administrator Windows account) we get the Windows security window appear asking for a Username and Password to be entered in order to connect to the server. We've tried entering this but we then just get a blank screen after being re prompted a few times to enter the details.

Now I'm not sure whether this will be a Reporting Services or a Windows issue. Could it be a setting within IIS? It can't really be a user thing as the same user works on the server but not on the Client machine so it's more of a machine problem. It's as if there are some authentication settings somewhere that need to be set.

We are using SQL Server 2008 on Windows 7.

 

Thanks a lot

Steve


HijriDate problem In server Machine

  

I Have Code That Get   HijriDate  in Format  dddd dd MMMM yyyy the Code Work fine In developement (windows XP) Machine and gave Correct HijriDate But When run the Code in server Machine(windows 2003 R2)   it Gave Me  wrong date (advanced one day from correct date) I Look To region Setting In Both Developemnt machine and server machine it have same setting

using System;
using System.Collections;
using System.Configuration;
using System.Data;
using System.Linq;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.HtmlControls;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Xml.Linq;
using System.Globalization;
using Sitedll;
using System.Threading;
public partial class TestDate : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {
        CultureInfo arCul = new CultureInfo("ar-SA");
        CultureInfo enCul = new CultureInfo("en-US");
        HijriCalendar h = new HijriCalendar();
        GregorianCalendar g = new GregorianCalendar(GregorianCalendarTypes.USEnglish);
        arCul.DateTimeFormat.Calendar = h;
       

Sate Machine Alignment problem

  

Hello,

I've a State Machine Workflow that it has a very big size, I mean more than 40 states. The problem is when I open the workflow in design view on Visual Studio 2008, all the states are misaligned, like one bellow the other. But if the same workflow I open in other computer with visual studio 2008, it shown good, the states are where they have to be.

I don't know what it is, maybe same bad configuration of the VS.

Any idea? 


Julio E. Szabo

Problem to group radio button across gridview rows

  
In general no one can easily group or make a single selection from radio button list inside gridview rows. There are a lot of way to make a single or unique selection from list. Here i want to share how i can address this problem in the most easiest way. Googling the problem most of the cases i saw the grouping in horizontal way. Thats why i tried to group the radio buttons in vertical manner. Let i have a requirement like below:

Regrading Sharpoint 2010 problem and solutions

  
http://emanonsolutions.blogspot.com/
We can write your question and problem on this blogger.you get ans.use.

This sharpoint 2010 problem solving threads

  
Hi friend,

you can use this thread to solving problem and solutions.

Virtual Path Problem

  

 I get the following error on last line below (working on remote host): 'E:\web\sfcascom\ls_admin/uploads/images/001.JPG' is not a valid virtual path,

Note that the slashes go in different directions

I've tried a number of things but nothing seems to work. Thanks-

 

Imports System.Drawing
Imports System.Drawing.Drawing2D
Imports System.Drawing.Imaging
Imports System.Web.UI.WebControls

Imports System.Drawing.Imaging.ImageCodecInfo
Partial Class Protected_imageupload
    Inherits System.Web.UI.Page
    Private Sub btnUpload_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles btnUpload.Click
        ' Initialize variables
        Dim sSavePath As String
        Dim sThumbExtension As String
        Dim intThumbWidth As Integer
        Dim intThumbHeight As Integer
        Dim sFilename As String = ""
        ' Set constant values
        'sSavePath = "images/"
        sSavePath = Server.MapPath("~/") + "ls_admin/uploads/images/"



        sThumbExtension = "_thumb"
        intThumbWidth = 160
        intThumbHeight = 120

        ' If file field isn?t empty
        If FilUpload.PostedFile IsNot Nothing Then
            ' Check file size (mustn?t be 0)
            Dim myFile As Http

Strange Photo upload problem

  

I'm working project it's live on shared hosting

we'er uploading photos to a file on the server everything works fine the photo is resized renamed and sent to the folder

the upload page returns the thumbnail and the full size photo it's there all the photos have to be approved by an admin

twice now after they have been approved they disapear I checked the folder they are not there could there be anywhere

on the server they could get hung up before they go into the folder I have it setup so when you delete the data base entry it deletes the photo from the folder othe than that you need to open the folder and delete the photo this has hapened twice now I tried to recreate it with no luck

thaks for your help in advance


ASP.Net Caching problem ??

  

I'm having a problem with an asp.net 3.0 application using a gridview to display data.  The problem seems to be that despite a brand new .selectCommand being sent to the sqlDataSource, the gridview starts displaying data from *someone else's* query.  For example, user A is logged in and will be working fine until a few page submissions later when the gridview data starts suddenly showing information that belongs to another user. 

This is my first asp.net application, though I've been working with classic asp and ADO for years so I'm used to sending a SQL string and getting back the results from that string.  Apparently there is a complex caching system which is interferring which I do not at all understand so at this point I just want to stop the server from caching any data whatsoever.  Is this possible?

Any and all help will be much appreciated!!


Could some one tell me whats the Problem with this String Manipulation ??? C#.net

  

Hi.,

I store some values from code behind to a label which is Hidden !

<asp:Label ID="lbl_Hidden" runat="server" Visible = "false"></asp:Label>

and at the page load event i retrieve the value of the label & assign it to a string !

stringvalue = lbl_Hidden.Text;

Now i dont know why this manipulation does'nt work !

I've a character 'A' in the string and i'm unable to replace it with a space !

stringvalue.Replace(A, " ");

Wot do u think abt it ????


RaiseEvent problem

  

I have a parent page ProdView.aspx and two static UserControls, UC1 and UC2. Each UC is in an Ajax accordion pane and the accordion inside an updatepanel.

UC1 has a Gridview footer with couple of textboxes and a link button that fires an Add Row insert procedure. I want to Raise an event that will rebind the UC2 after the row insert in UC1.

First I created the sub delegate and event in UC1:

  • Public Delegate Sub MyRefresh(ByVal sender As Object, ByVal e As CommandEventArgs)
  • Public Event Refresh_UC1 As MyRefresh

In the same UC1 the Insert procedure that fires the insert and RaiseEvent:


Sub PricingGrid_Insert(ByVal sender As System.Object, ByVal e As EventArgs)
       Dim myConn As SqlConnection = New SqlConnection(ConfigurationManager.ConnectionStrings("LocalSqlServer").ConnectionString)
       Dim myCom As SqlCommand = New SqlCommand("AddRow", myConn)
       myCom.CommandText = "AddRow"
       myCom.CommandType = CommandType.StoredProcedure

        Try
            myConn.Open()
       &nb

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