Print

Training >> Browse Articles >> Technology (Equipment)

+1

SQL 2008 SA Password Reset

Article Submitted by:
Kkx_max50

killytu

almost 4 years ago

35 articles submitted

Killytu

How to reset sa password in SQL Server 2008 when forgot the sa password?

Many time, This problem comes, they have setup SQL 2008 or SQL 2008 R2 for development or QA environment, but they don't know the login sa password by which they can connect to server. In SQL Server 2005, SQL used to fixed group sysadmin with the server role BUILTIN\Administrators, that is to say, all local NT administrator automatically add a SQL Server system administrator. But since 2008 Windows BUILTIN\Administrators group is not included by default in the sysadmin server role in SQL Server.

So, follow the steps mentioned to reset SQL 2008 password for SA account if no BUILTIN\Administrators.

sql server password recovery

Step 1. Download and install MS SQL Server Password Unlocker.
Step 2. Run MS SQL Server Password Unlocker, click Open, import the master.mdf file. All the user names of your SQL Server will be displayed.
Step 3. Select an SQL account, such as 'SA', click Change Password button.
Step 4. Type a new password, and then click OK.

The new password has been set for your SA account, now you can login SQL Server with the new password.

Currently SQL Server 2008 still supports two types validation and authentication for access link to resources database, Windows authentication mode and SQL Server and Windows authentication mode which also known as mixed mode. Both of these authentication methods provide access to SQL Server 2008 and its resources.

The Mixed Mode - SQL Server and Windows Authentication Mode

SQL Server and Windows Authentication Mode uses either Active Directory user accounts or SQL Server accounts when validating access to SQL Server. SQL Server 2005 introduces a new way, the policy of the password and account lockout the policy session of SQL Server by using SQL Server implement authentication. SQL Server 2008 also to do so. The policy of SQL Server that can be used include password complexity, password expiration and account lockout. This feature is not available in SQL Server 2000 and becomes a major security risk for most organizations and database administrators. In essence, this weakness has contributed to the Windows authentication set as best practice for the management of authentication in the past. Today, SQL Server and Windows authentication mode may be able to successfully compete with the Windows Authentication Mode.


+1
  • Photo_user_blank_big

    Linda22

    over 3 years ago

    6 comments

    SMARTKEY Password Recovery Bundle is a must-have toolkit to recover/remove/reset passwords for Windows, Excel, Word, Access, PowerPoint, Outlook, Outlook Express, PDF, RAR/WinRAR, ZIP/WinZIP, MSN, AOL, Google Talk, Paltalk, Trillian, Miranda, Opera, Firefox and IE Browser, etc. Over 21 types of passwords can be Recovered instantly. Until now, these password recovery tools are the fastest on the market, the easiest to use and the least expensive..
    http://www.recoverlostpassword.com/products/passwordrecovery.html

Adminsecret School Finder

Save time in your search for a degree program. Use AdminSecret's School Finder to locate schools online and in your area.

Get Info

* In the event that we cannot find a program from one of our partner schools that matches your specific area of interest, we may show schools with similar or unrelated programs.

Recent Activity

Photo_user_blank_big
Yahoo commented on: "смотреть Король сафари 2013 Хжя", less than a minute ago.
Photo_user_blank_big
aretafut1974 submitted the article: "Free Download Bitdefender Antivirus For Windows 7", less than a minute ago.
Photo_user_blank_big
weiculphovic1979 submitted the article: "Кайт трейлер 2013 ШСЖ", less than a minute ago.
Photo_user_blank_big
bokewebcdy1978 submitted the article: "Tally 7.2 For Windows 7 32 Bit Free Download With Crack", less than a minute ago.
Photo_user_blank_big
sionuawalllo1973 submitted the article: "Windows Server 2003 Service Pack 2 Key Download", less than a minute ago.