SQL Server 2005 Express setup failure with error – An error occurred during encryption.

Recently I have worked on one of the case where SQL Server Express Edition was failing with Error The SQL Server service failed to start. For more information, see the SQL Server Books Online topics, "How to: View SQL Server 2005 Setup Log Files" and "Starting SQL Server Manually This is generic error and can…

8

My first experience with hyper-V (Few BIOS setting)

I decided to write a new blog series to Install SQL Server 2008 on Windows 2008 cluster in Virtual environment. Since I got brand new Windows 2008 64 Bit machine, i decided to use Hyper-V to play around. I could install Hyper-V without any issue but I saw below series of error in Event log…

6

SQL Server 2008 Evaluation Edition Expired? Believe me, I already upgraded it. What’s up?

Once you install evaluation edition of SQL Server 2008 and then perform in place upgrade to full version, you may get below error message when you open SQL Server Management Studio. For better search, below is the text of the message Microsoft SQL Server Management Studio: Evaluation period has expired. For information on how to…

25

Script to Change Service Account

Sometime back I was asked by one of my customer who wanted to change the startup account for SQLServer Service and SQLBrowser Service without manually going to SQL Server Configuration Manager and changing password there. By the way, did you know… You should NOT change the password from Services.msc for SQL Server. Only supported way…

3