SQL server was not found or not accessible

 after restarting all my form server i am unable to connect site. before is working fine, i wonder and i check Event Viewer then i find below log.
 
"Unknown SQL Exception xxx occurred. Additional error information from SQL Server is included below.

A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)"

 i realize and assume sql server service was stopped or machine not in network, but all are enabled. then i ping db machine ip in command prompt, is running. then after i ping server db machine name but i can't able to connect. then again i check all my form servers and i find domain control server was not in network[unfortunately] then i add domain control server to network and now site works fine.

Comments

Post a Comment

Popular posts from this blog

PAGE NOT FOUND ERROR PAGE IN SHAREPOINT 2013

Image
Default PageNotfound\404 page   - By default, all the Publishing sites contain a default Error\404 page  “PageNotFoundError .aspx” page which is added to the “Pages” library (See below). This page can be modified to add some custom text. “Error Page” Content Type -   To allow users to Create a new 404 Error page, Publishing Sites now contain a new Content Type “ Error Page “.This Content type Inherits from “Page” Content type and has a typical layout of a Page Not found or 404 pages. To find this Content type Navigate to Site Settings -> Content Types -> Error Page. Create a New PageNotFound or 404 Page  – To Create a new 404 page admins can navigate to the “Pages” Library and under the “Files tab” select “New Document”.In the “New Document” drop-down menu select “Error Page” (see the screen below). Once you have Created a new Error Page you can modify it by simply clicking the page in the pages library and editing it. Once done Check In and Pub
Keep reading

Send Mails in SharePoint Event Receiver

After I getting the user, email id from item( described in Previous Post) . Now I need to send mail to the user, I tried lot of ways to send mails and finally I realise that below code is best for my scenario to send mails. SmtpClient smtpClient = new SmtpClient(); smtpClient.Host = properties.Web.Site.WebApplication.OutboundMailServiceInstance.Server.Address; MailMessage mailMessage = new MailMessage(MailFrom, mailTo); mailMessage.Subject = MailSubject; mailMessage.Body = MailBody; mailMessage.IsBodyHtml = true; smtpClient.Send(mailMessage); here smtpClient.Host is getting the local mail server address and we include from, to and subject, body in MailMessage and finaly send the message using smtpClient.Send(mailMessage), and don’t forgot to include try catch blocks. Good luck.
Keep reading

Get Host site list items in SharePoint Hosted App.

Those who starts working on Apps might face issues to read host site list items. In sharepoint hosted APP using Rest API we able to query host site list items. The rest url to get host site is almost similar to get list items but we need to specify the app context and target. Make sure JQuery loaded before to execute the code in app web parts. 'use strict'; var HostUrl=""; var AppUrl==""; // load function // Intialize HostUrl, AppUrl from query strings. // call get items method $(document).ready(function () {         HostUrl= GetQueryString("SPHostUrl");        // Get Host Url from query string         AppUrl= GetQueryString("SPAppWebUrl");        // Get App Url from query string getItems("DemoList");                                        // get list items }); // function to get list items using Rest Api function getItems(listname) {             $.ajax({                 url: AppUrl + "/_
Keep reading