Does not insert log for database logging for SqlExpress

1 message Options
Embed this post
Permalink
geninf

Does not insert log for database logging for SqlExpress

Reply Threaded More More options
Print post
Permalink
I am able to log it to file.

but for db having issues
 <target name="DatabaseLog" xsi:type="Database" keepConnection="false" useTransactions="true" dbProvider="mssql"
             connectionString="Data Source=.\SQLEXPRESS;AttachDbFilename=C:\temp\aa\app1\App_Data\Db1.mdf;Integrated Security=True;User Instance=True"
             commandText="INSERT INTO LogTable(time_stamp, [level], logger, [message]) VALUES (@time_stamp,@level,@logger,@message);" >
        <parameter name="@time_stamp" layout="${date}"/>
        <parameter name="@level" layout="${level}"/>
        <parameter name="@logger" layout="${logger}"/>
        <parameter name="@message" layout="${message}"/>
      </target>

    <rules>
       <logger name="*" minlevel="Fatal" writeTo="DatabaseLog" />

Can anyone tell me what I am doing incorrect.