| TERMS |
|
This document and what comes with it are
provided as-is with blunt warning: Use at your own risk,
buyer beware. You break your system; you own the resolution
as well. We have no liability for what you do, or can't
do, or fail to do with this information. Your entire protection
is to start over again with a protected backup, or from
protected system. If you don't want to accept this idea,
please don't use this document.
|
- Open SQL Server Management Studio. Click Start, point to All Programs, point to Microsoft SQL Server 2005 and then click SQL Server Management Studio.
- On the Connect to Server page (Figure 1), ensure that Server type: is set to Database Engine and that Server name: is set to ServerName\SHAREPOINT, where ServerName is the name of your server. Click Connect.
Figure 1 - Connect to the Sharepoint instance
- In the Object Explorer pane (Figure 2), expand ServerName\SHAREPOINT (SQL Server 9.0.1399 - DomainName\administrator), where DomainName is the name of your Windows SBS domain.
Figure 2 - Expand the instance.
- Double-click Security, right-click Logins, and then click New Login (Figure 3).
Figure 3 - Add a new login.
- In Login name (Figure 4), type NT Authority\Network Service, and then click OK.
Figure 4 - Add the new login name 'NT Authority\Network Service'.
- Repeat steps 4 and 5 to add the DomainName\SBS SP Admins group as a new login (Figure 5).
Figure 5 - Add the SBS Sharepoint Admins.
- In the Object Explorer pane (Figure 6), expand Logins, and then double-click the NT Authority\Network Service account.
Figure 6 - Double click the NT Authority\Network Service account.
- On the Login Properties page (Figure 7) for NT Authority\Network Service, under Select a page, click Server Roles.
Figure 7 - Login Properties.
- Under Server roles (Figure 8), select the dbcreator and securityadmin roles. Click OK.
Figure 8 - Set roles for NT Authority\Network Service.
- Keep Microsoft SQL Server Management Studio open for the next procedure.
|