Sql server windows authentication change user

By using Windows Authentication, Windows groups can be created at the domain level, and a login can be created on SQL Server for the entire group. Managing access from at the domain level can simplify account administration. Users connecting using SQL Server Authentication must provide their credentials login and password every time that they connect.

For strong password guidelines, see Strong Passwords. Requires the user to change the password the next time that the user connects. Third-party software developers should provide this feature if this option is used. This includes password length and complexity. In the Run dialog box, type secpol. If a user is a Windows domain user who has a login and password for Windows, they must still provide another SQL Server login and password to connect.

Keeping track of multiple names and passwords is difficult for many users. Having to provide SQL Server credentials every time that one connects to the database can be annoying.

Sign in. United States English. Ask a question. Quick access. Search related threads. Remove From My Forums. Answered by:. Archived Forums. Getting started with SQL Server. Beginners just getting started - here's the place for help with simple questions. For installation or setup questions, refer to the Setup Forum. Sign in to vote. Hi Experts, Could anyone give me the answers fot the two questions below?

Skip to main content. This browser is no longer supported. Download Microsoft Edge More info. Contents Exit focus mode. Is this page helpful? Please rate your experience Yes No. Any additional feedback? Caution The following example uses an extended stored procedure to modify the server registry. Server Fault is a question and answer site for system and network administrators. It only takes a minute to sign up. Connect and share knowledge within a single location that is structured and easy to search.

We're using Sql Server with Windows Authentication setup. So normally, when you log in using e. Anyways, on this one particular computer, the person said they had to make a new account called User01 to do something and showed me where she'd created it under security in the "master" system database. It's still set to Windows Authentication, though, and I'm unable to change the login name.

Now here's where the real problem comes in I didn't realize that she was being logged in under this user name at the time, and I disabled it to see what would happen. Now I can't log into the server under her account. However, the area where the User01 account was listed is not visible to me as far as I can tell and so I can't reenable it. So in a nutshell, ideally I'd like to reenable User01 somehow, just to get things back to where they used to be.