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?
 
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
 
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
Simplify Active Directory Administration

Administration of Active Directory does not have to be hard.  Too often what should be a simple task is made more difficult than it needs to be.The solution?  Hyena from SystemTools Software.  With ease-of-use as well as powerful importing and bulk updating capabilities.

 
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.