What is the correct form for SharePoint installation parameters?

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 :)


MickMorgAsked:
Who is Participating?
 
bradgcozaConnect With a Mentor Commented:
Hi,

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.
0
 
guveraCommented:
Hi Mick,

 Please check the below msdn link.

http://technet.microsoft.com/en-us/library/cc262243.aspx

Hope it may helpful to you.

Regards
Guvera
0
 
MickMorgAuthor Commented:
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?
0
 
bradgcozaCommented:
Hi,

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

Regards
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.