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
Keywords:      
User:          SYSTEM
Computer:      SBS-SERVER-01.domain.local
Description:
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="http://schemas.microsoft.com/win/2004/08/events/event">
  <System>
    <Provider Name="Microsoft-SharePoint Products-SharePoint Foundation" Guid="{6FB7E0CD-52E7-47DD-997A-241563931FC2}" />
    <EventID>3351</EventID>
    <Version>14</Version>
    <Level>1</Level>
    <Task>3</Task>
    <Opcode>0</Opcode>
    <Keywords>0x4000000000000000</Keywords>
    <TimeCreated SystemTime="2013-04-08T22:02:09.755328400Z" />
    <EventRecordID>46901</EventRecordID>
    <Correlation />
    <Execution ProcessID="15148" ThreadID="12400" />
    <Channel>Application</Channel>
    <Computer>SBS-SERVER-01.domain.local</Computer>
    <Security UserID="S-1-5-18" />
  </System>
  <EventData>
    <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>
  </EventData>
</Event>

0 Comments

Submit a Comment

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

You May Also Like…

How to Research a CPU Upgrade

How to Research a CPU Upgrade

Upgrade Time! Doing a lot of VMWare Workstation virtualization to create labs for self-study and training. Finding...