August 11, 2009 at 5:04 am
Hi,
I'm running SQL Server 2008 and am recently unable to add logins to the server. I was able to do them previously.
I use the following code
USE [master]
GO
CREATE LOGIN <
GO
I get the following error message
Msg 208, Level 16, State 1, Procedure trig_AuditCreateLogin, Line 33
Invalid object name 'Admin.dbo.Logins'.
I am using a sysadmin account to create logins.
SQL SERVER VERSION : Microsoft SQL Server 2008 (RTM) - 10.0.1787.0 (X64) Jan 7 2009 17:58:44 Copyright (c) 1988-2008 Microsoft Corporation Enterprise Edition (64-bit) on Windows NT 5.2
Kindly help me out.
Thanks in Advance,
HyperJ
August 11, 2009 at 7:54 am
It looks like there is a DDL trigger on create login statement. The trigger produces the runtime error and preventing you from adding a new login. Check the code in the trigger that is called trig_AuditCreateLogin
Adi
--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
August 11, 2009 at 10:28 pm
Excellent, worked like a charm after i disabled the server trigger. Wondering though how it got created? are malicious scripts capable of doing them?
Thanks a lot Adi !!!!!!!!!!
September 4, 2009 at 3:38 am
not really I would say that your sql server had the trigger created by someone/team as part of auditing requirements
--------------------------------------------------------------------------------------
[highlight]Recommended Articles on How to help us help you and[/highlight]
[highlight]solve commonly asked questions[/highlight]
Forum Etiquette: How to post data/code on a forum to get the best help by Jeff Moden[/url]
Managing Transaction Logs by Gail Shaw[/url]
How to post Performance problems by Gail Shaw[/url]
Help, my database is corrupt. Now what? by Gail Shaw[/url]
November 29, 2009 at 5:04 pm
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply