EncryptByPassPhrase() returns a varbinary() data type. Change @encrystaff and the subsequent column in the table to varbinary(128).

lcardwell (5/5/2009)

---

Now that's...

Brad M. McGehee (5/5/2009)

---

malathi.mahadevan (5/5/2009)

---

Not sure if anyone has thoughts of retiring as a DBA? We are probably yet to meet people who have. The hassle of staying a DBA...

Jeremy Brown (5/5/2009)

---

This isn't to insinuate that a degree isn't useful, rather to make the point that any degree is a big comittment to your career in general. I...

They should not have a detrimental effect if you remove them. You might use kerbtray to see if the tickets are even being created/assigned.

Carlton Leach (4/29/2009)

---

Hi Brian, Great article I agree.

I am having trouble getting Kerberos set up tho.

I am using:

- a Virtual Machine (VMWare)

- sql 2005 SP3

I have run the 4...

I thought about it after I posted but forgot to follow up. Password complexity and minimum length will still be enforced. It is within Active Directory, too. Those determine whether...

I used Domain Admins and Active Directory as a parallel security structure.

In Active Directory, within a domain, the Domain Admins group is king. Therefore, a member of the Domain Admins...

It might have to do with your permissions. Are you changing it using a sysadmin level account? Because in AD, as a domain admin that password history doesn't apply to...

Password history is enforced. It maintains a password history:

BOL: Password Policy

Policy management. Figure out how much you spend on configuration costs. How much risk there is if configuration was changed. Policy management solves that. 🙂

SQL Server 2000 - If both objects are owned by dbo, then you don't need to grant explicit DELETE on the table. In fact, you shouldn't. You should let ownership...

If they only need to delete, you can grant delete against that table. If they need to truncate, you've got a lot larger problem as 2000 doesn't give you anything...

Is the Identity for the application pool still running as Network Service? Are you seeing any audit failures corresponding to your normal user account in the Security event log on...

This explains how it all works:

Books Online: Security for Linked Servers