pkg/sql: remove usages of createTestServerParams to increase tenant testing coverage #140446
Description
This issue is part of our effort to ensure all tests run with tenant testing, with a focus on the tests in pkg/sql/.
Many of these tests use createTestServerParams, which initializes with tenancy disabled via base.TODOTestTenantDisabled. We should either remove all instances of this or identify missing features in the multi-tenant model.
Part of #138912
Epic: CRDB-48564
Jira issue: CRDB-47162