Solved

Error code: 18456 SQL Sharepoint Issue

Posted on 2006-07-05
4
539 Views
Last Modified: 2008-01-09
I want to set up Sharepoint services on one 2003 R2 server named "PCTDC2" and use the SQL 2005 server "SC". When I am going through the setup of Sharepoint on "PCTDC2" I receive the following error:

Login failed for user 'PCTECHCORP\PCTDC2$'. (Error code: 18456).

I have chosen Windows Authentication and set the application pool to be a network service. One thing that I would like to note is that "PCTECHCORP\PCTDC2" is a computer, not a user account.

Thank you.
0
Comment
Question by:pctechcorp
  • 2
4 Comments
 
LVL 142

Expert Comment

by:Guy Hengel [angelIII / a3]
ID: 17045499
did you create a login in the sql server "security->logins" folder for that account?
0
 
LVL 25

Expert Comment

by:dstanley9
ID: 17045552
Apps running as Network Service use the computer account for authentication to other servers.  You can either give the computer account access or run as a domain account that has access.
0
 

Author Comment

by:pctechcorp
ID: 17045623
I am not able to add a login for the "PCTDC2" account because it is not a user account, but a computer account. In the "security->logins" I am only able to add a User, Group, or builtin security principles.
0
 
LVL 25

Accepted Solution

by:
dstanley9 earned 500 total points
ID: 17045806
You have to type it in manually - you won't be able to "browse" it.  Enter in the domain in the domain drop-down and the computer name followed by $ in the name box.
0

Featured Post

Optimizing Cloud Backup for Low Bandwidth

With cloud storage prices going down a growing number of SMBs start to use it for backup storage. Unfortunately, business data volume rarely fits the average Internet speed. This article provides an overview of main Internet speed challenges and reveals backup best practices.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

When you hear the word proxy, you may become apprehensive. This article will help you to understand Proxy and when it is useful. Let's talk Proxy for SQL Server. (Not in terms of Internet access.) Typically, you'll run into this type of problem w…
Let's review the features of new SQL Server 2012 (Denali CTP3). It listed as below: PERCENT_RANK(): PERCENT_RANK() function will returns the percentage value of rank of the values among its group. PERCENT_RANK() function value always in be…
Using examples as well as descriptions, and references to Books Online, show the documentation available for datatypes, explain the available data types and show how data can be passed into and out of variables.
Viewers will learn how the fundamental information of how to create a table.

910 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

24 Experts available now in Live!

Get 1:1 Help Now