Solved

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

Posted on 2011-09-16
10
261 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:teylyn
teylyn 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:teylyn
ID: 36549066
If you don't plan this properly, you're setting yourself up for failure.

Good luck.
0
How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

 
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:teylyn
teylyn 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

Free Trending Threat Insights Every Day

Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

Join & Write a Comment

SharePoint Designer 2010 has tools and commands to do everything that can be done with web parts in the browser, and then some – except uploading a web part straight into a page that is edited in SPD. So, can it be done? Scenario For a recent pr…
These days socially coordinated efforts have turned into a critical requirement for enterprises.
In this seventh video of the Xpdf series, we discuss and demonstrate the PDFfonts utility, which lists all the fonts used in a PDF file. It does this via a command line interface, making it suitable for use in programs, scripts, batch files — any pl…
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

757 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

18 Experts available now in Live!

Get 1:1 Help Now