Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 windows password security problem

Author  Topic 

cranedbird78
Starting Member

1 Post

Posted - 2005-11-28 : 16:32:00
I am a third party provider of an MS_SQL application running on SQL Server 2000 to Windows 2000 desktops, using Windows authentication to connect users to the SQL database . The customer IS Department maintains their network (30 - 50 servers, one is dedicated to our application) and has started to update user passwords every quarter. When the IS Department updates the user passwords the for the users of our application they all lose connectivity to our application.
Shouldn't Windows propigate password changes at the Windows level into the SQL server security information for our database?
(One other note - the customer may be using Novell for part of their system administration - could this have an effect?). Any suggestions would be greatly appreciated.


dod crane

afrika
Master Smack Fu Yak Hacker

2706 Posts

Posted - 2005-11-29 : 03:12:03
i would advice you use MS SQL authentication in this case rather than windows default.

I doubt windows woudl update your MS SQL passwords
Go to Top of Page
   

- Advertisement -