Solved

Need to know where SQL 2005 creates its log files

Posted on 2007-11-24
4
199 Views
Last Modified: 2010-04-21
I know this is easy for many of you so I will assign the full 500 points to the first correct answer.  I am having a security problem with logging into my SQL Database from an application I wrote.  I need to know where SQL 2005 stores its log files so I can determine the details of the login problem.

Thanks
Kenny
0
Comment
Question by:kwh3856
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
4 Comments
 
LVL 6

Accepted Solution

by:
PaultheBroker earned 500 total points
ID: 20344616
C:\Program Files\Microsoft SQL Server\MSSQL.2\MSSQL\LOG
0
 
LVL 55

Expert Comment

by:Jaime Olivares
ID: 20344625
In fact the "MSSQL.2" portion can vary depending on your database instance.
0
 

Author Closing Comment

by:kwh3856
ID: 31410820
Thank you very much
0
 
LVL 6

Expert Comment

by:PaultheBroker
ID: 20344649
cool - thanks for the info Jamie.
0

Featured Post

Get 15 Days FREE Full-Featured Trial

Benefit from a mission critical IT monitoring with Monitis Premium or get it FREE for your entry level monitoring needs.
-Over 200,000 users
-More than 300,000 websites monitored
-Used in 197 countries
-Recommended by 98% of users

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

I am showing a way to read/import the excel data in table using SQL server 2005... Suppose there is an Excel file "Book1" at location "C:\temp" with column "First Name" and "Last Name". Now to import this Excel data into the table, we will use…
In this article I will describe the Backup & Restore method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
Monitoring a network: how to monitor network services and why? Michael Kulchisky, MCSE, MCSA, MCP, VTSP, VSP, CCSP outlines the philosophy behind service monitoring and why a handshake validation is critical in network monitoring. Software utilized …
This tutorial will teach you the special effect of super speed similar to the fictional character Wally West aka "The Flash" After Shake : http://www.videocopilot.net/presets/after_shake/ All lightning effects with instructions : http://www.mediaf…

617 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question