Why won't Serilog log to table using WriteTo.MSSqlServer sink?

Question

I am new to Serilog and I wrote a small test .NET Core app which tries to write a log to a local SQL Server database. The code below successfully creates the table, but no matter what I do I can't get it to write a log record. I didn't see any errors suggesting there are permission issues. Anyone have an idea?

using Serilog;
using Serilog.Sinks.MSSqlServer;

namespace SerilogTest
{
    class Program
    {


        private static ILogger InitSqlLogger()
        {
            var columnOptions = new ColumnOptions();
            columnOptions.Store.Remove(StandardColumn.MessageTemplate);
            columnOptions.Store.Remove(StandardColumn.Properties);
            columnOptions.Store.Remove(StandardColumn.Exception);
            columnOptions.Store.Remove(StandardColumn.Level);
            columnOptions.Store.Remove(StandardColumn.TimeStamp);
            return new LoggerConfiguration()
                .WriteTo.MSSqlServer(@"Server=(local);Database=LogEvents; Integrated Security = SSPI;", "Logs", autoCreateSqlTable: true, columnOptions: columnOptions)
                .CreateLogger();
        }
        private static void WriteLog()
        {
            var msg = "This is a {message:l}";
            Log.Logger.Information(msg, "test");
        }
        static void Main(string[] args)
        {
            Log.Logger = InitSqlLogger();
            WriteLog();
        }
    }
}

Some ideas to help troubleshoot: https://stackoverflow.com/a/52960592/211672 — C. Augusto Proiete, Oct 24 '18 at 04:01

C. Augusto Proiete · Accepted Answer · 2018-10-09T15:30:12.407

1

Most likely, you're getting permission issues with writing to your SQL Server table.

Serilog sinks for logging are safe by default, and don't throw exceptions, so if you want to troubleshoot what's happening, you should look at Serilog's SelfLog

e.g.

Serilog.Debugging.SelfLog.Enable(msg => Console.WriteLine(msg));

edited Oct 09 '18 at 15:30

answered Sep 24 '18 at 21:20

C. Augusto Proiete

24,684
2
63
91

Thanks, Caio! I did check out the bit of code you linked me to. Nevertheless, there were no reported errors after I implemented the code. I even hooked it up to the TextWriter as recommended - and no errors were recorded. Very strange! – Steven Augustine Stuart Sep 25 '18 at 14:12
Update: everything is in fact working now. Thank you for your help! – Steven Augustine Stuart Sep 25 '18 at 19:23
1

@StevenAugustine What was it? – C. Augusto Proiete Sep 25 '18 at 19:24

Why won't Serilog log to table using WriteTo.MSSqlServer sink?

1 Answers1