Sitecore 8.0 - Failed to connect to SQL database(-2147467259 master)

Hi Friends,

Many of you might have faced the issue while installing  Sitecore 8.0 from .exe file.

Figure 1

Solution: SQL server installation should be done using the account NETWORK SERVICE/LOCAL SERVICE/. So you will need to uninstall Microsoft SQL server from Program manager, Delete the physical folder from C:/Program files, delete the Registry entries if things do not work. Re-install SQL server using the mentioned account and not the default account selected. 

SiteCore 9.0 - [Issue]:Forms/templates does not show up in the Forms section from dashboard.

Hi All,

I was facing issue while working with Forms in Sitecore 9.0. I created the form and it was showing in the content editor under Forms node.

However, no forms were showing in the Dashboard's form section. See Figure 1.

Figure 1

Solution: Just rebuild the indexes of the master database and it will start showing.

Sitecore 9.0.0 - Lab 8 - After adding reference to sitecore.contentsearch

Hi Friends,

I was going through the below course:

Sitecore® 9.0 Platform Essentials for Developers eLearning Lab Module Error

In the last lab which is of Module 8, I got the below error and my site stopped working. I was unable to login as the login page was not showing up. 

Server Error in '/' Application.

Method not found: 'System.String Sitecore.ContentSearch.Abstractions.ISettings.GetSetting(System.String, System.String)'.

Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code. 

Exception Details: System.MissingMethodException: Method not found: 'System.String Sitecore.ContentSearch.Abstractions.ISettings.GetSetting(System.String, System.String)'.

Source Error: 

An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.

Stack Trace: 

[MissingMethodException: Method not found: 'System.String Sitecore.ContentSearch.Abstractions.ISettings.GetSetting(System.String, System.String)'.]

   Sitecore.ContentSearch.SolrProvider.SolrContentSearchManager.get_IsEnabled() +0

   Sitecore.ContentSearch.SolrProvider.Pipelines.Loader.InitializeSolrProvider.Process(PipelineArgs args) +14

   (Object , Object[] ) +71

   Sitecore.Pipelines.CorePipeline.Run(PipelineArgs args) +469

   Sitecore.Pipelines.DefaultCorePipelineManager.Run(String pipelineName, PipelineArgs args, String pipelineDomain) +22

   Sitecore.Nexus.Web.HttpModule.Application_Start() +161

Solution : Sitecore.ContentSearch.NoReferences and Sitecore.ContentSearch.Linq.NoReferences packages that are provided in Student Resources are not compatible with the latest sitecore 9.0.0. version.  So, you need to override the listed DLLs with the one which came with the original setup of sitecore. 

Sitecore 9.0.0 - Content editor not opening after installing package

Hi Friends,

I faced an issue after installing a package. My content editor was not opening. Below is the screenshot of the error

Solution:

The error is related to solr. The config files at the path "App_Config\Sitecore\ContentSearch"  are modified. Replace/Rollback all the files from the backup you have of the specific folder. 

Sitecore 9.0.0- Controller path not found while deploying files from Sitecorerocks to the webroot hosted site

Hi All,

I found the controller path not found error while I deployed the files from sitecore rocks to the localhost webroot folder of sitecore. I struggled a lot to get it sorted and below is the solution:

1) Whenever you create a publish custom profile, never select the option of  "Delete Existing files", it can eat a lot of your time to fix it as it deletes the existing running sitecore instance of your machine😟😟

2) Make sure that the versions of the listed Dll files are same in the localhost webroot directory i.e c://inetpub/wwwroot/yoursitecorehostedfolder and your project folder from where you are pushing your complied files to webroot.

a) System.web.mvc.dll
b)System.Web.Razor.dll
c)System.web.Services.dll
d)System.web.webpages.deployment.dll
e)System.web.webpages.Razor.dll

For some of my colleagues just making sure that system.web.mvc.dll version was same at both the location, it worked. But it did not work for me.