A new Database SQL user can be added from the DotNetNuke Host SQL page. This user can then be used as a replacement for the existing user in the connection string in the web.config file.
In the example below a new user called , dnnDbUser, will be created and added as a db owner of the dnnDB database. The password assigned to the user will be dnnDbPword
To add the new user login of dnnDbUser enter and run the code:
exec sp_addlogin ‘dnnDbUser’, ‘dnnDbPword’
The new user needs to be given the required permissions:
exec sp_grantdbaccess ‘dnnDbUser’
Lastly, to assign the database access to the user:
exec sp_addrolemember @rolename=’db_owner’,@membername=’dnnDbUser’
