Enterprise Library 2.0 and Database Trace Listener
-
Hello, I am trying to do logging to SQL Server 2000 database by using Database Trace Listener. The problem I have is very strange: Scenario1: I have SQLExpress installed on my machine and I was able to achive logging in database in this scenario where I was using integrated security I I got all the desired value in tables; such as Log, Category etc. Scenario2: I furtured my experiment by doing logging on SQL Server 2000 which is installed on a seperate machine but within the domain where my machine is registered as well. After I got done creating tables and stored procedure in already made database. When ever I tried to do logging in the database nothing happens, no data get populated in Data tables such as Category, Log etc. I tried using integrated security after impersonating my application to an administrator accout, I tried by making connection string by using "sa" account. Nothing is working.. Can somebody give me any clue? Thanks in advance