We help IT Professionals succeed at work.

SQL Server 2008 Express R2 and Windows Server 2012

Hi,

I need to install SQL Server 2008 Express R2 onto a Windows Server 2012 Essentials, but I'm getting the following error msg:

Capture
It seems MS BCM Database Management Tool needs this specific version of SQL Server. Can anyone help?
Comment
Watch Question

Check out this article:

http://support.microsoft.com/kb/2681562

Looks like you need to be on at least SP1 for SQL 2008 R2 or SP3 for SQL 2008.

Author

Commented:
Thank you. From the looks of the article, it seems to suggest that I ignore the error, install, then apply the Service Pack 3?
Yes, that would be OK. Or you could use a SQL 2008R2 Express install file with SP2 included:

http://www.microsoft.com/en-us/download/details.aspx?id=30438
NOTE:  You want to download the SQLEXPR_ADV file so that you get the management tools (Management Studio).

Author

Commented:
Thank you.

So after I install the SQL 2008R2 w SP2, I run the SQLEXPR_ADV to install the management tools - in that order, correct?
No - it's one install. The SQLEXPR_ADV download contains all the installation files for SQL Express, and the management tools will be an option you want to select during the installation.

Author

Commented:
Ok - glad I got that cleared up. I'm going to give it a whirl and report back.

What are some of the benefits of the Mgmt Studio for a newbie like me?
It provides a graphical interface for managing your SQL database.  For example, managing security, checking usage and who is logged on to the database at any particular time, database backups, attaching and detaching databases (i.e., to move the files), performing simple SQL queries to check data attributes or find some piece of information buried in a table somewhere - all these things are very easy to do using the Management Studio tool. You can also set up more complex tasks like scheduled backups and perform other database management tasks on a scheduled basis.

Author

Commented:
Awesome. thank you. I'm installing now. It seems to require the .NET Framework 3.5 Features, so I'm installing the first.

I'll report back.

Author

Commented:
One more question during install:

At this screen, do I simply put the Server Admin name? So for example, if the Domain name is "Acme", and the admin name is "Boss", do I put "Acme\Boss"?

And should I click "Use the same account for all SQL Server services"?

Capture
Use the Local System account for all services.

Author

Commented:
Got it installed. You deserve way more than 500 pts. Thank you.
You're very welcome. Enjoy!