user7078's questions

My company is planning a migration of users, computers, and groups from an acquired company. Both companies have Active Directory domains and there is a 2 way trust between them. The other company has data on linux servers that are accessed via SAMBA and secured using their AD users and groups. We are hoping to do a staged migration of a subset of objects over a period of time rather than migrate all objects at once.

The question is, after a user is migrated to our domain will they still be able to access the SAMBA share in the trusting domain?

http://social.msdn.microsoft.com/Forums/en-US/sqldatabaseengine/thread/f9236131-cfcc-48ed-b431-57884842e874/

I needed to limit access to Sql Mgt Studio for certain users. I found the article above that creates a trigger to prevent making connections for specified users.

CREATE TRIGGER [SQLGP_Logon_trigger_sql_tools]

ON ALL SERVER FOR LOGON

AS

BEGIN

  IF ORIGINAL_LOGIN() not in ('domain\Administrator',
    'sa',
    'domain\user1',
    'domain\user2',
    'domain\user3') AND 
    (program_name() like 'Microsoft SQL Server Management Studio' 
    or program_name() like 'Microsoft SQL Server Management Studio - Query' 
    or program_name() like 'SQL Query Analyzer')
  ROLLBACK

END

As I was playing with the code on our development server I created a trigger that prevents access for all users. I tried using osql to connect but get the error message

Logon failed for login 'someuser' due to trigger execution.

This is similar to the message you get when connecting with Sql Mgt Studio.

Is there a way to force this trigger to disable?