Microsoft Office Tutorials and References
In Depth Information
While you’re creating the setup account as a login role, you can add it to the necessary server
roles. To do this, select Server Roles on the Select A Page pane on the left side of the New Logins
7 . Check DBCreator and SecurityAdmin in the Server Roles list (Public is selected by default for a
login role for SQL 2008), and click OK. That should take you back to the SQL Server Management
Studio console. Your setup account should be a Logins account, and the setup account should
be added to the SQL Logins, DBCreator, and SecurityAdmin roles.
Although the remote connections setting is usually enabled by default with SQL 2008 and higher,
to verify that your SQL server is prepared for remote access from the SharePoint server, right-click
the server instance in the Object Explorer pane, and go to Properties in the pop-up menu.
In the dialog box, select Connections from the Select A Page column. On the right, make certain
the Allow Remote Connections To This Server box is checked. Click Cancel to close the dialog box
if it is already checked; if not, select it, and click OK.