Tell me more ×
SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. It's 100% free, no registration required.
up vote 1 down vote favorite

I wish to install SharePoint 2010 standard server but to "show" it the location of an existing SQL server, rather than have the prerquisites installation install its own sql version on the same machine as the SharePoint server's.

The problem is when I run the prerequisites installation it tries to install SQL server automatically without giving me the option to select an exisitng server.

So, to make the question simple - how do I install SP server and SQL server on separate machines?

share|improve this question

1 Answer

up vote 4 down vote accepted

It's not the prerequisites installation which selects sql, but the SharePoint installation.

To run on a real Sql Server select Server Farm and then Complete, NOT Standalone or Stand-alone:

enter image description here
enter image description here

When you then run the Configuration Wizard you are prompted to select the SQL server:
enter image description here

Images taken from How to Install SharePoint 2010 on Small Farm – Part 1: Full Installation on Small Farm up to Managing Service Applications

share|improve this answer
OK. Worked just like said. I only wonder about this - why should the prerequisites installaton install the express SQL version automatically when there's a chance I would like to create a farm with a separate SQL server? – user7424 May 7 '12 at 11:46
There should be no Sql Express in prereqs, there is a couple of SQL libraries, but that's all. – Per Jakobsen May 7 '12 at 12:13
You can see even in the guide you linked to that the preparation tool installs microsoft SQL server 2008 native client. – user7424 May 8 '12 at 5:44
1  
SQL Server 2008 native client is a client library for accessing a SQL Server it's not the SQL server. See here – Per Jakobsen May 8 '12 at 6:44
I see. OK, Thanks. – user7424 May 8 '12 at 11:55

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.