Hi,

I am facing a strange issue with password synchronization to JDBC, If i restart the driver and set a universal password it is synchronized and after that if i add a new user to the database and then try to set a universal password it gives the following error.

Message: <description>An error occurred executing statement "EXECUTE sp_password @new = '{$$password}', @loginame = 'test17'".</description>
<jdbc:exception jdbc:class="java.sql.SQLException" jdbc:error-code="15002" jdbc:sql-state="HY000" xmlns:jdbc="urn:dirxml:jdbc">
<jdbc:message>[Microsoft][SQLServer 2000 Driver for JDBC][SQLServer]The procedure 'sp_password' cannot be executed within a transaction.</jdbc:message>
<jdbc:stack-trace>java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC][SQLServer]The procedure 'sp_password' cannot be executed within a transaction.