starred/cloudbeaver

Fork 0

mirror of https://github.com/dbeaver/cloudbeaver.git synced 2026-04-25 13:46:02 +03:00

[GH-ISSUE #392] SQL Server different auth modes #114

New issue

Closed

opened 2026-03-07 20:44:58 +03:00 by kerem · 9 comments

kerem commented

2026-03-07 20:44:58 +03:00

Owner

Originally created by @hpolonskaya on GitHub (Jun 16, 2021).
Original GitHub issue: https://github.com/dbeaver/cloudbeaver/issues/392

Hi, I'm trying to connect Cloudbeaver to SQL server with sql server authentication . it's working with DBeaver,
but how to get it work with cloudbeaver.
Here is snippet what i'm talking about

Originally created by @hpolonskaya on GitHub (Jun 16, 2021). Original GitHub issue: https://github.com/dbeaver/cloudbeaver/issues/392 Hi, I'm trying to connect Cloudbeaver to SQL server with sql server authentication . it's working with DBeaver, but how to get it work with cloudbeaver. Here is snippet what i'm talking about <img width="401" alt="Screen Shot 2021-06-16 at 12 10 57 PM" src="https://user-images.githubusercontent.com/12278631/122256095-b9a8ce80-ce9c-11eb-849c-1d40db460a23.png">

kerem

2026-03-07 20:44:58 +03:00

closed this issue
added the
xf:authentication

x:sql server
labels

kerem commented

2026-03-07 20:44:59 +03:00

Author

Owner

@hpolonskaya commented on GitHub (Jun 18, 2021):

any updates?

@hpolonskaya commented on GitHub (Jun 18, 2021): any updates?

kerem commented

2026-03-07 20:45:00 +03:00

Author

Owner

@uslss commented on GitHub (Jun 21, 2021):

if I understand you right, you can connect to SQL server using SQL Server Authentication by filling in username and password in Authentication block in Connection settings. Could you check it and write back if it works for you.

Sorry for the late response.

@uslss commented on GitHub (Jun 21, 2021): if I understand you right, you can connect to SQL server using SQL Server Authentication by filling in username and password in Authentication block in Connection settings. Could you check it and write back if it works for you. ![image](https://user-images.githubusercontent.com/31996417/122781302-57930380-d2b8-11eb-8273-778902a281ac.png) Sorry for the late response.

kerem commented

2026-03-07 20:45:00 +03:00

Author

Owner

@hpolonskaya commented on GitHub (Jun 21, 2021):

Unfortunately it's not working I'm trying to connect with the same credentials using DBeaver ,select from authentication dropdown list -> sql server authentication > connect sucessfull
But clouldbeaver does not have the same dropdown just user/psw
and as result
Error connecting to database:
Connection failed:
The connection to the host emdc2sqm102.media.global.loc, named instance db102 failed. Error: "java.net.UnknownHostException: emdc2sqm102.media.global.loc". Verify the server and instance names and check that no firewall is blocking UDP traffic to port 1434. For SQL Server 2005 or later, verify that the SQL Server Browser Service is running on the host.

and Here is dbeaver connection test

@hpolonskaya commented on GitHub (Jun 21, 2021): Unfortunately it's not working I'm trying to connect with the same credentials using DBeaver ,select from authentication dropdown list -> sql server authentication > connect sucessfull But clouldbeaver does not have the same dropdown just user/psw and as result Error connecting to database: Connection failed: The connection to the host emdc2sqm102.media.global.loc, named instance db102 failed. Error: "java.net.UnknownHostException: emdc2sqm102.media.global.loc". Verify the server and instance names and check that no firewall is blocking UDP traffic to port 1434. For SQL Server 2005 or later, verify that the SQL Server Browser Service is running on the host. --------- <img width="1208" alt="Screen Shot 2021-06-21 at 11 59 10 AM" src="https://user-images.githubusercontent.com/12278631/122792510-3dd9c800-d288-11eb-802e-4e2566538f03.png"> and Here is dbeaver connection test <img width="436" alt="Screen Shot 2021-06-21 at 12 01 48 PM" src="https://user-images.githubusercontent.com/12278631/122792846-872a1780-d288-11eb-84fb-16edfe8fabd5.png">

kerem commented

2026-03-07 20:45:00 +03:00

Author

Owner

@hpolonskaya commented on GitHub (Jun 22, 2021):

Hi any updates . Look like it's bug in Cloudbeaver UI for MS SQL connection.

@hpolonskaya commented on GitHub (Jun 22, 2021): Hi any updates . Look like it's bug in Cloudbeaver UI for MS SQL connection.

kerem commented

2026-03-07 20:45:00 +03:00

Author

Owner

@hpolonskaya commented on GitHub (Jun 24, 2021):

any updates on this issue

@hpolonskaya commented on GitHub (Jun 24, 2021): any updates on this issue

kerem commented

2026-03-07 20:45:00 +03:00

Author

Owner

@serge-rider commented on GitHub (Jun 28, 2021):

It looks like your SQL Server instance is not accessible from the machine where CloudBeaver was deployed (UnknownHostException). Host name cannot be resolved.

You need to consult with your network administrator.

@serge-rider commented on GitHub (Jun 28, 2021): It looks like your SQL Server instance is not accessible from the machine where CloudBeaver was deployed (UnknownHostException). Host name cannot be resolved. You need to consult with your network administrator.

kerem commented

2026-03-07 20:45:00 +03:00

Author

Owner

@hpolonskaya commented on GitHub (Jun 28, 2021):

Thank you Serge . it's working one more question.
what about Windows auth mode and the rest which dbeaver is supporting

@hpolonskaya commented on GitHub (Jun 28, 2021): Thank you Serge . it's working one more question. what about Windows auth mode and the rest which dbeaver is supporting

kerem commented

2026-03-07 20:45:00 +03:00

Author

Owner

@kseniiaguzeeva commented on GitHub (Jul 5, 2021):

Regarding your last comment I change your ticket status on a feature request.

@kseniiaguzeeva commented on GitHub (Jul 5, 2021): Regarding your last comment I change your ticket status on a feature request.

kerem commented

2026-03-07 20:45:00 +03:00

Author

Owner

@kseniiaguzeeva commented on GitHub (Jun 6, 2022):

SQL Server and NTLM authentication are available in the latest 22.1.0 release.

@kseniiaguzeeva commented on GitHub (Jun 6, 2022): SQL Server and NTLM authentication are available in the latest 22.1.0 release.

kerem referenced this issue

2026-03-07 21:04:07 +03:00

[PR #114] [MERGED] feat: connection behavior & error message fix #1460