See if this helps:

Configuring Kerberos Authentication[/url]

Unless the port changes, you should not need to re-register.

If the login is a SQL Server based one, no. They exist on the one server only. However, when you create a linked server connection, you can map the login...

Are you able to open the master key on the database?

Confidentiality - Ensuring only authorized personnel/services can see the data.

Integrity - Ensuring only authorized personnel/services can modify the data through authorized processes.

The CIA Triad

Yes and no. Part of...

Marios Philippopoulos (4/9/2009)

---

In http://msdn.microsoft.com/en-us/library/cc837966.aspx it is stated that, in terms of encrypting symmetric keys used for data encryption:

Can anyone please provide...

Have you verified the trust relationships between the two domains? Is anything else being affected, such as access to file shares, etc.?

Simon Smith (4/9/2009)

---

I have a SQL 2005 server in a hosted environment. It runs various internal applications (written in-house) that are only accessed by users via the Citrix infrastructure. Because...

This is a very broad topic. SQL Skills maintains a whitepaper listing:

SQL Server Whitepapers

The following would be of interest to you in the 2005 section:

SQL Server 2005 Security Best Practices...

Manners are important. If we don't treat each other right within the community, the community will cease to exist. This dates me, but I've seen very busy BBSes die because...

If you want that reminder in spades, read The Devil Wears Prada. The...

It depends. If they use the app and they come into the database when using that app with their credentials, you're pretty much stuck. Otherwise, create a role called Support....

aureolin (4/2/2009)

---

In an emergency you must remember to panic!!

Well, not really, but people who *are* panicking often get really angry at your failure to panic along with them. They...

Great article, Mike. One thing I would add to it is to emphasize in the IT world is that documentation should be occuring throughout the troubleshooting effort. Record what you're...

For those who have an issue with the article, think of it as a great learning tool. When you get a young or inexperienced DBA in, sit him or her...