I have 2 problems.
1. We would like to move our ZENworks-db to another instance (on the same MSSQL2005-server), however after moving and edited zdm.xml I can not connect (creating an ODBC-connection works fine). I think the problem is the syntax of zdm.xml when using named instance, here is what I have tried:
<entry key="Server">sqlprod02\instans2</entry>

However this does not work. Can someone please advice on how to edit zdm.xml to enable named instance?

2. During this process my DBA deleted and recreated the zcmadmin user on the database-server and now the permissions are not quite right, can someone please check on their server what the "Effective Permissions" should be for this user and post them here?

Please advice.