SBS 2011 Sharepoint Databases Moved to Premium Edition SQL Instance Login Error

Written by James McDonald

April 10, 2013

Installed the SBS 2011 Premium Add-On (which is another copy of Windows 2008 R2 Server with SQL 2008 R2 on it) and moved all Sharepoint Foundation 2010 databases from the SBS 2011 server to the new SQL server.

In the SBS 2011 Application Event Log I kept getting an error message saying as below. The logs seem to happen at 2 minutes and 30 minutes past the hour so I’m assuming it’s a Sharepoint Timer function generating the error.

The fix (I think) was to add the DOMAIN\SBS-SERVER-01$ account to the security public / sysadmin security role in “SQL Management Studio” on the server I moved the databases to.

You open the SQL instance in “SQL Management Studio” Navigate down to Security => Logins and add DOMAIN\SBS-SERVER-01$ as a login to SQL Server. I don’t think you can browse to this account and do a “Check Names” on it but you just have to type it in.

My logs are now silent of this error:

Log Name:      Application
Source:        Microsoft-SharePoint Products-SharePoint Foundation
Date:          9/04/2013 8:02:09 AM
Event ID:      3351
Task Category: Database
Level:         Critical
User:          SYSTEM
Computer:      SBS-SERVER-01.domain.local
SQL database login for 'SharePoint_ConfigurationDatabase' on instance 'SBS-SERVER-01\SHAREPOINT' failed. Additional error information from SQL Server is included below.

Login failed for user 'DOMAIN\SBS-SERVER-01$'.
Event Xml:
<Event xmlns="">
    <Provider Name="Microsoft-SharePoint Products-SharePoint Foundation" Guid="{6FB7E0CD-52E7-47DD-997A-241563931FC2}" />
    <TimeCreated SystemTime="2013-04-08T22:02:09.755328400Z" />
    <Correlation />
    <Execution ProcessID="15148" ThreadID="12400" />
    <Security UserID="S-1-5-18" />
    <Data Name="string0">SharePoint_ConfigurationDatabase</Data>
    <Data Name="string1">SBS-SERVER-01\SHAREPOINT</Data>
    <Data Name="string2">Login failed for user 'DOMAIN\SBS-SERVER-01$'.</Data>


Submit a Comment

Your email address will not be published. Required fields are marked *

This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

The reCAPTCHA verification period has expired. Please reload the page.

You May Also Like…

Network speed test host to host

On Ubuntu / Debian apt-get install iperf3 On Windows download it from Make...

Clear HSTS Settings in CHrome

Open chrome://net-internals/#hsts enter the domain in the query field and click Query to confirm it has HSTS settings...