What is the correct form for SharePoint installation parameters?

Posted on 2011-04-25
Last Modified: 2012-05-11
What form should I use for the database server name and user name (credentials for farm user account) parameters, when installing SharePoint 2010 (a scripted installation)?

Is it correct that if I have a named instance of SQL I should have the form "serverName\instanceName" for the database server name?  Should I use this form regardless of named/default instance? Maybe the difference is if I use SQL full version or SQL Express when naming this parameter?

If I choosed the default instance (MSSQLSERVER), when installing SQL, isn´t that also a named instance?
I know I should use a named instance if I want to use SQL for other applications besides SharePoint. So then the default instance isn´t a named instance after all? Confusing...

Servername refers to the computername doesn´t it?

What about the user name?

If you have any other remarks on the form for naming the SharePoint installation parameters, please inform me :)

Question by:MickMorg
    LVL 7

    Accepted Solution


    If you type in the servername for your SharePoint farm it will install all databases on the default SQL instance. MSSQLSERVER

    However if you have created another SQL instance that you prefer to use then you need to add this infront of the server name of the SQL Server.  Servername\SPSInstance

    The username should be a service domian account that you have created in Active Directory that has DBCreator and DBSecurityAdmin on the SQL instance you wish to install SPS on.
    LVL 8

    Expert Comment

    Hi Mick,

     Please check the below msdn link.

    Hope it may helpful to you.


    Author Comment

    bradgcoza; Thank you for the answers - exactly what I was looking for :)

    When I installed SQL Server 2008, I used the same credential for all services/accounts, the same one I have for Windows Server - an administrator user account. That account should work for SharePoint user credentials then?
    LVL 7

    Expert Comment


    The account will work but I would strongly recommened making a new account for the SharePoint Farm account and giving it the above mentioned permissions in SQL


    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Threat Intelligence Starter Resources

    Integrating threat intelligence can be challenging, and not all companies are ready. These resources can help you build awareness and prepare for defense.

    If you have heard of RFC822 date formats, they can be quite a challenge in SQL Server. RFC822 is an Internet standard format for email message headers, including all dates within those headers. The RFC822 protocols are available in detail at:   ht…
    Occasionally there is a need to clean table columns, especially if you have inherited legacy data. There are obviously many ways to accomplish that, including elaborate UPDATE queries with anywhere from one to numerous REPLACE functions (even within…
    how to add IIS SMTP to handle application/Scanner relays into office 365.
    Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…

    737 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

    18 Experts available now in Live!

    Get 1:1 Help Now