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.

You May Also Like…


Zebra Printer Language The above website has a page where you can enter ZPL and it...

PHP Iterators

Just came across a Youtube talk "Iterators in PHP" by Jake Smith published in 2014 that steps through the many...

PHP array_map Multiple Arrays

array_map can take multiple arrays. I like how it starts mapping through them starting at the first element of each...