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?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

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
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
The 7 Worst Nightmares of a Sysadmin

Fear not! To defend your business’ IT systems we’re going to shine a light on the seven most sinister terrors that haunt sysadmins. That way you can be sure there’s nothing in your stack waiting to go bump in the night.

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
Vitor MontalvãoMSSQL Senior EngineerCommented:
Open SQL Server Configuration Manager and check if SQL Server Browser is running. If not, start it.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
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
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SharePoint

From novice to tech pro — start learning today.