Tracey, have your AD administrator PM me and I can discuss it with him/her off-line. Sounds like there's just a simple misunderstanding or misconfiguration going on.

Outstanding. I didn't know Dreamweaver had that capability.

To be honest, I'm not a big fan of MBSA. I use it to check patch levels and do password checks, but when it comes to SQL Server, I don't...

You could if you can specify a WHERE clause. Unfortunately, I'm not familiar with Dreamweaver, so I don't know if that's possible. What's going on with sys.objects is in SQL...

Do you mean the user is a member of the db_datawriter role? Being a member of db_datareader and db_ddladmin in this instance is irrelevant. Neither give access to INSERT into...

The SPN does not need to be recreated when SQL Server is stopped and restarted. The only reason this would be necessary is the SQL Server is using dynamic ports...

GUI: Adding a SQL Login to SQL Server

It's how to add, but it shows the basic mechanism. You would just right-click on the login and choose Properties to get to...

I'd go with the SQL Server 2000 BOL, then. I'm looking at the 2005 BOL which lists db_owner.

Attach = I think as a member of...

Have you done troubleshooting with KerbTray running on the client computer?

dpkngm (1/13/2009)

---

Actually i am trying to replicate database from one server to another server. When i click on the replication->Configuration Distribution m receiving an error saying SQL Server replication requires...

And use Kerbtray in your troubleshooting. That will show you if the tickets are being created correctly.

The best way to do this is not to store the password/passphrase at all. Rather, store a hash of the password/passphrase. You can get that by using a cryptographic hash...

But there's a significant difference between configuring for Kerberos authentication and Kerberos delegation. Kerberos delegation requires configuration beyond the SPNs.

Are both SQL Servers set up for Kerberos authentication (including SPNs in Active Directory) and the first SQL Server set up further for Kerberos delegation to the second?