asked on 1/3/2013

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.

Microsoft SharePoint SBS Microsoft SQL Server 2008

Last Comment

steven_theck

1/4/2013

ASKER CERTIFIED SOLUTION

QPR

1/3/2013

THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.

View this solution by signing up for a free trial.

Members can start a 7-Day free trial and enjoy unlimited access to the platform.

See Pricing Options

Start Free Trial

steven_theck

1/3/2013

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

1/4/2013

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

1/4/2013

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!