Provides Professional Knowledge about Password/Data Recovery and Product Key

SQL Server

How to Recover Lost Access to a SQL Server Instance

Cannot access SQL Server instance? How can you connect to SQL Server instance after lost access to it? First, you have to clarify why you lost access to SQL Server instance. Second, take appropriate measures to fix problem which lead to losing SQL Server instance access privileges. In this passage, probably we cannot list all […]

How to Unlock SQL Server 2014 Database after SA Password Forgot

After SA password forgot, how can you unlock SQL Server 2014 database or connect to SQL Server database? If Windows Authentication and SQL Server Authentication mode are enabled in SQL Server 2014 database, now you can run SQL Server 2014, and choose Windows Authentication mode to connect to database. So that we can see unlock […]

How to Install SQL Server 2012 in Windows 7/8 Virtual Machine

Prerequisites: 1. Windows system: Windows 7/8 2. Hardware and software requirements: .NET Framework 3.5, Windows PowerShell, Network Software, Internet Software, Hard Disk, Drive, Monitor, Internet. 3. Processor, Memory, and Operational System Requirements: Memory: 512 MB (Express Editions), 1GB (All other editions) Processor Speed: 1.0 GHz (x86 Processor), 1.4 GHz (x64 Processor) Processor Type: x64 Processor: […]

How to Access to SQL after Lost SQL Server Database SA Password

Maybe you have faced such an issue of losing SQL Server SA password.  SQL Server SA password was ever set for protecting database, however, now it has become a problem for us to login SQL Server and access data in SQL Server. How to access SQL Server no logon password? If you are a computer […]

MSSQL Reset SA Password after Database File Locked

MSSQL database file is locked and we couldn’t open it in SQL Server. Whether could we reset SA password to open it? Undoubtedly the answer is yes. SA account is the default administrator of SQL Server. So not only opening database file, but also all of things could be done by SA account in Microsoft […]

Lock and Unlock Record in SQL Server Database

Why we lock and unlock record in SQL Server Database? And how do we lock and unlock records as we will? 1. Lock Record in SQL Server Database “I want to insert a record into permanent table but I don’t want anyone (any other session) to have access to that record until I allow it. […]