Solved

Sharepoint standalone installation

Posted on 2014-07-26
12
726 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
  • 4
  • 3
  • 2
  • +1
12 Comments
 
LVL 14

Expert Comment

by:SneekCo
Comment Utility
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 56

Assisted Solution

by:Cliff Galiher
Cliff Galiher earned 250 total points
Comment Utility
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 24

Assisted Solution

by:Mohammed Khawaja
Mohammed Khawaja earned 250 total points
Comment Utility
SharePoint does not install SQL.  Please install SQL server (doesn't matter which edition you install as it is version 2008 or higher).
0
 
LVL 56

Expert Comment

by:Cliff Galiher
Comment Utility
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
Comment Utility
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
How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

 

Accepted Solution

by:
Avinash Badgujar earned 0 total points
Comment Utility
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
Comment Utility
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 14

Expert Comment

by:SneekCo
Comment Utility
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 56

Expert Comment

by:Cliff Galiher
Comment Utility
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
Comment Utility
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

IT, Stop Being Called Into Every Meeting

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

Join & Write a Comment

In this article I will describe the Copy Database Wizard method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
Possible fixes for Windows 7 and Windows Server 2008 updating problem. Solutions mentioned are from Microsoft themselves. I started a case with them from our Microsoft Silver Partner option to open a case and get direct support from Microsoft. If s…
This tutorial will show how to push an installation of Backup Exec to an additional server in both 2012 and 2014 versions of the software. Click on the Backup Exec button in the upper left corner. From here, select Installation and Licensing, then I…
This tutorial will walk an individual through locating and launching the BEUtility application and how to execute it on the appropriate database. Log onto the server running the Backup Exec database. In a larger environment, this would generally be …

772 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

10 Experts available now in Live!

Get 1:1 Help Now