Failed to update database "Prod" because the Database is read only error message
TIBCO built a Custom extension for us and we recently migrated the Spotfire Metadata database to a new server. One of the aspects of the custom extension was to write into a table in SQL Server. When I use the same user credentials on SQL Server Management Studio the user has access to write to the table and update the table. But when I use the same jdbc parameters in the Data source connection parameter I am unable to write to the Database . I get the error that
"Failed to update database "Prod" because the Database is read only"
I am able to update the table using the same credentials in SQL server managaement studios though.
Do I need to refresh a file or clear out some cache? Please help me with this issue as I do not see how it is unable to write into the DB.
Thanks in advance.