Error 7aB8: Unable to update user in SDConnex
Symptom: Unable to update the user in SDConnex.
Cause: Can occur when the database was migrated, and the server’s name has changed
As more and more clients use VMs in their testing or production environments, the SDConnex errors (Unable to update database or user) start to occur more often. Follow the instructions below to resolve this problem.
Resolution
1. Run the SQL query below and write down the server\instance name:
Use master
GO
sp_helpserver
2. If the SQL server uses the default instance, drop "\sqlexpress" from the following query. If the SQL Server uses an instance name and the server is not an Express installation, replace "sqlexpress" with the instance name.
Use master
Go
Sp_dropserver ‘myoldserver\sqlexpress’
GO
Sp_addserver ‘mynewcompname\sqlexpress’, ‘LOCAL’
GO
sp_serveroption 'mynewcompname\sqlexpress', 'data access', 'true'
GO
sp_helpserver
Verify that the information returned is correct. VERY IMPORTANT FINAL STEP:
3. Restart SQL Server and SDConnex (very important final step)
From the service panel:
Restart SQLServer (SQLEXPRESS)
Restart WinMagic.SDConnex
Custom Fields
Version: Affects all Versions