?
Solved

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

Posted on 2011-09-16
10
Medium Priority
?
272 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 (Microsoft MVP / EE MVE)
Ingeborg Hawighorst (Microsoft MVP / EE MVE) earned 1332 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 668 total points
ID: 36549013
0
VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

 
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
ID: 36549066
If you don't plan this properly, you're setting yourself up for failure.

Good luck.
0
 
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 (Microsoft MVP / EE MVE)
Ingeborg Hawighorst (Microsoft MVP / EE MVE) earned 1332 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

Hire Technology Freelancers with Gigs

Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.

Question has a verified solution.

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

When installing SharePoint 2010 RTM I came across a strange error, I was getting timeouts during the installation. I searched the web and found the best solution to be found here (http://social.msdn.microsoft.com/Forums/en-US/sharepoint2010genera…
We had a requirement to extract data from a SharePoint 2010 Customer List into a CSV file and then place the CSV file into a directory on the network so that the file could be consumed by an AS400 system. I will share in Part 1 how to Extract the Da…
this video summaries big data hadoop online training demo (http://onlineitguru.com/big-data-hadoop-online-training-placement.html) , and covers basics in big data hadoop .
This lesson discusses how to use a Mainform + Subforms in Microsoft Access to find and enter data for payments on orders. The sample data comes from a custom shop that builds and sells movable storage structures that are delivered to your property. …

569 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