Error message when you specify configuration database settings on the Set Configuration Database Server page in SharePoint Administration: "Error 18456"

Article translations Article translations
Article ID: 889646 - View products that this article applies to.
Expand all | Collapse all

Symptoms

Consider the following scenario:
  • You install Microsoft Windows SharePoint Services (WSS).
  • You configure WSS settings in SharePoint Central Administration.
  • You specify configuration database settings on the Set Configuration Database Server page.
In this scenario, you may receive an error message that resembles one of the following:

Login failed for user 'DOMAINNAME\ACCOUNTNAME'. (Error code: 18456)

Login failed for user 'NT AUTHORITY\NETWORK SERVICE'. (Error code: 18456)

Cause

This issue occurs if all the following conditions are true:
  • The account that the WSS application pool is running under is not a member of the Database Creators role in Microsoft SQL Server.
  • The account that the WSS application pool is running under is not a member of the Security Administrators role in Microsoft SQL Server.

Resolution

To resolve this issue, add the account that the WSS application pool is running under to the Database Creator role and the Security Administrators role in SQL Server. To do this, follow these steps:
  1. Add the account that the application pool is running as to the Security Administrators role and to the Database Creators role in SQL Server. To do this:
    1. Start SQL Server Enterprise Manager.
    2. Expand Microsoft SQL Servers, expand the server group, expand the appropriate server, and then expand Security.
    3. Right-click Logins, and then click New Login.
    4. Type the account name in the Name box. Use the following format for the account name:
      DomainName\AccountName
      Note If SQL Server is installed on a separate computer and you want to run the application pool as the Network Service account, the computer that is running Windows SharePoint Services must have permissions to access the remote computer that is running SQL Server. On the remote computer that is running SQL Server, add the DomainName\ServerName$ account to the Database Creators role and to the Security Administrators role.
    5. Click the Server Roles tab.
    6. In the Server Role list, click to select the Security Administrators check box, and then click to select the Database Creators check box. Click OK.
    7. Quit SQL Server Enterprise Manager.
  2. On the Configure Administrative Virtual Server page of SharePoint Central Administration, create a new application pool, specify the account as the application pool account, and then click OK. The Application Pool Changed page is displayed.
  3. Restart Microsoft Internet Information Services (IIS). To do this, click Start, click Run, type iisreset in the Open box, and then click OK.
  4. On the Application Pool Changed page, click OK. On the Set Configuration Database Server page of SharePoint Central Administration, specify the configuration database settings.

More information

For additional information about how to install, to configure, and to administer Windows SharePoint Services 2.0, visit the following Microsoft Web site:
http://www.microsoft.com/downloads/details.aspx?FamilyID=a637eff6-8224-4b19-a6a4-3e33fa13d230&displaylang=en

Properties

Article ID: 889646 - Last Review: July 12, 2013 - Revision: 4.1
Applies to
  • Microsoft Windows SharePoint Services 3.0
  • Microsoft Windows SharePoint Services 2.0
Keywords: 
kbsetup kberrmsg kbprb kbtshoot KB889646

Give Feedback

 

Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from smallbusiness.support.microsoft.com