- [Home page](https://www.brimit.com/)
- [Blog](https://www.brimit.com/blog)

# A Solution to the Links Database Issue in Sitecore 9

[#How-to](https://www.brimit.com/blog?categories=#How-to) [DXP](https://www.brimit.com/blog?platforms=DXP)
[Artsem Prashkovich](https://www.brimit.com/blog/author?authors=Artsem%20Prashkovich) on June 29, 2019

In some cases, we have to set up our Content Management (CM) server as a standalone instance, which will still allow us to use the Content Delivery (CD) roles appropriately. An example of such case is when we try to run Processing, Reporting and Content Management role on the same instance in Sitecore 9 and the server role config with Content Management, Processing, Reporting is not working ([see the details of the issue](https://sitecore.stackexchange.com/questions/9961/server-role-config-with-contentmanagement-processing-reporting-not-working/)).

A solution to that issue is to set up a CM server with the standalone role. It works out most of the times, but in case you use Links Database on your project for some purposes (in our case we use it to pull related articles, for example), you will notice that references are missing on CD servers and your functionality will not work in the end.

We faced the issue twice and the reason, which caused it, is really simple, but not obvious. Let’s look at the patch settings in the Sitecore.config:

```
<sc.variable name="defaultLinkDatabaseConnectionStringName" value="core">
<sc.variable name="defaultLinkDatabaseConnectionStringName" value="core" />
  <sc.variable name="defaultLinkDatabaseConnectionStringName" role:require="ContentDelivery or ContentManagement">
    <patch:attribute name="value">web</patch:attribute>
  </sc.variable>
</sc.variable>
```

We can see that the path will be applied only for a CD or a CM role. In case we use the standalone role for CM server, the Core database will be used to store references between items. At the same time, the patch will be applied to the CD server and it means that the CD server will be expected to see references in the web database. So, the CM server writes the links into the Core database, while the CD server reads it from the web database…and here comes the issue.

To solve the issue we only need to update the patch:

```
<sc.variable name="defaultLinkDatabaseConnectionStringName" value="core">
<sc.variable name="defaultLinkDatabaseConnectionStringName" value="core" />
  <sc.variable name="defaultLinkDatabaseConnectionStringName" role:require="ContentDelivery or ContentManagement or Standalone">
    <patch:attribute name="value">web</patch:attribute>
  </sc.variable>
</sc.variable>
```

Or create our own patch file to avoid any changes in default Sitecore configuration files.

###### Author

![artsiom-photo](https://www.brimit.com/-/jssmedia/feature/blogs/authors/artsiom-200.jpg?h=202&iar=0&w=200&hash=41797D2540DF6EB6FDF558360F6F62B8)

Artsem Prashkovich

Sitecore MVP/ Solution Architect
[Artsem Prashkovich](https://www.brimit.com/blog/author?authors=Artsem%20Prashkovich)

###### More By Categories

[#Events](https://www.brimit.com/blog?categories=#Events) [#How-to](https://www.brimit.com/blog?categories=#How-to) [#News](https://www.brimit.com/blog?categories=#News) [#Guides](https://www.brimit.com/blog?categories=#Guides)

###### More by Platform

[Data and AI](https://www.brimit.com/blog?platforms=Data%20and%20AI) [DXP](https://www.brimit.com/blog?platforms=DXP) [E-commerce](https://www.brimit.com/blog?platforms=E-commerce) [Internet of Things](https://www.brimit.com/blog?platforms=Internet%20of%20Things) [Sales and marketing automation](https://www.brimit.com/blog?platforms=Sales%20and%20marketing%20automation)

#### More on Sitecore

![How Vercel Will Help You Save Effort When Deploying Sophisticated Sitecore Projects](https://www.brimit.com/-/jssmedia/project/brimit/blog/2024/vercel_cover-image.png)
#Guides #How-to DXP E-commerce

##### How Vercel Will Help You Save Effort When Deploying Sophisticated Sitecore Projects

Optimize and accelerate the development and deployment of complex multisite Sitecore projects.

Alexei Vershalovich on July 17, 2024
[How Vercel Will Help You Save Effort When Deploying Sophisticated Sitecore Projects](https://www.brimit.com/blog/how-vercel-will-help-you-save-effort-when-deploying-sophisticated-sitecore-projects)

![Training Up Tomorrow's Sitecore MVPs: a Mentoring Success Story](https://www.brimit.com/-/jssmedia/project/brimit/blog/2023/sitecore-mentoring---cover-image.png)
#How-to DXP

##### Training Up Tomorrow's Sitecore MVPs: a Mentoring Success Story

How to participate in the Sitecore Mentor program and help younger colleagues jump-start a career in Sitecore development.

Sergey Baranov on October 2, 2023
[Training Up Tomorrow's Sitecore MVPs: a Mentoring Success Story](https://www.brimit.com/blog/training-up-tomorrows-sitecore-mvps)

![Going Headless. Part 2: When a Headless CMS Is Your Best Bet (if you have Sitecore)](https://www.brimit.com/-/jssmedia/project/brimit/blog/2022/headless/adobestock_456986731.jpg)
#How-to DXP E-commerce

##### Going Headless. Part 2: When a Headless CMS Is Your Best Bet (if you have Sitecore)

Discover how a headless CMS can benefit organizations that use Sitecore.

Daniil Raschupkin, Palina Trokhautsava on September 15, 2022
[Going Headless. Part 2: When a Headless CMS Is Your Best Bet (if you have Sitecore)](https://www.brimit.com/blog/going-headless-part-2-when-a-headless-cms-is-your-best-bet-if-you-have-sitecore)