How to grant CREATE TABLE access during DB initialization on YAF (Yet Another Forum) installation?

I'm new to YAF, but I'm trying to install it anyway. In the installation wizard at the time of "Initializing the database", this message appears:

The specified schema name 'dbo' does not exist or you do not have permissions to use it.

I don't know what to do because the connection string gives me the message that it is connected successfully, I'm using Microsoft SQL Server and windows authentication to access the database.

I know that the error is very explicit, but I don't know how to solve it, I tried the following:

   exec sp_grantlogin 'IIS APPPOOL\siteyaf'     use Forum     exec sp_grantdbaccess 'IIS APPPOOL\siteyaf'  

But doesn't work. I really don't know what I'm doing wrong.

Any help is appreciated.

https://stackoverflow.com/questions/66683669/how-to-grant-create-table-access-during-db-initialization-on-yaf-yet-another-fo March 18, 2021 at 09:48AM