dbeaver: Reference to database and/or server name in 'KIOSK.sys.schemas' is not supported in this version of SQL Server
System information:
-
Operating system (distribution) and version Windows 10 1803
-
DBeaver version 5.3.4.201902031804
-
Java version OpenJDK 11.0.2
-
Additional extensions None
Connection specification:
-
Database name and version SQL Server(Azure) 12.0.2000.8
-
Driver name Azure SQL Server
-
Do you use tunnels or proxies (SSH, SOCKS, etc)? None
Describe the problem you’re observing:
After I connect to a SQL Azure, I can’t open ‘Schemas’ folder.
Steps to reproduce, if exist:
- Add a new connection to SQL Azure and connect to it.
- Open any DB but ‘master’.
- Try to open ‘Schemas’ folder. Following error messages occur.
SQL Error [40515] [S0001]: Reference to database and/or server name in 'KIOSK.sys.schemas' is not supported in this version of SQL Server.
Reference to database and/or server name in 'KIOSK.sys.schemas' is not supported in this version of SQL Server.
Include any warning/errors/backtraces from the logs
About this issue
- Original URL
- State: closed
- Created 5 years ago
- Reactions: 4
- Comments: 23 (8 by maintainers)
Commits related to this issue
- #5258 show only specified in connection settings database by default for Azure — committed to dbeaver/dbeaver by LonwoLonwo 2 years ago
- #5258 add setting "show all databases" for Babelfish too — committed to dbeaver/dbeaver by LonwoLonwo 2 years ago
- #5258 "Show all databases" setting saving problem fixed — committed to dbeaver/dbeaver by LonwoLonwo 2 years ago
- #5258 show only specified in connection settings database by default … (#17223) * #5258 show only specified in connection settings database by default for Azure * #5258 add setting "show all datab... — committed to dbeaver/dbeaver by LonwoLonwo 2 years ago
As a workaround, you can put the name of the database you want to connect to in the database connection settings (the field “Database/Schema” just under “Host”.) Apparently Azure SQL doesn’t allow database switching on an active connection.
Hi everyone. Options to use the ability to see all databases of connection implemented in this ticket and will be available in the next release, 22.1.4 By default, only specified in the connections setting database will be shown in the Database navigator tree.
And we created another ticket to solve the main issue of this ticket: https://github.com/dbeaver/dbeaver/issues/17263
That is correct. The real issue is that I have at least 22 databases on one dev server. It is not ideal to have to create so many connections. Other DB IDEs don’t seem to have this problem, but I prefer to use DBeaver.
To be clear, I don’t need to run queries cross-database, just connect, view, and edit tables.
@uslss can we get a comment on why this was closed? Has it been fixed? 😃
Multi-database support does not work for UREL-configured connections since 23.0.0. An issue about making this works here #19241
So please just use host and port for connection configuration
So workaround which I got is out of “Master” or your personal database Schema like “AzureDB” you can only set 1 at a time in DBeaver. I have set “AzureDB” in DataBase/Schema option it is working now.