Sharepoint standalone installation

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
Avinash BadgujarSharePoint AdministratorAsked:
Who is Participating?
 
Avinash BadgujarConnect With a Mentor SharePoint AdministratorAuthor Commented:
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
 
Walter CurtisSharePoint AEDCommented:
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
 
Cliff GaliherConnect With a Mentor Commented:
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
Simplify Active Directory Administration

Administration of Active Directory does not have to be hard.  Too often what should be a simple task is made more difficult than it needs to be.The solution?  Hyena from SystemTools Software.  With ease-of-use as well as powerful importing and bulk updating capabilities.

 
Mohammed KhawajaConnect With a Mentor Manager - Infrastructure:  Information TechnologyCommented:
SharePoint does not install SQL.  Please install SQL server (doesn't matter which edition you install as it is version 2008 or higher).
0
 
Cliff GaliherCommented:
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
 
Avinash BadgujarConnect With a Mentor SharePoint AdministratorAuthor Commented:
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
 
Avinash BadgujarSharePoint AdministratorAuthor Commented:
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
 
Walter CurtisSharePoint AEDCommented:
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
 
Cliff GaliherCommented:
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
 
Avinash BadgujarSharePoint AdministratorAuthor Commented:
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.