Link to home
Create AccountLog in
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.)
Avatar of Jayaraja Jayaraman
Jayaraja Jayaraman
Flag of United States of America image

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

ASKER

I need more how to.
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.
Avatar of 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
Avatar of Vitor Montalvão
Vitor Montalvão
Flag of Switzerland image

Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
Avatar of 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.......?
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.
Avatar of 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.
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

Avatar of 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
The parameter shouldn't be the servername but MSSQLServiceAccount.
SETSPN -L <MSSQL service account>

Open in new window

Avatar of OleD

ASKER

I not sure about the syntax (serviceaccount).
MSSQL (Sharepoint) service use "LocalSystem" account
SOLUTION
Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
Avatar of OleD

ASKER

Would Local Service be OK or .......?
MSA can't be used on SQL 2008
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.
Avatar of OleD

ASKER

Where can I see a list of virtual account?
They are local accounts. You can find them in Local Users and Groups.
Avatar of OleD

ASKER

It's a SBS2011 server.
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.
Avatar of OleD

ASKER

Should it be "Standard user" account or som special permission?
It should have the required permissions only. Check in this MSDN article about it (jump directly to Windows Privileges and Rights section).