Solved

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

Posted on 2011-09-16
10
263 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
The Eight Noble Truths of Backup and Recovery

How can IT departments tackle the challenges of a Big Data world? This white paper provides a roadmap to success and helps companies ensure that all their data is safe and secure, no matter if it resides on-premise with physical or virtual machines or in the cloud.

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

Simplifying Server Workload Migrations

This use case outlines the migration challenges that organizations face and how the Acronis AnyData Engine supports physical-to-physical (P2P), physical-to-virtual (P2V), virtual to physical (V2P), and cross-virtual (V2V) migration scenarios to address these challenges.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Citrix sharefile 1 73
Convert a Master Page to HTML 16 125
Sharepoint List View 6 34
SharePoint display modal blank 2 58
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…
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…
A short tutorial showing how to set up an email signature in Outlook on the Web (previously known as OWA). For free email signatures designs, visit https://www.mail-signatures.com/articles/signature-templates/?sts=6651 If you want to manage em…

832 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