I installed SharePoint server 2010 recently on a test server. It was installed in standalone mode
.
After the installation, I realized that it had installed SQL Server Express 2008
(10.0.2531.0
) automatically as well.
I need to know the password for the sa
user of this SQL server instance that it automatically installed. (I was not prompted for a password during the SharePoint installation)
Reason that I need the sa password of the SharePoint SQL instance:
SharePoint is working without any issues. However, I need to create a new login on the SQL server and give it permissions to some of the databases.
I can login to the SQL server using Windows Authentication. However, using this login, I do not have permissions to create a new login.
I need to create a new login in order to complete the steps mentioned here: http://www.sharepointassist.com/2010/01/29/the-local-farm-is-not-accessible-cmdlets-with-featuredependencyid-are-not-registered/comment-page-1/#comment-1566
sa
login appears to be disabled. However, it does not allow me to enable it when logged in with the Windows account that I used while installing SharePoint.