123ArticleOnline Logo
Welcome to 123ArticleOnline.com!
ALL >> Computers >> View Article

Dealing With “error 18456” In Ms Sql Server

Profile Picture
By Author: Company Article
Total Articles: 60
Comment this article
Facebook ShareTwitter ShareGoogle+ ShareTwitter Share

Error number 18456 is quite common in MS SQL Server and it comes up whenever there is some problem with installation of MS SharePoint services. This error crops up in the following scenario:
You install MS Windows SharePoint Services and as soon the Setup program is completed successfully, you configure Windows SharePoint Services settings in SharePoint Central Administration. You specify configuration database settings on the Set Configuration Database Server page of SharePoint Central Administration, and then you click OK. Now on clicking OK you get one of the following error messages.
Login failed for user 'DOMAINNAME\ACCOUNTNAME'. (Error code: 18456)
Login failed for user 'NT AUTHORITY\NETWORK SERVICE'. (Error code: 18456)
Reason behind this error
The application pool runs as a certain account. If that account does not have database creation rights in Microsoft SQL Server, this issue may occur. To be more specific, this issue occurs if the account is not a member of the Security Administrators role or of the Database Creators role.
Resolution
To resolve this issue, you must add an ...
... account to the Database Creators role and to the Security Administrators role in SQL Server. To do that you need to follow the given below steps:
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.
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.
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.
Restart Microsoft Internet Information Services (IIS). To do this, click Start, click Run, type iisreset in the Open box, and then click OK.
On the Application Pool Changed page, click OK. On the Set Configuration Database Server page of SharePoint Central Administration, specify the configuration database settings.
After this you would not be facing this 18456 error anymore. If you are unable to access SQL server database files due to corruption issues, then you can repair them using SQL recovery software. Its efficient SQL database recovery software for MS SQL Server database files (.MDF) and performs MS SQL recovery in no matter of time.

http://www.mssqlrepair.com/

Author of the article has expertise in the field of data recovery software, email recovery, email migration, hard drive recovery and password recovery. The entire range of his articles is information-rich and useful for dealing with data recovery issues and finding suitable solution. See More........ MS SQL repair

Total Views: 236Word Count: 473See All articles From Author

Add Comment

Computers Articles

1. Devopsin Hallinnoimat Palvelut: Tietoturva Ja Tiedon Hallinta
Author: harju

2. Hyödynnä Pilvesi Täysi Potentiaali Google Cloud Monitoring Solutions -ratkaisuilla
Author: harju

3. Pysy Kyberuhkien Edellä Google Cloud Security Services -palvelun Avulla
Author: harju

4. Mullista Yrityksesi Nopeilla Ja Turvallisilla Googlen Pilvipalveluratkaisuilla
Author: harju

5. Googlen Pilvi-identiteetin Hallintapalvelut Pienille Ja Keskisuurille Yrityksille
Author: harju

6. Google Cloud -konsultointi: Tukea, Strategiaa Ja Kehitystä Yrityksellesi
Author: harju

7. Iot Edge -laskentapalvelut Ja Ai – Älykkään Datankäsittelyn Tulevaisuus
Author: harju

8. Älykäs Reunalaskenta: Tehokkuutta Ja Kilpailuetua Yrityksellesi
Author: harju

9. Cloud Change -palvelut – Tulevaisuuden It-ratkaisu Liiketoiminnallesi
Author: harju

10. Aws-tietokannan Siirtopalvelu Ja Hybridiympäristöt – Miten Ne Toimivat Yhdessä?
Author: harju

11. What Makes Google Ads Management Services Better Than Other Digital Marketing Campaigns?
Author: Digital Agency

12. Things You Should Know About Nema And International Plug Adapters
Author: Jennifer Truong

13. The Best 8 Tools For Data Analysis
Author: goodcoders

14. Top 5 Customer Experience Management Problems And Solution
Author: goodcoders

15. How To Create A Framework-agnostic Application In Php?
Author: goodcoders

Login To Account
Login Email:
Password:
Forgot Password?
New User?
Sign Up Newsletter
Email Address: