SharePoint - 'Login failed for user 'DOMAIN\username'.'

I am getting the following errors in SQL 2008 related to a SharePoint 2008 site:

SqlError: 'Login failed for user 'DOMAIN\username'.'    Source: '.Net SqlClient Data Provider' Number: 18456 State: 1 Class: 14 Procedure: '' LineNumber: 1 Server: 'np:\\.\pipe\MSSQL$Microsoft##SSEE\sql\query'
 

&

Event 18456 - The description for Event ID ( 18456 ) in Source ( MSSQL$MICROSOFT##SSEE ) cannot be found. The local computer may not have the necessary registry information or message DLL files to display messages from a remote computer. You may be able to use the /AUXSOURCE= flag to retrieve this description; see Help and Support for details. The following information is part of the event: DOMAIN\username,  [CLIENT: <named pipe>].

The user keeps changing to others in my domain.  Searching the internet has proved very fruitless.  I hope someone can help me.

Thanks,

Micheal C

Hello Mike,

If you went to the doctor with leg pain they would ask you "When did this pain start occurring?" and you might say ,"Last week and it got progressively worse" or "When the tree fell on it an hour ago." The treatment and diagnosis for the two answers are immensely different. This is no different in the technology world except for the fact we aren't face to face so always bring that to the table when asking a question.

Was this working already and started cropping up today? or are you trying for the first time to give users access to ad-hoc queries via sharepoint for the first time?

It looks like your sharepoint server is trying to connect to your sql server via named pipes. It doesn't look like an issue (yet) with the connection through named pipes but the user trying to access the sharepoint item.

Have you given users datareader access to the database? Do you really want to?

Many times administrators will write a query and have a fixed sql or domain user connect and run the query and the output generates a report that appears on the sharepoint that is a snapshot of data on an interval.

Please provide more information as to what you are trying to do and what is your end result expectations?

James,

Hey Michael,

I finally got notification that you responded to the thread today.

I looked at your logs and its still a user permission issue.

Most likely you've added a report or sql output to your sharepoint, however you probably set the user authentication to "Windows Authentication".

This passes the users credentials through sharepoint and validates whether the user can run the query or not.

You can:

1. Add users as datareaders to the sharepoint.
2. Set up your report/sqloutput to use a specific sql or windows user to run the query.

I would recommend you do option #2.

Create a sql account like sharepointuser and give it a specific password. You'll give it the datareader role on the database you are querying.

In your sharepoint development suite you can keep the authentication of the item to be windows authentication but in the datasource object (sql) you'll change the credentials to sharepointuser and provide the sharepointuser's password.

I'm not trying to be vague but its been a nearly a decade since I've done sharepoint administration so its most likely changed alot and I don't have a sharepoint server installed anywhere to play with.

You are welcome to email me

I'd be happy to converse on another medium and we'll post our results in the end for the benefit of the website.