Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

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

Posted on 2011-09-16
10
Medium Priority
?
270 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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
Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

 
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

Visualize your virtual and backup environments

Create well-organized and polished visualizations of your virtual and backup environments when planning VMware vSphere, Microsoft Hyper-V or Veeam deployments. It helps you to gain better visibility and valuable business insights.

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…
Microsoft SharePoint Foundation 2010 and Microsoft SharePoint Server 2010 do not offer the option to configure the location of the SharePoint diagnostic trace log files during installation.  This can, however, be configured through Central Administr…
Video by: ITPro.TV
In this episode Don builds upon the troubleshooting techniques by demonstrating how to properly monitor a vSphere deployment to detect problems before they occur. He begins the show using tools found within the vSphere suite as ends the show demonst…
Loops Section Overview

610 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