MSSQL Add Connection Dialog never enables OK button

[dboyd-usedc]

What is the bug or the crash?

No combination of data entered into the fields in the new MSSQL connection dialog seems to enable the OK button. I had to manually edit my QGIS3.ini file to add the connection.

Steps to reproduce the issue

1. Add Layer -> Add MSSQL Layer
2. Click 'New'
3. Fill out any combination of fields-- host, provider/DSN, connection name, username, password.
4. OK button never 'ungrays'

'Test connection' appears to populate the schema box, but 'list databases' is broken as far as I can tell.

Versions

QGIS version
3.22.1-Białowieża
QGIS code revision
663dcf8
Qt version
5.15.2
Python version
3.9.5
GDAL/OGR version
3.4.0
PROJ version
8.2.0
EPSG Registry database version
v10.038 (2021-10-21)
GEOS version
3.10.0-CAPI-1.16.0
SQLite version
3.35.2
PDAL version
2.3.0
PostgreSQL client version
13.0
SpatiaLite version
5.0.1
QWT version
6.1.3
QScintilla2 version
2.11.5
OS version
Windows 10 Version 2009

Active Python plugins
db_manager
0.1.20
grassprovider
2.12.99
MetaSearch
0.3.5
processing
2.12.99
sagaprovider
2.12.99

Supported QGIS version

• I'm running a supported QGIS version according to the roadmap.

New profile

• I tried with a new QGIS profile

Additional context

No response

[dboyd-usedc]

Just installed a new version and can confirm same behavior

QGIS version
3.24.2-Tisler
QGIS code revision
13c1a02
Qt version
5.15.2
Python version
3.9.5
GDAL/OGR version
3.4.2
PROJ version
9.0.0
EPSG Registry database version
v10.054 (2022-02-13)
GEOS version
3.10.2-CAPI-1.16.0
SQLite version
3.38.1
PDAL version
2.3.0
PostgreSQL client version
unknown
SpatiaLite version
5.0.1
QWT version
6.1.3
QScintilla2 version
2.11.5
OS version
Windows 10 Version 2009

Active Python plugins
db_manager
0.1.20
grassprovider
2.12.99
MetaSearch
0.3.6
processing
2.12.99
sagaprovider
2.12.99

[elpaso]

I cannot reproduce the bug on master: the "Ok" button is expected to remain disabled (grey) until one database is selected, if "List Databases" does not list any database you cannot select the database and you cannot add a new connection.

[jkr-wrk]

This bug is caused by database permission settings. I had exactly the same issues.

QGis tries to ask the database-machine for available databases to populate the list of databases, but in my case has no rights to receive this list. But as long as you don't pick from the list of databases you can't click OK.

I was able to install QGis 3.4 and add the database with that version, because in that version you can type in the database name in stead of picking it from the list.

Then you can add the database there and QGis will remember the connection when opening newer versions of QGis. You could also save the connection-settings to a file and load this file in newer versions of QGis.

[alexbruy]

Should we close this?

[github-actions]

The QGIS project highly values your report and would love to see it addressed. However, this issue has been left in feedback mode for the last 14 days and is being automatically marked as "stale".
If you would like to continue with this issue, please provide any missing information or answer any open questions. If you could resolve the issue yourself meanwhile, please leave a note for future readers with the same problem and close the issue.
In case you should have any uncertainty, please leave a comment and we will be happy to help you proceed with this issue.
If there is no further activity on this issue, it will be closed in a week.

[github-actions]

While we hate to see this happen, this issue has been automatically closed because it has not had any activity in the last 42 days despite being marked as feedback. If this issue should be reconsidered, please follow the guidelines in the previous comment and reopen this issue.
Or, if you have any further questions, there are also further support channels that can help you.