Sybase NNTP forums - End Of Life (EOL)

The NNTP forums from Sybase - forums.sybase.com - are now closed.

All new questions should be directed to the appropriate forum at the SAP Community Network (SCN).

Individual products have links to the respective forums on SCN, or you can go to SCN and search for your product in the search box (upper right corner) to find your specific developer center.

Strange - 'maximum failed logins'

7 posts in General Discussion Last posting was on 2011-11-22 16:26:41.0Z
Raj Posted on 2011-11-20 06:50:30.0Z
Sender: 1e3f.4ec8a19d.1804289383@sybase.com
From: Raj
Newsgroups: sybase.public.ase.general
Subject: Strange - 'maximum failed logins'
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <4ec8a336.1e93.1681692777@sybase.com>
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 19 Nov 2011 22:50:30 -0800
X-Trace: forums-1-dub 1321771830 10.22.241.41 (19 Nov 2011 22:50:30 -0800)
X-Original-Trace: 19 Nov 2011 22:50:30 -0800, 10.22.241.41
Lines: 17
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.general:30701
Article PK: 73591

Hi,

We have an issue in one of our production servers. We had
to configure 'maximum failed logins' to 5 at server level,
But We changed it to 0 for couple of application logins
using sp_modifylogin. Application login still gets locked if
I make 5 failed login attempts using that login. I found it
is a bit strange. Why is it happening so ? Am I missing
anything ?
Sybase version is 12.5.4.
Also an important thing, We did the same in TEST
environment, It works fine. login is not getting locked.

Have you heard of anything such ? Why is it so ?

Thanks in advance,
Raj


Cory Sane [TeamSybase] Posted on 2011-11-20 08:00:53.0Z
From: "Cory Sane [TeamSybase]" <cory!=sane>
Newsgroups: sybase.public.ase.general
References: <4ec8a336.1e93.1681692777@sybase.com>
In-Reply-To: <4ec8a336.1e93.1681692777@sybase.com>
Subject: Re: Strange - 'maximum failed logins'
Lines: 27
MIME-Version: 1.0
Content-Type: text/plain; format=flowed; charset="iso-8859-1"; reply-type=original
Content-Transfer-Encoding: 7bit
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Windows Mail 6.0.6002.18197
X-MimeOLE: Produced By Microsoft MimeOLE V6.0.6002.18463
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <4ec8b3b5$1@forums-1-dub>
Date: 20 Nov 2011 00:00:53 -0800
X-Trace: forums-1-dub 1321776053 10.22.241.152 (20 Nov 2011 00:00:53 -0800)
X-Original-Trace: 20 Nov 2011 00:00:53 -0800, vip152.sybase.com
X-Authenticated-User: TeamSybase
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.general:30702
Article PK: 73595

Raj,
Send us the output of
sp_displaylogin TheLoginInQuestion
but also hide the actual name so that we don't see it.

--
Cory Sane
[TeamSybase]
Certified Sybase Associate DBA for ASE 15.0

"Raj" wrote in message news:4ec8a336.1e93.1681692777@sybase.com...
> Hi,
>
> We have an issue in one of our production servers. We had
> to configure 'maximum failed logins' to 5 at server level,
> But We changed it to 0 for couple of application logins
> using sp_modifylogin. Application login still gets locked if
> I make 5 failed login attempts using that login. I found it
> is a bit strange. Why is it happening so ? Am I missing
> anything ?
> Sybase version is 12.5.4.
> Also an important thing, We did the same in TEST
> environment, It works fine. login is not getting locked.
>
> Have you heard of anything such ? Why is it so ?
>
> Thanks in advance,
> Raj