Unable to add new logins to the SQL Sever 2008 instance

Question

Unable to add new logins to the SQL Sever 2008 instance

srimit03-703293

Grasshopper

Points: 24
More actions
August 11, 2009 at 5:04 am

#213272

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 <> FROM WINDOWS WITH DEFAULT_DATABASE=[master]
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 (Build 3790: Service Pack 2)
Kindly help me out.
Thanks in Advance,
HyperJ

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

Adi Cohn-120898 SSC-Dedicated Points: 33944 More actions · Answer 1

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/

srimit03-703293 Grasshopper Points: 24 More actions · Answer 2

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 !!!!!!!!!!

Silverfox SSC-Insane Points: 23150 More actions · Answer 3

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]

support.sql Default port Points: 1444 More actions · Answer 4

You need to evaluate your server permissions to know who can create triggers at server level.

SNM

Try Free Microsoft SQL Server Data Collector & Performance Monitor.

http://www.analyticsperformance.com[/url]

@nalyticsperformance - Microsoft SQL Server & Windows Server Free Data Collector