Event ID 3760 and 6398

Hi

On a new installed SBS 2011 I got these error. I have search for solution but can't find any.
Some suggestion?

Event ID 3760
SQL Database 'SharePoint_ConfigurationDatabase' on SQL Server instance 'servername\SHAREPOINT' not found. Additional error information from SQL Server is included below.

Cannot open database "SharePoint_ConfigurationDatabase" requested by the login. The login failed.
Login failed for user 'domain\spfarm'.

Event ID 6398
The Execute method of job definition Microsoft.SharePoint.Administration.SPConfigurationRefreshJobDefinition (ID aea87832-0605-471d-b8ae-b0dcb746f722) threw an exception. More information is included below.

A transport-level error has occurred when sending the request to the server. (provider: Shared Memory Provider, error: 0 - No process is on the other end of the pipe.)
OleDAsked:
Who is Participating?
 
Vitor MontalvãoMSSQL Senior EngineerCommented:
Open SQL Server Configuration Manager and check if SQL Server Browser is running. If not, start it.
0
 
Jayaraja JayaramanSharepoint Architect ConsultantCommented:
couple of things to check.
Please make sure the sql services is running.
ensure the application/identity tats making use of this sbs over sharepoint is having rights to the db.
did you try running as farm admin account ?
0
 
OleDAuthor Commented:
I need more how to.
0
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

 
Mohit NairSenior AssociateCommented:
Go to services.msc in SQL server and check the SQLSERVER instance is running. Open SQL management studio and connect to the instance \\.\pipe\mssql$microsoft##ssee\sql\query . Open Security > Login folder  and check if you have spfarm added there . If not add it and go to properties and assign dbowner permissions.
0
 
OleDAuthor Commented:
See "printscreen". It's from SQL Management Studio...... when I login servername/Sharepoint.
It's the instance where "SQL Database 'SharePoint_ConfigurationDatabase'" is.
2015-03-12-115547.jpg
0
 
OleDAuthor Commented:
The SQL Server Browser is not running and "Startup Type" is Manual.

It's looks like I only get the two errors when I start (boot) the server.
The last two times I only get Event ID 3760.

Do I have to change the startup type for SQL Browser.......?
0
 
Vitor MontalvãoMSSQL Senior EngineerCommented:
Do I have to change the startup type for SQL Browser.......?
Yes, if you want to allow connections from remote clients. Change it to automatic and start it.
0
 
OleDAuthor Commented:
I change startup type...start the service and reboot.  I got these error:

Event 3760       Task Category: Database
SQL Database 'SharePoint_ConfigurationDatabase' on SQL Server instance 'servername\SHAREPOINT' not found. Additional error information from SQL Server is included below.

Cannot open database "SharePoint_ConfigurationDatabase" requested by the login. The login failed.
Login failed for user 'SBSNETWORK\spfarm'.

and

Event 6398       Task Category: Timer
The Execute method of job definition Microsoft.SharePoint.Administration.SPConfigurationRefreshJobDefinition (ID aea87832-0605-471d-b8ae-b0dcb746f722) threw an exception. More information is included below.

SHUTDOWN is in progress.
Login failed for user 'SBSNETWORK\spfarm'.
A severe error occurred on the current command.  The results, if any, should be discarded.
0
 
Vitor MontalvãoMSSQL Senior EngineerCommented:
Do you have any firewall that you need to pass to reach the SQL Server?
Also run this command in DOS prompt and see if your server name is returned:
SETSPN -L <MSSQL service account>

Open in new window

0
 
OleDAuthor Commented:
The SQL Server is local  (Small Business Server).

If I run
SETSPN -L servername I got these two MSSQL

MSSQLSvc/servername.sbsnetwork.local:SHAREPOINT
MSSQLSvc/servername.sbsnetwork.local:SBSMONITORING
0
 
Vitor MontalvãoMSSQL Senior EngineerCommented:
The parameter shouldn't be the servername but MSSQLServiceAccount.
SETSPN -L <MSSQL service account>

Open in new window

0
 
OleDAuthor Commented:
I not sure about the syntax (serviceaccount).
MSSQL (Sharepoint) service use "LocalSystem" account
0
 
Vitor MontalvãoMSSQL Senior EngineerCommented:
LocalSystem doesn't have access to the network and also isn't a good user for a service account.
I wrote an article about SQL Server accounts if you want to read it as you may should change the account.
0
 
OleDAuthor Commented:
Would Local Service be OK or .......?
MSA can't be used on SQL 2008
0
 
Vitor MontalvãoMSSQL Senior EngineerCommented:
Like I wrote on that article:

If you are running SQL Server 2012 or superior version in a stand-alone machine then use a Managed Service account (MSA) or a Virtual Service account (VSA) to simplify service management, depending on whether resources external to the SQL Server computer are needed (use MSA) or not (use VSA).

If it isn't a cluster go for VSA. Otherwise you'll need a domain account.
0
 
OleDAuthor Commented:
Where can I see a list of virtual account?
0
 
Vitor MontalvãoMSSQL Senior EngineerCommented:
They are local accounts. You can find them in Local Users and Groups.
0
 
OleDAuthor Commented:
It's a SBS2011 server.
0
 
Vitor MontalvãoMSSQL Senior EngineerCommented:
Sorry, I never worked with a SBS server before. I believe that it might not have virtual accounts. If so you need to use a domain account instead.
0
 
OleDAuthor Commented:
Should it be "Standard user" account or som special permission?
0
 
Vitor MontalvãoMSSQL Senior EngineerCommented:
It should have the required permissions only. Check in this MSDN article about it (jump directly to Windows Privileges and Rights section).
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.