Hi Guys! I've been having this problem and I hope you guys can help me out. When I'm trying to add new database, I will always have a "create failed for database" error. Image is below.
And also, I've read online that you should change the user permissions in order for it to work. So I went to security -> login -> server roles and then I checked dbcreator. After I've hit OK, there's another error "Add member failed for server". Image is below.