Solved

Sharepoint standalone installation

Posted on 2014-07-26
12
774 Views
Last Modified: 2014-08-06
I am using a computer where I am installing SharePoint Foundation 2010 for my trail use.
I am trying to install SharePoint in Stand Alone mode. Creating New farm, new database everything.
Now,

On a fresh Windows Server 2008 R2 I have domain and AD installed.
Below are information about machine:
Computer name: portal
Full Computer nameL portal.mgm.edu
Domain :  mgm.edu
I installed SharePoint Foundation 2010. Then I had to use : SharePoint product configuration wizard,
Then it asked me :
Connect to Server Farm:
  - Connect to existing server Farm
 - Create a new server farm  (I chose this one)

Now it gave Specify Configuration database settings:
Please note I have not setup SQL server 2008 in advance I am assuming that after I provide information on below page system will install SQL Express for me.
Please tell me what should I put under:
Database server: ????    (what should be value in this place?)
Database Name: sharepoint_config
Database Access account:
Username: mgm.edu\administrator   (mgm.edu is my domain and ADMINISTRATOR has permissions as local and domain admin)
Password : ******

For database server name I also tried these options:
.\localhost    , portal\localhost,    mgm.edu\localhost ,   portal  ,   portal.mgm.edu
but all gives same error as above because of which I am not able to go to next page in installation.

Please also see attached document for more reference.
SharePoint-2010-Stanalone-Installation-C
0
Comment
Question by:Avinash Badgujar
[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
  • 2
  • +1
12 Comments
 
LVL 18

Expert Comment

by:Walter Curtis
ID: 40221760
Use the computer name (host name) and the sql instance, use this "portal\sqlexpress". Depending upon what version you have, your may need to use "portal\sharepoint".

To get the exact sql instance, you will have a start menu item named "SQL Configuration". There it will show the instance name. If you go to the SQL Configuration program, make sure TCP/IP as a network protocol in enabled.

Hope that helps
0
 
LVL 58

Assisted Solution

by:Cliff Galiher
Cliff Galiher earned 250 total points
ID: 40221812
The sharepoint configuration wizard will not install SQL. When you first installed sharepoint (before the config wizard) you are given an option to install SQL at that time. If you didn't take that path, you'll have to reinstall or install and configure SQL manually.
0
 
LVL 25

Assisted Solution

by:Mohammed Khawaja
Mohammed Khawaja earned 250 total points
ID: 40221892
SharePoint does not install SQL.  Please install SQL server (doesn't matter which edition you install as it is version 2008 or higher).
0
Edgartown IT Case Study

Learn about Edgartown's quest to ensure the safety and security of the entire town's employee and citizen data. Read the case study!

 
LVL 58

Expert Comment

by:Cliff Galiher
ID: 40221895
Foundation 2010 will install SQL express if (and only if) you choose the option to use the built-in database during the initial setup. Which is way before the configuration wizard.
0
 

Assisted Solution

by:Avinash Badgujar
Avinash Badgujar earned 0 total points
ID: 40222398
And finally from this link: http://technet.microsoft.com/en-us/library/cc263202%28v=office.14%29.aspx I came to know that "You cannot install the single server with built-in database version of SharePoint Server on a domain controller."

So I think I have to install SQL separately. And then install SharePoint.
0
 

Accepted Solution

by:
Avinash Badgujar earned 0 total points
ID: 40225406
So here is finally how I completed the project:
You cannot install the Standalone / single server with built-in database version of SharePoint Server on a domain controller. So you have to separately install SQL server.
-      Installed and Updated Win Server 2008 R2
-      Installed AD
-      Installed SharePoint Server 2010
-      Installed SQL Server 2008 R2  (as I didn’t had any expertise I didn’t created any database or anything here. Just plain SQL server installation is needed)
[Alternatively SharePoint can be installed after SQL Server installation)
-      Then Run SharePoint Product Configuration Wizard
-      
Now here is my answer to own question I asked:
As we are installing/configuring SharePoint on same server where our SQL server is – so we can use ‘Localhost’ as our database server. SharePoint takes Database name as: ‘SharePoint_Config’ lets keep it as it is.
SharePoint SQL database Settings
Now we can configure further server which is fairly easy:
SharePoint SQL database Settings 2Further help can be provided by this article: http://technet.microsoft.com/en-us/library/cc262243%28v=office.14%29.aspx
Thus we can complete the installation.
0
 

Author Comment

by:Avinash Badgujar
ID: 40225754
I've requested that this question be closed as follows:

Accepted answer: 0 points for Avinash Badgujar's comment #a40225406

for the following reason:

This gives complete answer
0
 
LVL 18

Expert Comment

by:Walter Curtis
ID: 40225449
People took their time to answer this question. It is not fail to not reward any points. My answer correctly answered the specific questions. All other information after initial question was mainly by the requester. If he did not want or need help he should not have asked the questions and used our time for nothing.
0
 
LVL 58

Expert Comment

by:Cliff Galiher
ID: 40225755
Several experts said that the expectation that the configuration wizard would install SQL was wrong and that SQL would have to be installed manually. For the poster to accept his own answer which was a mirror (with screenshots) of information already given is indeed I appropriate. The question asker clearly did NOT have the answer before experts pointed him/her in the right direction.
0
 

Author Closing Comment

by:Avinash Badgujar
ID: 40243234
Dear Sir,

I am new to expert-exchange. So initially i closed this request but now I have distributed 250 points each to answers that led me to find right solution on my own.
Thank you all for your help.
Avinash
0

Featured Post

Comparison of Amazon Drive, Google Drive, OneDrive

What is Best for Backup: Amazon Drive, Google Drive or MS OneDrive? In this free whitepaper we look at their performance, pricing, and platform availability to help you decide which cloud drive is right for your situation. Download and read the results of our testing for free!

Question has a verified solution.

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

Background Information Recently I have fixed file server permission issues for one of my client. The client has 1800 users and one Windows Server 2008 R2 domain joined file server with 12 TB of data, 250+ shared folders and the folder structure i…
A recent project that involved parsing Tableau Desktop and Server log files to extract reusable user queries for use in other systems. I chose to use PowerShell to gather the data, and SharePoint to present it...
This tutorial will give a short introduction and overview of Backup Exec 2012 and how to navigate and perform basic functions. Click on the Backup Exec button in the upper left corner. From here, are global settings for the application such as conne…
This tutorial will show how to configure a new Backup Exec 2012 server and move an existing database to that server with the use of the BEUtility. Install Backup Exec 2012 on the new server and apply all of the latest hotfixes and service packs. The…

728 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