Failed to update database "Prod" because the Database is read only error message

Hi ,

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.