Repository creation error on MS SQL 2000 database

Classic Servoy
1

Servoy gives the following error message when creating the repository on a MSSQL 2000 database:

com.servoy.j2db.persistence.RepositoryException: java.sql.SQLException: SELECT permission denied on object ‘servoy_groups’, database ‘servoy_repository_test’, owner ‘servoy_test’.
java.sql.SQLException: SELECT permission denied on object ‘servoy_groups’, database ‘servoy_repository_test’, owner ‘servoy_test’.

Has anyone any idea what causes this problem and what to do about it?

Servoy Version 3.5.6-build 519
MSSQL Server 2000

2

“permission denied” normally indicates you are connecting with user with not enough rights, to do certain actions on the db objects.

3

Thanks,

That is correct, but in this case it’s the same user (servoy_test) who created the object gets denied SELECT permission. This happens during the first repository database creation of Servoy.

One solution is to make the SQL user (servoy_test) explicitly dbowner of the repository database instead of a database user with dbowner rights. Because this happened by a client of us doing a test setup of Servoy, I don’t know the exact configuration of MSSQL server yet. If I find out why this happens I’ll let you know.