What is the correct form for SharePoint installation parameters?

Posted on 2011-04-25
Medium Priority
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
  • 2

Accepted Solution

bradgcoza earned 2000 total points
ID: 35458790

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.

Expert Comment

ID: 35459024
Hi Mick,

 Please check the below msdn link.


Hope it may helpful to you.


Author Comment

ID: 35459034
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?

Expert Comment

ID: 35459064

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


Featured Post

NEW Veeam Backup for Microsoft Office 365 1.5

With Office 365, it’s your data and your responsibility to protect it. NEW Veeam Backup for Microsoft Office 365 eliminates the risk of losing access to your Office 365 data.

Question has a verified solution.

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

In this article we will get to know that how can we recover deleted data if it happens accidently. We really can recover deleted rows if we know the time when data is deleted by using the transaction log.
These days socially coordinated efforts have turned into a critical requirement for enterprises.
Loops Section Overview
With just a little bit of  SQL and VBA, many doors open to cool things like synchronize a list box to display data relevant to other information on a form.  If you have never written code or looked at an SQL statement before, no problem! ...  give i…

850 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