Keep in mind that a logon trigger that blocks a certain application (like Excel) will do that for all connections of that application. So if you have other databases that...

Yes, as Mohammed has posted, check to see if there is an account already added with that SID. In the case where the user or group name is changed in...

Lowell (5/10/2011)

---

it's actually a very common security setup to have a group with ONLY execute permissions; some applications are designed so that all data is accessed via stored procs, so...

Citrix is built on top of the Terminal Services technology but provides a greatly enhanced experience, especially as far as manageability is concerned. You can learn more at http://www.citrix.com. It's...

You'll need to do the following:

- Create a user defined role to assign permissions to.

- Grant CREATE PROCEDURE to that role.

- Grant CREATE FUNCTION to that role.

- Grant ALTER on...

Usually you see this sort of error when the user in question is a member of too many Windows groups. Based on the name, this looks like a service account,...

Depends on the type of group as well as the trust relationship between B and C. For instance, for a group in Domain B to able to take users from...

This sort of works. There are two ways to have the equivalent of sysadmin rights as of SQL Server 2005. The first is to be a member of the sysadmin...

Without knowing your AD domain and trust setup, it's nearly impossible to troubleshoot this. That's not something you want out in the public domain, so at this point, I'm going...

There are a few issues with this scenario.

1. SQL Server will be exposed to the Internet. While this is doable, it's not fun. Definitely can't run with default ports or...

Lowell (5/6/2011)

---

i think if you connect to a specific database and run this it might do what you are after:

select 'EXEC sp_help_revlogin ' + name

from sys.database_principals

where type_desc IN ('SQL_USER','WINDOWS_USER')...

I agree with Michael: best to check with legal professionals. And yes, it does vary from state-to-state. For instance, California's data breach laws aren't pretty.

ebeyalb123 (4/26/2011)

---

One more insight: In our case the attacker used the tomcat manager interface (that unfortunately was publicly open with the default password) to install a servlet that started the...

Richard Warr (4/26/2011)

---

Although the OP is over seven years old it's clear that there are still lessons to be learned here for many of us. Is it really a requirement...

Do you have the option of using Windows groups and Windows authentication? If so, this is trivial. Put both sets of users in a Windows group. Make that Windows group...