﻿#### 

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&amp;iar=0&amp;w=200&amp;hash=41797D2540DF6EB6FDF558360F6F62B8)
Artsem Prashkovich
Sitecore MVP/ Solution Architect](https://www.brimit.com/blog/author?authors=Artsem%20Prashkovich)

#### 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-toDXPE-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](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-toDXP
##### 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](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-toDXPE-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](https://www.brimit.com/blog/going-headless-part-2-when-a-headless-cms-is-your-best-bet-if-you-have-sitecore)

![](https://bat.bing.net/action/0?ti=187017043&amp;tm=gtm002&amp;Ver=2&amp;mid=f3a4ac3d-ff86-41fe-b6a0-1782ca98af72&amp;bo=2&amp;gtm_tag_source=1&amp;pi=0&amp;lg=en-US&amp;sw=800&amp;sh=600&amp;sc=24&amp;nwd=1&amp;tl=A%20solution%20to%20the%20Links%20Database%20issue%20in%20Sitecore%209&amp;kw=Sitecore,%20content%20delivery,%20content%20management,%20standalone%20role&amp;p=https%3A%2F%2Fwww.brimit.com%2Fblog%2Fa-solution-to-links-database-issue-in-sitecore-9&amp;r=&amp;lt=267&amp;evt=pageLoad&amp;sv=2&amp;asc=D&amp;cdb=AQAY&amp;rn=652707)