Ok, here goes the solution under credits of our It Manager Marcelo Ramos :
When you install netxms, on the database creation screen, it asks you for a credential. This credential, somehow is passed as paramenter when creating the SQL tables, and if you take a look on that, it creates as "username.tablename".
EX: netxms.acl
netxms.actions
netxms.address_lists
And the correct would be :
dbo.acl
dbo.actions
dbo.address_lists
At least it was done on my case. And we made a SQL script to correct it
First run this script and select the output as "text" (not as grid) to generate the final script.
--*************************************************************************************
SELECT 'EXEC sp_changeobjectowner ''' + TABLE_SCHEMA + '.' + TABLE_NAME + ''', dbo'
FROM INFORMATION_SCHEMA.TABLES
WHERE
OBJECTPROPERTY(OBJECT_ID(QUOTENAME(TABLE_SCHEMA) + '.' + QUOTENAME(TABLE_NAME)), 'IsMSShipped') = 0
AND TABLE_TYPE = 'BASE TABLE'
GO
--*************************************************************************************
The output would be something like this :
EXEC sp_changeobjectowner 'netxms.acl', dbo
EXEC sp_changeobjectowner 'netxms.actions', dbo
EXEC sp_changeobjectowner 'netxms.address_lists', dbo
EXEC sp_changeobjectowner 'netxms.agent_configs', dbo
EXEC sp_changeobjectowner 'netxms.agent_pkg', dbo
EXEC sp_changeobjectowner 'netxms.alarm_change_log', dbo
EXEC sp_changeobjectowner 'netxms.alarm_grops', dbo
EXEC sp_changeobjectowner 'netxms.alarm_group_map', dbo
...
... I cuted the middle
...
EXEC sp_changeobjectowner 'netxms.user_profiles', dbo
EXEC sp_changeobjectowner 'netxms.users', dbo
EXEC sp_changeobjectowner 'netxms.vpn_connector_networks', dbo
EXEC sp_changeobjectowner 'netxms.vpn_connectors', dbo
EXEC sp_changeobjectowner 'netxms.zone_ip_addr_list', dbo
EXEC sp_changeobjectowner 'netxms.zones', dbo
All you have to do is copy all lines generated, and run them on netxms database.
After that, All my configuration, data, objects, everything is working perfectly as on the test environment.
I hope it helps someone else.
Thanks for all guys that helped me on this issue.
