.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

Why is it so hard to get the security working with MySQL?

Posted By:      Posted Date: September 06, 2010    Points: 0   Category :ASP.Net
I have some problems to get the security to work under MySQL. When I go to the ASP.net configurator it isn't possible to get to the tab "security". I get the following error : Unable to initialize provider. Missing or incorrect schema.So I searched on google. There 're thoussand of people who have/had the same problem, BUT there is nobody who can give me the right answer. Why? Is it so hard to get MySQL working in ASP.net?What where the things to do:Set autogenerateschema to "True"',Set the following ddl in the bin directory --> MySql.Data.dll and MySql.Web.dll,Use the MySql Website configurator,and I tried different connectionstrings (yeh that is possible, I was also suprised) to get to the same database.So is there maybe someone at this forum who can give me the answer for what I can do to tackle this one?Thnx.

View Complete Post

More Related Resource Links

SSRS custom security extension behind a router fire wall not working

I have a instance of SSRS 2008 installed (we are not using IIS) with custom security extension which accepts a application user ID and password and sends back a sql authorization cookie back to client for logging into SSRS.  The (SSRS) server is behind a router,  SSRS is configured on port 81,  Port 81 in router if forwarded to the SSRS server. Here is the problem If I am inside the router firewall (RDP'ed to the machine) I am able to access report server (http://xx.xxx.xxx.xx:81/ReportServer) and reports manager (http://xx.xxx.xxx.xx:81/Reports) without any issues. If  am outside the firewall and try to go to report server page (http://xx.xxx.xxx.xx:81/ReportServer) from browser and try to login it works (I am getting the cookie back and authentication goes through fine).   But if I try to access reports manager (http://xx.xxx.xxx.xx:81/Reports) the login page shows up when I enter user ID and password and hit enter to authenticate it comes back to the login screen (I am not gettint the cookie back from SSRS). Any help is highly appreciated on how to debug /fix this issue. Note : if I first login to Reportserver (which sends the cookie back) and in the same session I login to Reports Manager I am able to get into Reports Manager page since I got the cookie when I logged in to reports server page already.  When I

Menu - Role security not working on second level of sitemap


I have role assignments on both the first and second level of my menus within my sitemap file.  The first level works fine, and I only see items assigned to my role.

But roles assignments seem to have no effect on the second level.  It seems like if you have access to the first level, you have access to everything on the second level.

Is this correct?

From my sitemap (either a SalesRep or an Administrator can see everything underneath):

    <siteMapNode title="Administration" roles="SalesRep,Administrator" description="Admin" >

      <siteMapNode title="CompanyMaintenance" roles="SalesRep" url="~/Admin/CompanyManagement.aspx" />

      <siteMapNode title="Initialize Roles" roles="Administrator" url="~/Admin/Roles.aspx"/>


From my config:

    <roleManager enabled="true" defaultProvider="SqlRoleProvider">

Alert for Security Groups not working



I am trying to set up an alert on SharePoint to go out to everybody in an AD Security Group. I encountered the problem that the initial "Alert Created" email went out to everybody, but after that the actual alerts don't get sent. Googling this problem has taken me to a lot of sites with a similar problem, but unfortunately I haven't found a solution that works for me.

It seems one of the key points is that the Security Group needs to be added to a SharePoint Group that has got access permissions to the list I am trying to alert on. I have done that. I have added the AD Group to a SharePoint Group that has got read, view and contribute permissions to the list. But still no success.

I have added an individual alert for myself and that comes through just fine. But the alert to the Security Group just isn't being sent.

Am I missing something else?

Sharepoint 2010 security token services is not working.



I have sharepoint 2010 server , i m tryiing to search on sharepoint site but i am getting error "security token service is not avaible"

I have already applied wcf hotfix but stil getting exception when i open this service ,so is there any workaround to start this service or any workaround to search on sharepoint site(I am using sharepoint.office.search dll to search on sharepoint site)


Please reply as its really urgent


Thanks in advance!!


Need help setting up a Custom Security Trimmer, CheckAccess method not working.


I'm implementing the custom security trimmer for SharePoint server as outlined here: http://msdn.microsoft.com/en-us/library/ee819923.aspx

I have been able to successfully deploy the solution on to the server, but know I need to write the script that will check whether users have access to particular documents or not. The code in the walk-through is the following:

public BitArray CheckAccess(IList<String> documentCrawlUrls, IDictionary<String, Object> sessionProperties, IIdentity passedUserIdentity)
            BitArray retArray = new BitArray(documentCrawlUrls.Count);
            //Use passedUserIdentity to get the identity of the user who issued the query.
            IClaimsIdentity claimsIdentity = (IClaimsIdentity)passedUserIdentity;
           //IClaimsIdentity is defined in Microsoft.IdentityModel.Claims;
            for (int x = 0; x < documentCrawlUrls.Count; x++)

Hard-coded SSRS datasource not working in SSMS


Hi... Using Report Designer to design a report inside SSMS..

Server A contains a database of database growth statistics for all servers...
I have a SSRS report to present this data, using a datasource of "Server A."

In preview mode, report works against all servers and database combinations.

But when I use the report in SSMS (I right-click database and select Custom Report).,
1. Running the report against a database on Server A works fine.
2. Any database on Servers B and C report they cannot find the stats database.

My report's local datasource specifically references Server A at design-time, but tracing reveals at run-time it looks to itself for the stats database.

How can I prevent a datasource from deviating from where I specified?

linq not working on shared server with Medium Trust security


On my PC everything is all rigth but on the webserver I get an error: 'OrderBy' is not a member of 'System.Array', maybe due to the trust level.
Is there I way to bypass this or I have to resign myself to it?

Dimension security not working as expected


I'm implementing a Market dimension where a user may have access to some markets and within a specific market certain periods.  The Market dimension has two levels -- Market Name and Market Period.  The Market Period level has an entry for every period with data within the Market.  The fact tables join to the Market dimension at the Market Period level.  For obvious reasons, the Market Period level is not visible.  It is only to be used for implementing security.

For testing, I have created a role which has the Deselect all members set on the Market Name level and only one market selected.  At the Market Period level, I also have Deselect all member and have selected the specific periods that I want to display.  This looks like it should implement exactly what I want.

I reprocess the cube and look at it using the BIDS browser with the test role I setup.  I see all markets.  I assume that I'm missing something glaringly obvious, but I can't see it.

Linked Server for MySQL database not working


Dear All,

I have installed MySQL Database on my local PC (WAMPServer 2.1)
I want to update few tables in my SQL Server (2008) Database from MySQL Database.

To achive this I have created a linked server in SQL Server for MySQL Database using System DSN. Now I can query to all tables from linked server for example:


It reterive few rows and then give error message

Msg 0, Level 11, State 0, Line 0
A severe error occurred on the current command. The results, if any, should be discarded.
Msg 0, Level 20, State 0, Line 0
A severe error occurred on the current command. The results, if any, should be discarded.


Working with SharePoint document libraries

Document libraries are collections of files that you can share with team members on a Web based on Microsoft Windows SharePoint Services. For example, you can create a library of common documents for a project, and team members can use their Web browsers to find the files, read them, and make comments. Users with Microsoft Office 2003 can check out and edit the files as if they resided on a local or network drive.

By default, your team Web site comes with a built-in document library named Shared Documents, which is listed on the Quick Launch bar as well as on the Documents and Lists page.

SharePoint Tutorial - Security

Security in SharePoint is comprised of users, groups and roles.

Users, Groups and Roles

A user account comes from the authentication system. For example, if Active Directory is used to authenticate then the user accounts will come from it.

There are two types of groups SharePoint uses: domain groups and SharePoint groups.

Working with DropDownList and ListBox Controls in ASP.NET

"In my application i am using dropdownlist to display all categories from a table. When the user clicks this control I display all records in that category. Category table also contains column called color.

I wanted display some categories in dropdown list different color and others in different color using ASP.NET."-Anonymous

Asp.net web site security database


Hello all, I'm new to asp.net and I'm currently practising some few stuffs. I'm creating a hotel reservation system using ASP.net Web site in visual studio 2008 and I currently don't have an App_Data in my solution explorer unlike visual web developer.

1. I have planned to make users of the website login before making their reservations.

2. I have also planned to develop the website such that I will be able to know all reservations made by each user.

First and formost, I will like to know how I can access/View the security database?

Secondly, how do I link my custom made reservation database and the security database in order to achieve my second plan above.?

Someone help me.

Thank you.



hello i have the following problem

i have upload my content to hosting server but i get the following error

Security Exception

Description: The application attempted to perform an operation not allowed by the security policy.  To grant this application the required permission please contact your system administrator or change the application's trust level in the configuration file.

Exception Details: System.Security.SecurityException: Request for the permission of type 'System.Web.AspNetHostingPermission, System, Version=, Culture=neutral, PublicKeyToken=b77a5c561934e089' failed.

Source Error:

An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.

Stack Trace:

[SecurityException: Request for the permission of typ

Server side validation of Fileupload control not working



I've tried this method in my code behind to try and validate that the Fileupload control has a file or not. I get the error message the the event "Server Validate" cannot be found. Can anyone tell why? Thanks.

Public Sub CustomValidator1_ServerValidate(ByVal source As Object, ByVal args As System.Web.UI.WebControls.ServerValidateEventArgs) Handles CustomValidator1.ServerValidate

' Get file name

        Dim uploadAvatar As FileUpload = DirectCast(AdvertisementForm.FindControl("uploadAvatar"), FileUpload)

        Dim UploadFileName As String = uploadAvatar.PostedFile.FileName

        If UploadFileName = "" Then
            ' There is no file selected
            args.IsValid = False
            Dim Extension As String = UploadFileName.Substring(UploadFileName.L

Row command working on all rows not selected one?



I have this code that hides a column in a gridview.  (The column houses another nested gridview).

    Protected Sub GridView1_RowCommand(ByVal sender As Object, ByVal e As System.Web.UI.WebControls.GridViewCommandEventArgs) Handles GridView1.RowCommand
        If e.CommandName = "Select" Then
            If GridView1.Columns(0).Visible = False Then
                GridView1.Columns(0).Visible = True
                GridView1.Columns(0).Visible = False
            End If
        End If
    End Sub

The trouble is that if I click the select link on one row that action to hide is carried out on all rows.  How can I set this up so that it only hides the row that is selected?


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