Jack Corbett (11/27/2008)

---

The problem is that Builtin\Administrators are sysadmins if you don't remove them or change them. This can be an audit problem. Does the server operations group...

Manie Verster (11/27/2008)

---

To the professionals I want to say: "If you want to allow them to do it to you then it's your own fault. However, don't let somebody suffocate...

MarkusB (11/27/2008)

---

I would add two more tasks to the checklist

1. Remove Built-in admiinstrators

2. Disable or at least rename the sa account (in 2005 or higher).

About hte loging of succesful logins...

I agree with Rob. I also find there is general lack of feedback from the people you help, I get lots of feed back here ;). But I have...

Ken Simmons (11/26/2008)

---

Failed logins are really the most important. It just depends on how busy your system is. It is all preference on what you would like to monitor.

I...

Oops forgot to ask questions regarding the article :P.

Point #2, Enable Successful and Failed logs ...

I understand having that on for the first little while in a new system to...

Steve,

For auduting purpose I would recommend saving up the Default Trace log; depending on your work load, you can save that daily, or multiple times/day. And...

Steve Jones - Editor (11/25/2008)

---

Perhaps things are mis-worded, but I think the answer is fine.

Connecting via IP and port would be connecting to my local server as 127.0.0.1, 1433

That would...

Aaa I am late :(. But I agree with it, I was talking to Microsoft Engineer on recent course. Because every book tells me to turn of Browser...

When it comes to the Maintenance tasks for deleting old files, I found another annoying fact about them. I am not sure if anyone else has run into this,...

I am not sure if applys to SQL Server directly ... I found the following artile:

Store passwords using reversible encryption

http://technet.microsoft.com/en-us/library/cc784581.aspx

EDIT: But since it is a policy setting...

Old Password is required if a user was changing the password. If you were changing the password with SysAdmin account it doesn't care. It allows for force over-write....

That is interseting .. I didn't expect that answer.

I expected if SQL Server was told not to force password expirey then following will not be checked:

Enforce password history

Minimum password age

Simplying...

I liked the question; I didn't think about it when I answered it much (so I got it wrong :(). The SQL syntax looked right, but needed to read...

Nice article :).

I spend a lot of time on performance tuning; it is my favorite activity. I find many people don't like to pay attention to it. I...