On SQL Server 2005 SP2 you can setup a logon trigger and audit for an sa login via that means.

skjoldtc (11/13/2008)

---

Twitter is another way to be always connected. Who needs that? There has to be downtime somewhere.

Friends and family get irritated as it is that I don't check personal...

Can't get rid of 'em as SQL Server uses 'em. However, you're right that they do create a security issue. It's even worse when you have a cluster, because those...

I have heard cases where a technology group creates a Twitter account and sets the updates to private. Then, their technicians follow (and are approved) and therefore, they use Twitter...

I make pretty heavy use of Twitter, to the point where I even have TwitterBerry installed on my BlackBerry. For me it's extremely useful. Not only is there the social...

It sounds like BUILTIN\Administrators was removed from SQL Server. If you can log on to the server, whether at the console or through terminal services, there is a way to...

They will be named instances. Named instances, by default, set their ports dynamically. So they'll do the work for you. Unless you change its port setting using Configuration Manager, when...

Has the sa login been disabled? If not, then does it have Password Policy enforced checked?

With respect to connecting to SQL Server, they effectively do the same thing. If the login is disabled or if it is denied the ability to connect to SQL Server,...

Log Parser may be able to do...

1. SQL Server Configuration Manager is the tool.

2. Yes, each MUST use a different port. Ports cannot be shared.

3. Any above 1024 that's not in use by another service. Run...

MarkusB (5/6/2008)

---

400 mb for a new profile seems more than enough space. Espescially for a new service account.

I would check the profile of the default user if it contains lots...

P Jones (10/20/2008)

---

There's a lot of frustration around that we can't do much about the financial situation and it all looks gloomy. One suggestion for the next weekend -...

This link puts into perspective that sudden wealth isn't the answer. The problems which existed beforehand are still present and a whole host of new problems will likely beset us.

http://www.associatedcontent.com/article/70165/winning_the_lottery_curse_or_a_blessing.html

The...

One of my coworkers owns a trailer park. He has pointed out that some of his tenants are perfectly happy if their family life is working and they have enough...