asked on

SharePoint_Config Critical Error

I have a Windows SBS 2011 server, and a Windows 2008 R2 Standard server named VPSSRV01 and VPSSRV02, respectively. The SharePoint databases were initially running from the SBS server, but I migrated them over to the 2008 R2 server, as that is my dedicated SQL server. SharePoint seems to be working just fine, but I am receiving the following error every 30 minutes on the SBS server:

SQL database login for 'SharePoint_Config' on instance 'VPSSRV02' failed. Additional error information from SQL Server is included below.

Login failed for user 'DOMAIN\VPSSRV01$'.

I cannot find where I could change the user information to be 'DOMAIN\VPSSRV02' to prevent this error, nor could I figure out how to allow 'DOMAIN\VPSSRV01' to have access to the SharePoint_Config database.

ASKER CERTIFIED SOLUTION

QPR

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

steven_theck

ASKER

When trying to add a user under the security node, I cannot add a computer. My only options for object types are built-in security principals, groups, and users. Should I create a user with the same name as the server (VPSSRV01)?

QPR

You are adding a user not a computer.
When adding the user (if not listed) click locations and ensure the domain is selected rather than the local server

steven_theck

ASKER

That seems to have fixed the issue. I didn't receive the error at the 30 minute interval that I normally do. Thanks for your help!