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
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.
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
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:
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.
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 ?