I have a web site running Kentico 5.0 and everything is fine.
I tried to install a new one using Kentico 5.5, but I'm experiencing some issues.
I always use the ApplicationPool (domain\apppooluser) identity to create new websites. The given user is member of the group xxxAdminDB and the group is granted as db_owner in the database where I installed Kentico.

1 - Kentico 5.5 adds the user to the DB users: why does it so? I tried to delete it, but it add it each time I try to create a new website.

2 - Kentico adds the user and set its default schema to 'domain\apppooluser', not dbo. This way it gets an exception because the SQL statement is not well formet (you should alway encapsulate the schema between [...])

I was able to solve it by changing:
- the default schema of the user domain\apppooluser in the DB Security configuration
- the schema of all tables, procedures and views

I'm still not able to remove the user from the Security/Users because Kentico readd it.


Hope I was clear enough.
Thanks for your support
Regards
Emanuele Firmani