Questions tagged [sql-authentication]
The sql-authentication tag has no usage guidance.
12
questions
-2
votes
3
answers
96
views
Why does killing a SQL Connection allow a reconnect with SSMS
I would like to kill connections for individuals using certain sql auth logins in SSMS that are reserved for our apps. They should have to go out of their way to reauthenticate into sql and at least ...
0
votes
0
answers
42
views
SQL Server Authentication failing when running SSMS using runas \netonly
I use the runas \netonly command to launch SSMS as another Windows user that has elevated database permissions. This is so I can retain access to the local drives / directories that my normal user (...
0
votes
0
answers
232
views
Kerberos client authentication times out with SQL error 87
Apologies for the length of this but I'm app developer, not a SQL DBA nor network Admin, so I'm out of my area and just wanted to be sure I documented everything as well as I could.
This is a problem ...
2
votes
1
answer
522
views
PHP remote SQL Server authentication issue
I have a named instance of SQL Server 2019 Developer Edition running on my host Windows 10.
Using SSMS I can log in locally using Windows Auth or a SQL Server account.
Whenever I try this from my ...
0
votes
0
answers
19
views
what is the possibility to create a SQL user to connect through JDBC only not with SSMS and other tools?
Maybe my understanding was not clear about user authentication in MSSQL. I am very new to DataBase subjects.
Thought of checking with the experts here.
I am planning to provide access to SQL users to ...
1
vote
1
answer
2k
views
Which authentication is better for MS-SQL Server 2019 : integrated security=SSPI vs uid=sa;pwd=xx | windows auth vs sa auth
In my different web applications I use both ways, however, I would like to learn which method is better:
1: server=localhost;database=x; integrated security=SSPI;persist security info=False; ...
0
votes
1
answer
46
views
How to know if mysql server is using sha_256 or caching_sha_256 authentication plugin?
Seems like I am using an older version on Mysql Server which uses sha_256 plugin for Authentication (which is now deprecated) .Because of this, I am unable to connect to my server with third party ...
3
votes
2
answers
1k
views
Can't connect to Azure SQL with error 18456
I'm trying to grant access to my Azure SQL database (on an elastic pool) to an external developer using SQL Authentication.
In the database (not master) I ran the following commands:
create user [...
0
votes
0
answers
37
views
AD groups authentication doesn't work at the console of SQL Server 2017
I come up with this. A Domain admin windows user is able to login to a SQL Server 2017 instance from any client computer, but it can not login from the console of the server. TCP/IP and Shared memory ...
0
votes
1
answer
418
views
How to prevent logins using Windows Authentication in SQL Server?
SQL Server supports creating logins using SQL, Windows, certificates and asymmetric keys. Is it possible to remove the option of creating logins with Windows authentication (and just allow SQL ...
0
votes
1
answer
1k
views
How to setup an ssh connection to a postgres 12 db using dbeaver
I am currently in the process of trying to connect to my local postgres 12 db. In the past (9.3/9.6) you were able to edit the .pg_hba file to modify which connections were allowed but that file doesn'...
3
votes
1
answer
894
views
Availability Group Read Only Routing Not Working for SQL Logins
We have following config of Availability Group:
server1.domain.com - primary
server2.domain.com - sync secondary
server3.domain.com - async secondary
sql-listener.domain.com - availability group ...