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

Top 5 Contributors of the Month
Gaurav Pal
Post New Web Links

Error generating Asymmetric Keys

Posted By:      Posted Date: September 26, 2010    Points: 0   Category :Sql Server


I'm working on an SQL Server 2005 DB (SQL Server Standard Edition - Version 9.00.4035.00)


I've been told the server that the database is running Microsoft 2003.

When I look in SQL Server DB properties it says Operating System = Microsoft Windows NT 5.2 (3790)

Looking at the operating system details on the server MS Windows 2003 Standard Edition, 5.2.3790 Service Pack 2 Build 3790.

If I create symmetric keys using the following statement everything works fine


If I try to create an asymmetric keys using the following statement

    ENCRYPTION BY PASSWORD = '#1_2%3*4)5~6';

I get the following error :

Msg 15314, Level 16, State 1, Line 1
Either no algorithm has been specified or the bitlength and the algorithm specified for the key are not available in this installation of Windows.

I know that AES encryption will only work on Windows 2003 which is what people say is the reason for the error message.

Is that the case here, I can use the AES_256 encryption when creating symmetric keys, but only get the error when creating an asymmetric key.


View Complete Post

More Related Resource Links

SQL Server 2008 installation fails There was an error generating the XML document. Error code 0x84B

My system config: window XP - SP3 4 GB RAM, I have VS2008 with SP1, VS2010 Ultimate installed First when I tried to install SQL 2008 R2 Dev edition I got an error saying vs2008 SP1 was not installed, infact I had the SP1 installed in my m/c.  I did reinstalled the SP1 and tried to install SQL again. while in the final installation process I got the error  "Setup has encountered the following error: There was an error generating the XML document. Error code 0x84B10001." I uninstall the SQL server again to remove the files which were created from Unsuccessful installation I removed the register entry as suggested by this forum. reinstalled but no chance, I have tried all the option which I can get know in web. Please help me. here is the log files details  Exception type: Microsoft.SqlServer.Chainer.Infrastructure.ChainerInfrastructureException 2010-08-26 14:54:53 Slp:     Message: 2010-08-26 14:54:53 Slp:         There was an error generating the XML document. 2010-08-26 14:54:53 Slp:     Stack: 2010-08-26 14:54:53 Slp:         at Microsoft.SqlServer.Chainer.Infrastructure.DataStoreService.SerializeObject(String rootPath, Object objectToSerialize, Boolean saveToCache) 2010-08-26 14:54:53 Slp:   &nb

Receiving error when saving site as template: [InvalidOperationException: Error generating solution

I am getting the following error when saving a site as a template (just this specific site is having this issue - other sites in collection successfully save as template): [InvalidOperationException: Error generating solution files in temporary directory.] Microsoft.SharePoint.SPSolutionExporter.ExportWebAsSolution() +26053165 Microsoft.SharePoint.SPSolutionExporter.ExportWebToGallery(SPWeb web, String solutionFileName, String title, String description, ExportMode exportMode, Boolean includeContent, String workflowTemplateName, String destinationListUrl) +1778 Microsoft.SharePoint.SPSolutionExporter.ExportWebToGallery(SPWeb web, String solutionFileName, String title, String description, ExportMode exportMode, Boolean includeContent) +44 Microsoft.SharePoint.ApplicationPages.SaveAsTemplatePage.BtnSaveAsTemplate_Click(Object sender, EventArgs e) +331 System.Web.UI.WebControls.Button.OnClick(EventArgs e) +115 System.Web.UI.WebControls.Button.RaisePostBackEvent(String eventArgument) +140 System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument) +29 System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +2981 I'm thinking it may have something to do with permissions, but other sites can save as a template. Also, it does not specify

How to use the public key of asymmetric keys?

Hi All, I know about the concept of public/private keys,but I cannot figure out the difference between asymmetric keys and symmetric keys encrypted by certificates . Both public/private keys are kept at server side ,like a symmetric key encrypted by a certificate How can i use the public key shown as the result of running the following query? select [name] ,asymmetric_key_id,public_key from sys.asymmetric_keys How can it be used when there exists only two pair of functions(EncryptByAsymKey and DecryptByAsymKey)  ? --yousef

Designer: Error Generating the Task Form



I keep getting this error, no matter whether i "assign form to group" or "collect data from user"


Followed the most basic examples straight from MSDN and my book, however, still get error EVERYTIME!


here is a screenshot from a workflow I tried to create on my own. No ideas! Please help me, this is probably the most frustrating error I've ever encountered because it gives NO INFORMATION about how to fix it ...



Internal server error after deleting old encryption keys after a database upgrade.



We are in the process of upgrading our current environment from sql server 2005 to 2008R2. Everything goes fine except for SSRS.I have SSRS 2008R2 installed on a seperate machine and it works. We can see the report manager etc. except it's empty of course. I then backup the ReportingServices and ReportingServicesTempDB and transfer them to the new machine. I restore the database and it gets upgraded automatically, no problems there.

Next I go to the configuration manager and change the database SSRS needs to use to the restored DB. At that point I will restore the old encryption keys belonging to that database and as a result I now have 2 servers in my scale out deployment. Seeing as we only need Standard SSRS we get an error saying that Scale out deployment is not supported in this edition(standard) of SSRS.

So what i need to do is delete the source database encryption key. So my name server is named ServerA and my old one is ServerB. I use the rskeymgmt tool to list and delete the old encryption key(ServerB). This way I end up with only 1 server in my instance.

Now when i try to go to the report manager i get the error "An internal error occurred on the report server. See logs for more info". But when i go to my logs it just shows the same message that an error occurred but it doesn't tell me what went wrong.

These a

CLR Stored Procedure error:There was an error generating the XML document


I am using a CLR stored procedure to call a webservice. I have marked the project as  strongly named assembly and also created a serialization assembly using Generate Serialization assembly in VS 2008. It created both files which I copied on to the database server. I have created assemblies of both






CREATE PROCEDURE TestList(@date datetime) AS EXTERNAL NAME XXXCLRProcs.[XXXCLRProcs.CLRStoredProcedure].TestList



When I tried to execute stored procedure with @date = N'2000-1-1' I get following error:


A .NET Framework error occurred during execution of user-defined routine or aggregate "TestList": 

System.Exception: Failed to send outbound message There was an error generating the XML document.


   at XXXCLRProcs.CLRStoredProcedure.ConsumeTestList(DataTable dt)

   at XXXCLRProcs.CLRStoredProcedure.TestList(DateTime date)



Here is the code:


   public static void TestList(DateTime date)

Datagrid column Sorting generating error


I have a datagrid column whose column values are databinded. I have used DataGridTemplateColumn and i need to use the sorting in this column.

<my:DataGridTemplateColumn SortMemberPath="FileName" Header="Name" IsReadOnly="True" MinWidth="150">

It works and sort the the data but when i edit the data after sorting, i need to re-generate the columns data.

FileListingGrid.ItemsSource = listFiles1;

But this generates "'Sorting' is not allowed during an AddNew or EditItem transaction. "

It works file when column data is not sorted but whenever i sort the data and have to re-generate the column data, it throws the following error.


sharepoint designer encountered an error generating task (port 100)



After spending 3 days, finally i could able to start the approval flow process (Only in default port) in SP2010. The problem is SPD is prompting the well known error "sharepoint designer encountered an error generating task" in other ports  (ex: 100). but working in default port.

Any Ideas? Kindly Share.


Generating proxy with netcfsvcutil - An error occured in the tool -> How to generate proxy?

I'm currently trying to generate a SmartDevice proxy from a WCF service and that fails. Initially it complained that the NETCF doesn't support wsHtpp, so I changed it into a basicHttp binding and rolled https into it. After changing a lot of things I managed to get my server to properly start, but had the testclient complain that it was unable to generate a proxy because the connection was forcefully closed.

So I undid ALL the HTTPS changed and use plain http. It's not secure, but at least it works for my development purposes. When I start the test client, it generates a proxy and shows up fine. However, when I run my netcfsvcutil from the commandline, it gives me "An error has occured in the tool." follow by a "An error has occured in the application".

This is how I call the tool:


netcfsvcutil.exe http://localhost:8080/WhereIsPatrickSvc/mex


And this is my entire config file for the service;

<?xml version="1.0" encoding=

Getting error message while uploading photos and generating Thumbnail



I get the following error:

A first chance exception of type 'System.ArgumentException' occurred in System.Drawing.dll

A first chance exception of type 'System.ArgumentException' occurred in App_Web_u9x47ohz.dll

I am uploading images and also generate the thumbnail using the following methods:

Protected Sub btnUploadPhotos_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles btnUploadPhotos.Click

div5.Visible = True

Dim uploadFilCol As HttpFileCollection = Request.Files
For i As Integer = 0 To uploadFilCol.Count - 1
Dim file As HttpPostedFile = uploadFilCol(i)
Dim fileExt As String = Path.GetExtension(file.FileName).ToLower()
Dim fileName As String = Path.GetFileName(file.FileName)
If fileName <> String.Empty Then
If fileExt = ".jpg" OrElse fileExt = ".gif" OrElse fileExt = ".bmp" OrElse fileExt = ".jpeg" OrElse fileExt = ".png" Then
file.SaveAs(Server.MapPath("~/uploads/") & fileName)


500 Error generating SSRS Report in SharePoint Integrated Mode


Our environment looks as follows:

- MOSS 2007 Site/Central Admin (Enterprise) on Server A

- SQL Reporting Services 2008 R2 on Server B

- Report created on workstation using Report Builder 3.0

- SharePoint Library (with Promoted InfoPath fields) is the XML datasource


The report generates perfectly fine in development, but once loading the RDL up to the SP Site we get the following error when trying to view:


An error occurred during client rendering.

The remote server returned an error: (500) Internal Server Error.


Using this generic information we have checked into numerous apparent fixes, from confirming settings in the Central Admin, to changing the Zone Authentication to NTLM, to ensuring Anonymous Access is disabled, as well as some tweaks in IIS, etc.

We're still not having any luck getting the report to generate.

Any assistance would be greatly appreciated.

Classic ASP apps generating error '80070002'


I have a .Net 2.0 dll that is registered for COM interop.  This dll provides authentication for multiple web applications, so we have it registered in our webserver's GAC.  We've also registered it using "regasm my.dll"  For a while it was working with all of our applications, both classic ASP and .Net 2.0 varities.

Recently, our classic ASP applications started giving "error '80070002'" on the line where they tried to instantiate the object.  The weird part is that our .Net 2.0 applications are using the dll without any problems.  None of our applications have a local copy of the file; they all rely on the GAC version.  I've checked in the webserver's c:\windows\assembly directory and the correct versions of our dll are in there.

It is my understanding that being in the GAC would allow all applications access to it.  I haven't been able to find any reason why one set of applications can use it but not the other.

Any help is appreciated.


Visual Studio 2010 is generating an error when i try to debugging !! ( some dll dependencies error)


Error    1   :  Could not load file or assembly 'file:///C:\Windows\Microsoft.NET\Framework\v4.0.30319\Temporary ASP.NET Files\website8\fc57c8f4\9cd69aba\App_global.asax.f2udfgci.dll' or one of its dependencies. The system cannot find the file specified.      



Server Error in '/WebSite8' Application.

Could not load file or assembly 'file:///C:\Windows\Microsoft.NET\Framework\v4.0.30319\Temporary ASP.NET Files\website8\07dcfacd\cdec788c\App_global.asax.thpappgt.dll' or one of its dependencies. The system cannot find the file specified.

Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.IO.FileNotFoundException: Could not load file or assembly 'file:///C:\Windows\Microsoft.NET\Framework\v4.0.30319\Temporary ASP.NET Files\we

Surrogate vs Natural Primary Keys - Data Modeling Mistake 2 of 10

In case you're new to the series I've compiled a list of ten data modeling mistakes that I see over and over that I'm tackling one by one. I'll be speaking about these topics at the upcoming IASA conference in October, so I'm hoping to generate some discussion to at least confirm I have well founded arguments.

The last post in this series Referential Integrity was probably less controversial than this one. After all, who can argue against enforcing referential integrity? But as obvious as surrogate keys may be to some, there is a good deal of diversity of opinion as evidenced by the fact that people continue to not use them.

Visual Studio Shortcut Keys

The following tables describe the shortcut keys in the Microsoft Dynamics AX Debugger.

IsapiModule Error 500 Issue


I am about exhausted trying to figure out this error:

HTTP Error 500.0 - Internal Server Error

Description: The page cannot be displayed because an internal server error has occurred.

Error Code: 0x8007007b

Notification: ExecuteRequestHandler

Module: IsapiModule

Requested URL: http://localhost:80/ReportServer

Physical Path: c:\Program Files\Microsoft SQL Server\MSSQL.2\Reporting Services\ReportServer

When I enable Failed Request Tracing Rules and view the log output I am supposing that the actual problem is in the 2nd call where there are 2 backslashes before the actual filename in the specified path:


CALL_ISAPI_EXTENSION DllName="C:\Windows\Microsoft.NET\Framework\v2.0.50727\\aspnet_isapi.dll"


Handling 404 page not found with Error page



      How do i handle 404 page not found?

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