Solved

How To install Sharepoint 2010 but puting the Database on a differnt server

Posted on 2011-09-16
10
262 Views
Last Modified: 2012-05-12
Hi,

I am going to install Sharepoint in our Domain in the next few days. We have our own Database server where we have every database in the company stored. I would like to install sharepoint so it installs all of it's databases onto this server not the local server which I am installing sharepoint on. Is there anyway of doing this?

Matt
0
Comment
Question by:Contigo1
  • 4
  • 3
  • 3
10 Comments
 
LVL 37

Expert Comment

by:Neil Russell
ID: 36548987
Yes just specify the database server durring the install process.
But you only have ONE DB server, for everything? It better be GOOD :)
0
 
LVL 50

Assisted Solution

by:Ingeborg Hawighorst
Ingeborg Hawighorst earned 333 total points
ID: 36549000
Hello,

sounds like you need to do a bit of research into the SharePoint architecture. SharePoint needs a SQL Server instance for its databases. That SQL Server instance can be on the same server as the SharePoint server, but you can also define a separate instance of SQL Server to host the SharePoint databases.

You may want to have a look at the Technet documentation before you embark on your journey

Plan for server farms and environments -- http://technet.microsoft.com/en-us/library/cc789337.aspx

and specifically

SQL Server 2008 R2 and SharePoint 2010 Products: Better Together -- http://technet.microsoft.com/en-us/library/cc990273.aspx

This topic is far too complex to answer in a single thread.

cheers, teylyn
0
 
LVL 37

Accepted Solution

by:
Neil Russell earned 167 total points
ID: 36549013
0
 
LVL 1

Author Comment

by:Contigo1
ID: 36549045
Neilsr - The Server is very quick and we did it to make it a little easier to look after.

Also when I am in the install wizard for sharepoint 2010 do I need to select server farm If I am going to do this?
0
 
LVL 50

Expert Comment

by:Ingeborg Hawighorst
ID: 36549066
If you don't plan this properly, you're setting yourself up for failure.

Good luck.
0
Complete VMware vSphere® ESX(i) & Hyper-V Backup

Capture your entire system, including the host, with patented disk imaging integrated with VMware VADP / Microsoft VSS and RCT. RTOs is as low as 15 seconds with Acronis Active Restore™. You can enjoy unlimited P2V/V2V migrations from any source (even from a different hypervisor)

 
LVL 1

Author Comment

by:Contigo1
ID: 36549094
teylyn - I have created a replica environment e.g. a database server one a differnt server and one server to install sharepoint on. I have set this up on some VM's on a differnt machine so I can practice running through the install until I get it right without losing or damaing anything within our Domain.

Do I need to select install server farm when I am installing sharepoint if I want to install the database on a differnt server?
0
 
LVL 50

Assisted Solution

by:Ingeborg Hawighorst
Ingeborg Hawighorst earned 333 total points
ID: 36549132
You could use the resources freely available from Microsoft.

Here's a video walk through:

Installing SharePoint Server 2010
http://technet.microsoft.com/en-us/library/ff607866.aspx

I strongly advise you to do your homework first and get a good understanding of the basic principles. SharePoint is NOT a "Next - Next - Finish" installation. It DOES require planning in advance, before you even start any wizards. If you hop on web sites and forums while you are running the wizards, expecting the perfect solution for your environment, brace yourself for unpleasant surprises later on.

regards, teylyn
0
 
LVL 37

Expert Comment

by:Neil Russell
ID: 36549160
"Do I need to select install server farm when I am installing sharepoint if I want to install the database on a differnt server?"

As has been said, if your asking a question like that, your not really ready to be installing and running a sharepoint farm.
I would sugguest you do lots of reading before playing with the software even in a lab.
0
 
LVL 1

Author Comment

by:Contigo1
ID: 36550291
I've requested that this question be deleted for the following reason:

I was advised to read up on sharepoint which I am now doing therefore this question is no longer needed
0
 
LVL 37

Expert Comment

by:Neil Russell
ID: 36550292
The question asked has been answered PLUS additional advice. Just because you have been advised that you need to go off and do more research before continuing and you accept that, does not mean that the question should be deleted. It was answered fully.
0

Featured Post

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Pimping Sharepoint 2007 without Server-Side Code Part 1 One of my biggest frustrations with Sharepoint 2007 in the corporate world is that while good-intentioned managers lock down the more interesting capabilities of Sharepoint programming in…
The vision: A MegaMenu for a SharePoint portal home page The mission: Make it easy to maintain. Allow rich content and sub headers as well as standard links. Factor in frequent changes without involving developers or a lengthy Dev/Test/Prod rel…
Windows 10 is mostly good. However the one thing that annoys me is how many clicks you have to do to dial a VPN connection. You have to go to settings from the start menu, (2 clicks), Network and Internet (1 click), Click VPN (another click) then fi…
Video by: Mark
This lesson goes over how to construct ordered and unordered lists and how to create hyperlinks.

911 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

15 Experts available now in Live!

Get 1:1 Help Now