Hello, I'm a 1st time installer of sharepoint. can anyone tell me what happens if i install SQL server 2012 Express Using my domain admin account without using special SQL Login?
Regards,
Ashane Desha
Technology Tips and News
Hello, I'm a 1st time installer of sharepoint. can anyone tell me what happens if i install SQL server 2012 Express Using my domain admin account without using special SQL Login?
Regards,
Ashane Desha
You will be hated by all SQL admins everywhere.
SQL server should be installed with, depending on what you're doing, at least two AD domain user accounts. One to run the SQL Service (the bit that does the data management) and another to run the Agent (the bit that keeps the data sorted, organised and does other admin tasks.
The account you use to install SQL can be your domain admin account (ignoring the bad points of using a Domain admin account in the first place) but you should give SQL some service accounts to use during the installation process.
You don't need to use SQL authentication, or 'mixed mode' authentication. SharePoint is happiest with windows authentication only.
This article should get you to a decent staring point: http://social.technet.microsoft.com/wiki/contents/articles/8557.sharepoint-2010-install-sql-server-2012-for-sharepoint.aspx
Thanks for replying me. That mean i have to create a AD user for SQL installation and now i need to know can i install Sharepoint 2013 with SQL 2012 Express?
Regards.
Yes you can. It has size limits (10GB of content max) but it's possible to do so.