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

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


Posted By:      Posted Date: September 16, 2010    Points: 0   Category :Sql Server
Hmm... CREATE LOGIN [default2] WITH PASSWORD = 0x0100A9794372EE68B38BC393A9A3709BDD93DE7F04CA4342B2B6 HASHED MUST_CHANGE, CHECK_EXPIRATION = ON, CHECK_POLICY = ON; GO results inMsg 33010, Level 16, State 1, Line 1The MUST_CHANGE option cannot be specified together with the HASHED option.But documentation states that it is correct to use MUST_CHANGE together with HASHED: CREATE LOGIN loginName { WITH <option_list1> | FROM <sources> } <option_list1> ::= PASSWORD = { 'password' | hashed_password HASHED } [ MUST_CHANGE ] [ , <option_list2> [ ,... ] ] Bug?

View Complete Post

More Related Resource Links

I thought this would be simple... Trying to create a login does an ajax check before submit


I have the standard .net login control that is working.  (Still learning .net after 15yrs of classic)

What I want to do is OnButtonClick run a javascript function (to do an ajax call to the db to check if login is valid or not) and if it returns true, then submit the form normally, else don't submit. The piece that I can't figure out, is how to correctly override the default click even to hit my JS routine and then submit the form properly afterwards.

Thanks ahead of time

create user wizard login error message dont show in a message box?




i am using create user wizard and capturing other information within content template when a new user

registers. Some of the textboxes are binded to required field validators.


there is a validation control on the page and ShowMessage box is True.

If they dont complete some of the text boxes then the message box pops Up with the error message.

It does not however include information errors like "User already exists" or Email address already exists

from the create user wizard membership  UserName and Password Textboxes


is it possilbe to hook all of these up so I get one message box with all errors including membership ones?




Desktop Security: Create Custom Login Experiences With Credential Providers For Windows Vista


Why is a change to the Windows logon plug-in interface so exciting? Because with credential providers you can customize the logon experience for your users.

Dan Griffin

MSDN Magazine January 2007

I want to create registration page and login page


I have design form layouts for signup and login pages 

Please provide me the step by step code for sign up and login pages using c# with validation.

waiting for urgent reply

how to create gmail type login?



For my project, i have designed a login page like gmail.

According to the  credentials given by the  users the application should send to the corresponding pages asigned to them.

Please give me the answer.

Thanks in advance.

how do i create a windows form application login for to validate username and password from sql serv

 I would like to know how I can create a login form for my windows form application. The login form must be linked to a SQL server 2005 express edition database (in which the username and passwords are stored). The login form must validate the user using the database and allow them to access the program. 

create a sql server 2005 new login for SQL Injection prevention

    Hi All,  Thank you for advance. Our database affected with SQL Injection. so We need to create a sql server 2005 new login for SQL Injection prevention User can perform, access tables with select,update and delete queryaccess views, functions and stored procperform cursor     what are the permissions given for that login account?

How to create SQL-login with permissions for view-only SQL-Agent-Jobs?

Could you please help me with resolving next problem: How to create SQL-login with permissions for view -only SQL-Agent-Jobs (he cannot create, modify or delete)? I am using MS-SQL-Server version: 8.00.194 In other words : how to create in version 2000 (8.00.194) the same as 'SQLAgentReaderRole ' in version 2005 (for more details see http://technet.microsoft.com/en-us/library/ms188283.aspx).

how to create a login window from where user could login from their gmail or others id and write the

hello friends,i m currently creating an article module, and i want if user wana comment on to the any particular artical, than he should login any of his mail id like gmail, yahoo hotmail etc and than post his or her comment and after than comment should go into the DB..., i know i have to use the google contact api and etc but how to use, ur help would be appriciable.....thanks and regardsInderjeet Singh

How to create SPUser obj or SPRoleAssignment using the user display name not using login name "domai

Suppose there is a user called "Jake Gittes" with login name "domain\jakeg". Now I want to create either SPUser/SPRoleAssignment object using the user full name ("Jake Gittes"). I tried using SPWeb.AllUsers["Jake Gittes"]. But it is throwing exception.

Create SQL Login that utilized Active Directory

Hello SQL Guru, I’m newbie to create SQL Login that utilized Active Directory. I have a SQL Server 2008 Enterprise edition 64-bits that runs in Window Server 2008 R2 Standard Edition 64-bit operating Systems. I configured  the SQL Server 2008 with Window Authentication. Then, I login with built-in Administrator account into computer and connected to my SQL Server 2008.  e.g: Object Explorer displayed COMPUTER NAME\Database Instance Name (SQL Server 10.0.2531 – COMPUTER NAME\Admin Account) Then, I created SQL login on the following: USE AccountingDatabase;GO CREATE USER  DomainName\User Name FOR LOGIN DomainName\User NameGO EXEC sp_addrolemember N’db_datareader’, N’DomainName\User Name’GO I tested it out and the specific login still did not have an access to specific database instance  e.g: “AccountingDatabase” Also, I did not see the “User Mapping” under properties checked/assigned to those specific user. Can anyone help and give me light on best practice. Thanks,Edwin

Why is that I am not able to create login? Error:Server Prindipal 'ms\**** already exists

Hi,   When I try to cretae a login, it gives the following error: Server Prindipal 'ms\**** already exists. The login is not there in sys.server_principals table also.  

How to create separate login account for members ?


I have developed a web application in which i manage details of different companies,,,for that i as admin add companies and their details in my database...right now my role is administrator in my web application

The problem is everytime i have to update company details and other information

I want companies to update their own information...

so how i can create a role and create usernames for companies so that they can login to their individual accounts and update the company information by themselves ?

One important thing of my requirement: One company can have multiple usernames accounts...

How to accomplish this ? please guide me ...

How to create a login forms in sharepoint 2010 using designer


Hello friends,

                  I am mohammad siddiqali new to sharepoint  ,I need to know how to create a login form for a sharepoint 2010



Mohammad Siddiqali

How to create a login form using MVC?


Can some one tell me how to make a login form using MVC? I want to make one so that a user can log in if his data has been stored in a SQL database? Thanks.

How to create a Floating Login Page control ASP.NET


I would like to load the login control on the page loaded... like this



how to do this ? any sample codes?


Can I only create session on login and redirect to login from other apps if not using custom provide


I have created custom a MembershipProvider, SessionIDManager, and SessionStateStore since I need to use custom legacy sessions and logins.. When the Application is ran, it runs the GetSessionID in the SessionIDManager(which is correct)..

The problem then is if there is no session meaning the GetSessionID method returns null, it tries to create a new session using CreateSessionID.. I want it to redirect to the login application(another application)..

We only create and store session information for logged in users and the "session id numbers" come from a file that is pre-populated with "session id numbers"(I didnt design this and its out of my control).. So its not feasable to give everyone who visits the site one of the "session id" numbers..

I also need for users with an "invalid" session(when checked through Validate()) to be redirected to the login page..


Any help here would be great..

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