Questions tagged [sql-authentication]
12 questions
3
votes
2 answers
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 [UserName] with password='Password',…
user2637453
- 141
- 5
3
votes
1 answer
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 listener DNS name
Recently we have setup Read Only…
Aleksey Vitsko
- 6,148
- 5
- 39
- 70
1
vote
1 answer
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 Laravel site running on my Linux VM running under…
SteB
- 349
- 1
- 5
- 15
1
vote
1 answer
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; Trusted_Connection=Yes;
2:…
Furkan Gözükara
- 553
- 1
- 8
- 18
0
votes
0 answers
AWS RDS MySQL IAM authentication always Access Denied
I am trying to set up IAM authentication in an AWS RDS MySQL database. I've followed the guidance in AWS' documentation (which I see is the same as on various other webpages about the topic).
I know that the problem is not the VPC security group,…
0
votes
0 answers
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 about authenticating from a client app using…
DooHickey
- 1
- 1
0
votes
0 answers
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 connect only via JDBC from the backend code.
and…
Naresh A
- 9
- 1
0
votes
1 answer
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 softwares like beekeper studio.
But I am able to…
Jdeep
- 101
- 1
0
votes
0 answers
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 protocols are enabled and the "Domain admins"…
Roman Peralta
- 31
- 1
- 5
0
votes
1 answer
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 authentication for example)?
0
votes
1 answer
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't no exist in 12 (it has been over a year since…
Brandon
- 235
- 5
- 12
-2
votes
3 answers
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 feel a little pain for doing something they…
Laura Pilon
- 1
- 1
- 3