Are you just granting the ability to connect to the database or are you also assigning them to a role further down?

I like Spolsky's and Fog Creek's take on performance and compensation.

Fog Creek Compensation

We as humans tend to think we've done better than what we've actually done. So that means...

eric_russell 13013 (5/4/2010)

---

If someone is developing something like a desktop application for release as shareware, and they feel it's important to protect the contents of proprietary reference tables and SQL...

eric_russell 13013 (5/4/2010)

---

If the instance of SQL Server is running on the user's desktop, then by default, they are a privillaged user. Even if you embedded and encrypted the SQL...

There is a difference between ownership and execution context. Typically the jobs are not owned by the SQL Server Agent service account. They are owned by whowever created the job...

TechNet Script Center:

TechNet Script Center - Script Repository

You can't turn off ownership chaining. So you can't turn off the implicit permissions. But because you posted this in a SQL Server 2005 forum, let's look at what you...

As a former AD architect, here's why I say that:

- One, it can be a nightmare to troubleshoot that linked server connection. It's fraught with issues, which you can see...

I would recommend using a script outside of SQL Server which runs periodically and populates lookup tables for users, groups, and group memberships. Your AD administrators will thank you. 🙂

Are you using a Symantec/Veritas product to backup the server? If so, it likely recognizes that there is a SQL Server on the system and is using the SQL Server...

If your asymmetric keys were created from the database master key (they should be unless you specified otherwise), once you regain access to the database master key, yes, you should...

By default SQL Server is case insensitive with respect to the login. So unless you've chosen a collation when you installed SQL Server that is case sensitive, it doesn't matter...

Did you remove BUILTIN\Administrators without adding back in NT Authority\System with sysadmin rights? If so, the Full Text service needs to run under System and that's how it connects into...

Toby White (4/29/2010)

---

If I remote into the server and open a connection from SSMS there I get Kerberos. However, all the other connections from SSMS that are Kerberos are connecting...

Can you post the error you're getting? Can you ping the SQL Server? Can you telnet to the port that it's listening on?