Use the IS_MEMBER() function.

Did the account you were using have administrative rights on all nodes?

With the nesting of AD groups I've seen flaky behavior using such methods. One workaround that we've used is to take the Windows groups and make them members of the...

Can you detail what permissions you gave the service account (and it'll have the be the same on each physical node of the cluster) and what services failed when you...

If internal applications are accessing the database, we tend to like a single Windows user login, a service account, if you will. That way individual users can't get direct access...

If it's 2005/2008, you need the SHOWPLAN permission at the database level. You also need the ability to execute the query. This is for the actual execution plan returned from...

Because of ownership chaining, I'm not sure that you can. Permissions are going to be checked at the first object (the view) and if the owner of that view is...

Login = account that allows you to connect to the SQL Server. Also known as server principal. Can be a SQL Server login, a Windows user login, or a Windows...

At some point, yes. Generating the screenshots is what is problematic since I'm no longer a domain admin (took a...

Kevin Rathgeber (5/19/2009)

---

While on the whole Kerberos subject here...Have you ever run into a problem where it appears that Kerberos appears to just stop working (not sure if it is...

Can you ping the SQL Server 2008 server from the client?

Is it a named instance you are trying to hit? If so, have you updated MDAC on the client? If...

By design, SQL Server 2005 and above only shows the objects which a user has permissions for. So in your example, if you create a shared login which has SELECT...

The correct permissions and what options you may have there are documented in Books Online:

Setting up Windows Service Accounts

How was it solved?

Actually, I'm sorry, it should be varbinary(256). nvarchar is 2 bytes per character. The varbinary is not guaranteed to be readable characters, meaning the conversion may store something that doesn't...