Avatar of OleD
OleD
 asked on

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.)
Microsoft SharePointSBSMicrosoft SQL Server

Avatar of undefined
Last Comment
Vitor Montalvão

8/22/2022 - Mon
Jayaraja Jayaraman

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 ?
OleD

ASKER
I need more how to.
Mohit Nair

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.
I started with Experts Exchange in 2004 and it's been a mainstay of my professional computing life since. It helped me launch a career as a programmer / Oracle data analyst
William Peck
OleD

ASKER
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
ASKER CERTIFIED SOLUTION
Vitor Montalvão

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
GET A PERSONALIZED SOLUTION
Ask your own question & get feedback from real experts
Find out why thousands trust the EE community with their toughest problems.
OleD

ASKER
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.......?
Vitor Montalvão

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.
⚡ FREE TRIAL OFFER
Try out a week of full access for free.
Find out why thousands trust the EE community with their toughest problems.
OleD

ASKER
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.
Vitor Montalvão

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

OleD

ASKER
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
Experts Exchange has (a) saved my job multiple times, (b) saved me hours, days, and even weeks of work, and often (c) makes me look like a superhero! This place is MAGIC!
Walt Forbes
Vitor Montalvão

The parameter shouldn't be the servername but MSSQLServiceAccount.
SETSPN -L <MSSQL service account>

Open in new window

OleD

ASKER
I not sure about the syntax (serviceaccount).
MSSQL (Sharepoint) service use "LocalSystem" account
SOLUTION
Vitor Montalvão

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
⚡ FREE TRIAL OFFER
Try out a week of full access for free.
Find out why thousands trust the EE community with their toughest problems.
OleD

ASKER
Would Local Service be OK or .......?
MSA can't be used on SQL 2008
⚡ FREE TRIAL OFFER
Try out a week of full access for free.
Find out why thousands trust the EE community with their toughest problems.
Vitor Montalvão

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.
OleD

ASKER
Where can I see a list of virtual account?
Vitor Montalvão

They are local accounts. You can find them in Local Users and Groups.
Experts Exchange is like having an extremely knowledgeable team sitting and waiting for your call. Couldn't do my job half as well as I do without it!
James Murphy
OleD

ASKER
It's a SBS2011 server.
Vitor Montalvão

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.
OleD

ASKER
Should it be "Standard user" account or som special permission?
⚡ FREE TRIAL OFFER
Try out a week of full access for free.
Find out why thousands trust the EE community with their toughest problems.
Vitor Montalvão

It should have the required permissions only. Check in this MSDN article about it (jump directly to Windows Privileges and Rights section).