RTE not displaying links as GUID

Often we encounter issue where Sitecore Link in RTE is presented in GUID instead its SEO friendly URL. Sitecore by default do render Sitecore Link in RTE in GUID, this is so as to allow movement of the targeted item within the content tree without the need to change the RTE itself. Fortunately Sitecore OOB also support the functionality to convert this GUID link to its SEO friendly URL.

There are two ways to achieve this,

1. Using sc:html instead for example sc:text
2. Using the following code global::Sitecore.Links.LinkManager.ExpandDynamicLinks(value, true);

I personally prefer the first approach whenever possible just because it involves the least amount of coding work.

Microsoft SQL Server Error 18456 Severity 14 State 1

Just then, i have encountered a puzzling error about a newly created login user that I have just created in database. For some odd reason, i keep getting login error even though i have checked that both username and password is correct.

It turned out that the SQL Server is not setup properly. The security setup in SQL server was set to "windows authentication" only where it is supposed to be both "SQL and Windows authentication".

to enable this, right click the SQL Server, click properties, under security tab you will see the radio button. Select "SQL Server and Windows Authentication mode"

Remember to restart the SQL Server as the changes will not take effect before a reboot. To reboot, right click SQL Server -> Restart