TCP/IP to connect. But 2 of the users accounts keep on
having their windows accounts locked out.
Any suggestions?Turn on Windows auditing, maybe even SQL auditing as well. Have your users
log off and back on their computers and watch both security logs. NT
authentication for SQL doesn't ask for a password when connecting, it just
checks your Windows credentials. Are they mapping network drives before
connecting to SQL? Maybe the password credentials there are bad. You might
want to tell them to disconnect any network drives and remap them. Do a net
use as well and check for persistent connections.
****************************************
***************************
Andy S.
MCSE NT/2000, MCDBA SQL 7/2000
andymcdba1@.NOMORESPAM.yahoo.com
Please remove NOMORESPAM before replying.
Always keep your antivirus and Microsoft software
up to date with the latest definitions and product updates.
Be suspicious of every email attachment, I will never send
or post anything other than the text of a http:// link nor
post the link directly to a file for downloading.
This posting is provided "as is" with no warranties
and confers no rights.
****************************************
***************************
"Marcus" <anonymous@.discussions.microsoft.com> wrote in message
news:26ee01c3e18d$626c7820$a101280a@.phx.gbl...
quote:
> I have 50 users connecting to SQL server via ODBC using
> TCP/IP to connect. But 2 of the users accounts keep on
> having their windows accounts locked out.
> Any suggestions?
No comments:
Post a Comment