S
steve pittman
Guest
Hi Betty, The error you see is from a sql client who failed authentication, probably the ODBC client you mentioned . They were trying to connect as user “sysprogress”. Is it possible that the ODBC users connect as “sysprogress” without having any _User table user defined for “sysprogress” ? This works if sysprogress is the only sql DBA defined in the db – in table _sysdbauth. Once more DBA’s are defined, then sysprogress cannot login (fails authentication) unless defined in _User. So it could be that this authentication failure started occurring because a new sql DBA got created in the db. This long-standing limitation helps lead to better security practices. Hope this helps, ….steve pittman [OE sql software architect]
Continue reading...
Continue reading...