Asp.Net 2 Membership.ValidateUser only working with Case Insenstive username










0















Asp.Net 2.0 Membership, MemberShip.ValidateUser not working with case sensitive username. I tried setting loweredusername column in aspnet_users to case sensitive. Something like this



ALTER table aspnet_Users alter COLUMN LoweredUserName NVARCHAR(256)
COLLATE SQL_Latin1_General_CS_AS NOT NULL


but is also didn't work.



Any idea on how to change it.










share|improve this question


























    0















    Asp.Net 2.0 Membership, MemberShip.ValidateUser not working with case sensitive username. I tried setting loweredusername column in aspnet_users to case sensitive. Something like this



    ALTER table aspnet_Users alter COLUMN LoweredUserName NVARCHAR(256)
    COLLATE SQL_Latin1_General_CS_AS NOT NULL


    but is also didn't work.



    Any idea on how to change it.










    share|improve this question
























      0












      0








      0








      Asp.Net 2.0 Membership, MemberShip.ValidateUser not working with case sensitive username. I tried setting loweredusername column in aspnet_users to case sensitive. Something like this



      ALTER table aspnet_Users alter COLUMN LoweredUserName NVARCHAR(256)
      COLLATE SQL_Latin1_General_CS_AS NOT NULL


      but is also didn't work.



      Any idea on how to change it.










      share|improve this question














      Asp.Net 2.0 Membership, MemberShip.ValidateUser not working with case sensitive username. I tried setting loweredusername column in aspnet_users to case sensitive. Something like this



      ALTER table aspnet_Users alter COLUMN LoweredUserName NVARCHAR(256)
      COLLATE SQL_Latin1_General_CS_AS NOT NULL


      but is also didn't work.



      Any idea on how to change it.







      sql asp.net forms-authentication






      share|improve this question













      share|improve this question











      share|improve this question




      share|improve this question










      asked Nov 14 '18 at 18:47









      Nayas SubramanianNayas Subramanian

      1,1711118




      1,1711118






















          1 Answer
          1






          active

          oldest

          votes


















          0














          I just was going in the wrong direction. Issue was with Membership.ValidateUser in Asp.Net membership method targets to store procedure [aspnet_Membership_GetPasswordWithFormat]. In this stored proecedure we need to change



           Lower(@username) = m.LoweredUserName to @username = m.username.





          share|improve this answer






















            Your Answer






            StackExchange.ifUsing("editor", function ()
            StackExchange.using("externalEditor", function ()
            StackExchange.using("snippets", function ()
            StackExchange.snippets.init();
            );
            );
            , "code-snippets");

            StackExchange.ready(function()
            var channelOptions =
            tags: "".split(" "),
            id: "1"
            ;
            initTagRenderer("".split(" "), "".split(" "), channelOptions);

            StackExchange.using("externalEditor", function()
            // Have to fire editor after snippets, if snippets enabled
            if (StackExchange.settings.snippets.snippetsEnabled)
            StackExchange.using("snippets", function()
            createEditor();
            );

            else
            createEditor();

            );

            function createEditor()
            StackExchange.prepareEditor(
            heartbeatType: 'answer',
            autoActivateHeartbeat: false,
            convertImagesToLinks: true,
            noModals: true,
            showLowRepImageUploadWarning: true,
            reputationToPostImages: 10,
            bindNavPrevention: true,
            postfix: "",
            imageUploader:
            brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
            contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
            allowUrls: true
            ,
            onDemand: true,
            discardSelector: ".discard-answer"
            ,immediatelyShowMarkdownHelp:true
            );



            );













            draft saved

            draft discarded


















            StackExchange.ready(
            function ()
            StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53306891%2fasp-net-2-membership-validateuser-only-working-with-case-insenstive-username%23new-answer', 'question_page');

            );

            Post as a guest















            Required, but never shown

























            1 Answer
            1






            active

            oldest

            votes








            1 Answer
            1






            active

            oldest

            votes









            active

            oldest

            votes






            active

            oldest

            votes









            0














            I just was going in the wrong direction. Issue was with Membership.ValidateUser in Asp.Net membership method targets to store procedure [aspnet_Membership_GetPasswordWithFormat]. In this stored proecedure we need to change



             Lower(@username) = m.LoweredUserName to @username = m.username.





            share|improve this answer



























              0














              I just was going in the wrong direction. Issue was with Membership.ValidateUser in Asp.Net membership method targets to store procedure [aspnet_Membership_GetPasswordWithFormat]. In this stored proecedure we need to change



               Lower(@username) = m.LoweredUserName to @username = m.username.





              share|improve this answer

























                0












                0








                0







                I just was going in the wrong direction. Issue was with Membership.ValidateUser in Asp.Net membership method targets to store procedure [aspnet_Membership_GetPasswordWithFormat]. In this stored proecedure we need to change



                 Lower(@username) = m.LoweredUserName to @username = m.username.





                share|improve this answer













                I just was going in the wrong direction. Issue was with Membership.ValidateUser in Asp.Net membership method targets to store procedure [aspnet_Membership_GetPasswordWithFormat]. In this stored proecedure we need to change



                 Lower(@username) = m.LoweredUserName to @username = m.username.






                share|improve this answer












                share|improve this answer



                share|improve this answer










                answered Nov 15 '18 at 15:08









                Nayas SubramanianNayas Subramanian

                1,1711118




                1,1711118





























                    draft saved

                    draft discarded
















































                    Thanks for contributing an answer to Stack Overflow!


                    • Please be sure to answer the question. Provide details and share your research!

                    But avoid


                    • Asking for help, clarification, or responding to other answers.

                    • Making statements based on opinion; back them up with references or personal experience.

                    To learn more, see our tips on writing great answers.




                    draft saved


                    draft discarded














                    StackExchange.ready(
                    function ()
                    StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53306891%2fasp-net-2-membership-validateuser-only-working-with-case-insenstive-username%23new-answer', 'question_page');

                    );

                    Post as a guest















                    Required, but never shown





















































                    Required, but never shown














                    Required, but never shown












                    Required, but never shown







                    Required, but never shown

































                    Required, but never shown














                    Required, but never shown












                    Required, but never shown







                    Required, but never shown







                    Popular posts from this blog

                    Top Tejano songwriter Luis Silva dead of heart attack at 64

                    政党

                    天津地下鉄3号線