asked on

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:

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

Hypercat (Deb)

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.

Go-Bruins

ASKER

Thank you. From the looks of the article, it seems to suggest that I ignore the error, install, then apply the Service Pack 3?

ASKER CERTIFIED SOLUTION

Hypercat (Deb)

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

SOLUTION

Hypercat (Deb)

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Go-Bruins

ASKER

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?

Hypercat (Deb)

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.

Go-Bruins

ASKER

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?

Hypercat (Deb)

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.

Go-Bruins

ASKER

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.

Go-Bruins

ASKER

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"?

Hypercat (Deb)

Use the Local System account for all services.

Go-Bruins

ASKER

Got it installed. You deserve way more than 500 pts. Thank you.

Hypercat (Deb)

You're very welcome. Enjoy!