I installed SharePoint server 2010 recently on a test server. It was installed in
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