January 11, 2012 at 6:13 am
Running Sharepoint 2010 with a sql server 2005 backend (Application Server and Database Server on different Servers)
On the Application Server - started getting these errors:
SQL database login for 'SharePoint_Config' on instance 'SQLServer\SHAREPOINT' failed. Additional error information from SQL Server is included below.
login failed for user 'DOMAIN\applicationserver$'.
Seeing these login failures on Database Server:
Login failed for user 'DOMAIN\applicationserver$'. [CLIENT: xxx.xx.x.xxx]
I'm not an NT or AD guru (I'm the DBA) but I believe that the '$' after the login that is trying to connect to the Database means that this is the 'machine' account on the application server trying to connect to the Sharepoint_config Database.
Need some guidance on this one. I have these login failures happening on my SQL Server ever few minutes Thank you!
January 13, 2012 at 1:19 am
Do you get any more information if you use the Login Failures trace template in Profiler?
The main thing that should give you is the process ID on the App server of where the request is coming from. Hopefully that can help you narrow down what is causing the failures.
Bodsda
January 13, 2012 at 5:56 am
The account with <domain>\<machine>$ is a computer account. You should be able to add that account as a user to the db if need be. Is it causing anything to break on the SharePoint side? What does the configuration documentation for SharePoint suggest?
Joie Andrew
"Since 1982"
January 13, 2012 at 6:37 am
Joie Andrew (1/13/2012)
The account with <domain>\<machine>$ is a computer account. You should be able to add that account as a user to the db if need be. Is it causing anything to break on the SharePoint side? What does the configuration documentation for SharePoint suggest?
The configuration documentation for Sharepoint does not say anything about giving the Application Server's local machine account permissions to the Database... that MIGHT fix it but is probably bad practice.
The Sharepoint Admins finally found a bad module or something in Sharepoint - I'm not sure of the Sharepoint terminology - and reinstalled that 'module' and the login errors stopped.
Thanks all for your help
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply