And… I am blogging on WordPress also!

First of all, many thanks to all the friends and followers who always inspire me to share my knowledge with the world. In recent past I have been actively participating in MSDN forums and realized that there is so much knowledge to be shared. Many times I have to write same answer and then I…

4

It’s Denali now!!!

Most of us know the SQL Server next version – code name “Denali” CTP1 has been released. Today, I have downloaded and installed it on my VM to lean more.. Here is the download link As soon as I started setup, after few steps, I was stuck with below error When I tried on Windows…

2

How to install Clustered SQL Server 2008 on Windows 2008 Cluster using Hyper-V (Guest Clustering) Part – 1

After hearing a lots of feedback on my previous blog post on SQL 2005 Cluster on Virtual Server, I decided to spend some time to write a blog to install SQL 2008 on Windows 2008 R2 Cluster in Virtual Environment using Hyper-V. New Series is posted here http://blogs.msdn.com/sqlserverfaq/archive/2010/03/30/how-to-install-clustered-sql-server-2008-on-windows-2008-cluster-using-hyper-v-guest-clustering-part-1.aspx Work is in progress for rest part…

1

How to move SQL Server from Standalone to Cluster environment

Few days back there was a question in our internal forum about moving SQL Server from Standalone to cluster environment. Based on my experience there are many ways to move standalone SQL Server to clustered SQL Server. As you all know that SQL Server has two kind of databases User databases. System databases {master, model,…

5

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