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.