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?
Go-BruinsAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Hypercat (Deb)Commented:
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.
0
Go-BruinsAuthor 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?
0
Hypercat (Deb)Commented:
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
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Determine the Perfect Price for Your IT Services

Do you wonder if your IT business is truly profitable or if you should raise your prices? Learn how to calculate your overhead burden with our free interactive tool and use it to determine the right price for your IT services. Download your free eBook now!

Hypercat (Deb)Commented:
NOTE:  You want to download the SQLEXPR_ADV file so that you get the management tools (Management Studio).
0
Go-BruinsAuthor 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?
0
Hypercat (Deb)Commented:
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.
0
Go-BruinsAuthor 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?
0
Hypercat (Deb)Commented:
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.
0
Go-BruinsAuthor 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.
0
Go-BruinsAuthor 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
0
Hypercat (Deb)Commented:
Use the Local System account for all services.
0
Go-BruinsAuthor Commented:
Got it installed. You deserve way more than 500 pts. Thank you.
0
Hypercat (Deb)Commented:
You're very welcome. Enjoy!
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Windows Server 2012

From novice to tech pro — start learning today.