[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 552
  • Last Modified:

SQL 2008 reinstall on Windows 2008 SBS

I have a Windows 2008 SBS server. Somehow, in the process of installing another application the SQL component was removed. I thought it'd be easy enough to reinstall but I'm not able to work it out. I don't seem to be able to start setup again  (it seems to want to reinstall the whole O/S)

I don't see anything in roles or features either.

So the question is how do I reinstall SQL on a pre-existing 2008 SBS install? And, after that, how do I get Sharepoint working with the new SQL install?
0
underIce
Asked:
underIce
  • 4
  • 3
1 Solution
 
ronnypotCommented:
Hi,

Here http://technet.microsoft.com/en-us/library/sbs-2008-repair-guide%28WS.10%29.aspx you can find a complete set of document about repairing a SBS 2008 server, it has a seperate section for Sharepoint. Sharepoint uses the Windows Internal Database for storage so take a look how to repair that.
0
 
underIceAuthor Commented:
I looked that document over and I'm not seeing anything to do with SQL. The Manage Server Applications sounded good but there doesn't seem to be any such console (or even in help).

There must be some way to reinstall SQL?
0
 
ronnypotCommented:
The SQL database used by sharepoint is called the Windows Internal Database which is also used by WSUS. It is installed as a part of the WSUS and Sharepoint setup, so following these step would help you.
Otherwise, here http://www.thehelpdesk.co.nz/2011/03/reinstallrepair-sbs-2008-companyweb.html is a description how to reinstall all those features in one document
0
What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

 
underIceAuthor Commented:
Ok, thanks....looks like I have the Sharepoint issues worked out. But I still don't see any way of reinstalling SQL...I feel like I'm missing something obvious.
0
 
underIceAuthor Commented:
Any insights on SQL reinstall on 2008 SBS?
0
 
ronnypotCommented:
Which SQL do you want to reinstall? because the one used by WSUS and sharepoint is called Windows internal database and is described in the link I posted in the previous post.

If it is the SQL instance used by SBS monitoring, it is a sublink in the article from the first post. here direct to the sublink: http://technet.microsoft.com/en-us/library/dd560614(WS.10).aspx
0
 
underIceAuthor Commented:
Thanks!
0

Featured Post

Get free NFR key for Veeam Availability Suite 9.5

Veeam is happy to provide a free NFR license (1 year, 2 sockets) to all certified IT Pros. The license allows for the non-production use of Veeam Availability Suite v9.5 in your home lab, without any feature limitations. It works for both VMware and Hyper-V environments

  • 4
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now