i a new admin, exist a log file for know who connect and from where?

[jamiguel77]

hi all, easy question.

i am new admin Db. i want configure my Sql server for know who connect and from where?
any white paper for read?

thanks

 

[metevil80]

Books Online has a lot of good information. Also there is a very detailed book available on Amazon called Microsoft SQL Server 2008. I also have found two other books that are helpful which are SQL Server 2008 Administration, and Professional SQL Server 2008 Internals and Troubleshooting. You may also want to check out a few blog sites, my personal favorite is BrentOzar.com.

 

[SQLBill]

You can create a trace script that will trace 'Audit Login' and gather the columns that you need. Put that script into a stored procedure and have a job run it daily.

That's one way to capture login information.

-SQLBill

The following is part of my signature block and is only intended to be informational.
Posting advice: FAQ481-4875

 

[yelworcm]

You can configure all login successes to be reflected in the SQL Server's errorlog file. Be careful of what you wish for, though.
In Management Studio, connect Object Explorer to the instance in question.
Right click on the server name, and select Properties
Select the Security section on the left menu
Switch the radio button (should be obvious but I forget the label offhand).

 

[djj55]

Watch logging LOGIN and LOGOUT. This can create large trace files if done incorrectly.

djj
The Lord is my shepherd (Psalm 23) - I need someone to lead me!