Questions tagged [authentication]
The process of identifying the party logging into a system.
347
questions
0
votes
2
answers
195
views
User handling in MS-SQL database
I have an MS-SQL installation, controlling different databases. This can be accessed using Microsoft SQL Server Management Studio 18. For doing that, I use Windows authentication.
In there, I have ...
5
votes
3
answers
5k
views
Slow Connection to Azure SQL Database using SQL Server Authentication
In SSMS, when connecting to any of our Azure SQL Databases using service accounts and SQL server authentication, the connecting itself can take between 10 to 15 seconds to establish.
Once connected, ...
28
votes
2
answers
166k
views
Mongo Create a user as admin for any database raise an error
I am trying to create a simple user with the rights permission to access to any database and can do any actions. When I trying to execute the createUser command I got this error:
db.createUser({ user:...
20
votes
5
answers
44k
views
Azure SQL Database "Login failed for user" in application, but works fine in SSMS
I wanted to try out the contained database users feature on Azure SQL Database V12, but I'm having a problem authenticating that seems odd to me.
I created a database called Classifier. I added my ...
3
votes
2
answers
8k
views
can't update user password on Mongodb 4.0.5 (Use of SCRAM-SHA-256 requires undigested passwords)
I'm trying to update a password from a user, using changeUserPassword(), and I just receive the following message:
Error: Updating user failed: Use of SCRAM-SHA-256 requires undigested passwords
&...
0
votes
0
answers
459
views
Enable username and password authentication on mongodb sharded cluster
I have a mongodb cluster(1 mongos, mongo config replica set with 2 members, 1 shard with 3 members) and I have enabled internal authentication in config replica set. Also my backend code connects to ...
1
vote
2
answers
145
views
Postgresql import user from linux
I install postgresql 9.2 on a Ubuntu 12.10 machine
I tried to import linux's user to postgresql
but only way I can figure out is
CREATE USER Jack WITH PASSWORD '1234';
and do it 10 times (if ...
15
votes
12
answers
182k
views
Error: Cannot Generate SSPI context
When someone tries to connect to a SQL Server instance, the error shows up:
It's not possible do generate SSPI context.
Yesterday we had a blackout (don't know how to say this expression in ...
0
votes
0
answers
95
views
Is it possible to use check_user_proxy on AWS RDS?
My top-level goal is to enable two-user (zero-downtime) secret rotation for RDS users. To recap/summarize the approach, you always have two accounts in your DB that have equivalent access. You switch ...
0
votes
2
answers
225
views
ISO 27001 - resetting passwords for SQL Server accounts
We are implementing security changes in order to pass an ISO 27001 audit.
We are in the process of setting all domain accounts (user accounts, admin accounts, service accounts) to have their passwords ...
-1
votes
1
answer
756
views
Best practice for connecting to Postgres from Django [closed]
I recently installed Postgres 11 on my Raspberry Pi 4, and attempted to connect to a database from my Django app:
return psycopg2.connect(dbname="covid")
The connection failed like so:
...
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
5k
views
Does my PostgreSQL instance support kerberos/gssapi authentication?
I installed it following instructions from digital ocean how-to-install-postgresql-on-ubuntu-20-04-quickstart:
% sudo apt install postgresql postgresql-contrib
I also did a 'show all' in psql and ...
2
votes
1
answer
2k
views
Nested AD group access not working when nested more than 2 levels deep?
For the setup of the security of the databases we have created a number of nested Active Directory groups:
Group
Members
Group type
RGP-EA_PROD-RW
RGP-SparxEA-RW
Domain Local Security
RGP-SparxEA-...
2
votes
1
answer
1k
views
PostgreSQL keeps asking for user password with "trust" authentication enabled
I created a user john with createuser and didn't supply any passwords for it, i.e. no -P option specified. I then proceeded to add the following line above all other lines in the pg_hba.conf file:
...
34
votes
1
answer
195k
views
What is mysql_native_password?
I was trying to set password for root. When I run:
mysql> SELECT * from mysql.user where User="root";
It shows:
+-----------+------+-------------+-------------+-------------+-------------+-------...
0
votes
1
answer
2k
views
Access denied for user 'me'@'localhost' (using password: NO)
I am am trying to learn mysql 101. Doing so, I broke my ability to login as root.
At first I could simply connect to mysql by running
sudo mysql
In an attempt to alleviate a problem, I ...
1
vote
0
answers
103
views
Saving multiple authentication strategies to the same database
I need some advice with the logic behind this authentication method.
I'd like my app to have multiple ways to create accounts:
email/pass
twitter
google
I can handle the email and password login ...
3
votes
2
answers
30k
views
sql server authentication login failed
I have SQL Server 2014 on my Windows Server 2012 R2. I can connect locally to SQL Server from Management Studio using Windows Authentication.
I decided to switch to SQL Server Authentication (...
0
votes
1
answer
1k
views
How to use BCP Utility queryout in a network path with crededential (login required) for SQL Server
I'm having a hard time figuring out on how can I export my selected table in a network path that requires login credentials.
'bcp "select ''StudentName'' UNION ALL SELECT StudentName AS ...
1
vote
1
answer
504
views
Can SQL Server OpenQuery/OpenRowSet to an LDAP Linked Server be used for Authentication?
I can fetch data back from LDAPS (port 636/3269) by first creating a Linked Server using sp_addlinkedserver and sp_addlinkedsrvlogin.
However, what I really need to do is to authenticate a Username/...
0
votes
1
answer
2k
views
PostgreSQL Linux PAM Authentication Error
I'm using PSQL version 12.5 on Ubuntu 20.04.1. My pg_hba.conf file looks like this:
# DO NOT DISABLE!
# If you change this first entry you will need to make sure that the
# database superuser can ...
0
votes
1
answer
1k
views
Active Directory authentication with SQL Server on Linux containers
I have a problem and hope someone can help me. I have SQL Server as docker container. I want our developers able to login in SSMS (SQL Server Management Studio) using their Active Directory users. I ...
-1
votes
1
answer
98
views
How to prevent starting of MongoDb 3.0.3 instance without "--auth" parameter?
I have a local Mongo database for which I have created users and authenticating through my code. But the authentication is only valid if mongo instance is run with "--auth" parameter.
If ...
0
votes
1
answer
1k
views
Execute SSIS procedure from stored procedure using non-privileged SQL login
I have a web app running on a different server that uses a SQL based login (not a windows based login) to connect to the SQL server. That app is calling a stored procedure that is located in a ...
0
votes
1
answer
246
views
Snowflake: how to allow only Key Pair Authentication connections?
Is there any way to configure Snowflake to allow only key pair authenticated users' connections?
At the moment you can add RSA_PUBLIC_KEY_FP to any user. But he can connect easily without specifying ...
0
votes
1
answer
4k
views
Connect DBeaver to PostgreSQL 13
I've been using PostgreSQL 10 and 12 on Windows successfully with DBeaver in the past. Now I've set up a new development machine and installed the current PostgreSQL 13.0.1 and the current DBeaver 7.2....
0
votes
1
answer
43
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 ...
0
votes
0
answers
43
views
Oracle DB Authentication Prioritization
If an Oracle authentication service has been configured, such as SecurID, does this mean that local users using Username/Password cannot use these credentials to login?
From this link it appears as ...
1
vote
1
answer
2k
views
Disable password policy for partially-contained database
I'm stuck in a situation where I need to create a new user for a partially-contained database (SQL Server 2016). The password is short, so I get an error:
Password validation failed. The password ...
0
votes
1
answer
1k
views
How can I add a user and specify a password for a in IBM Data Studio? [duplicate]
In Data Studio I can connect to a sever/database, go down to Users And Groups, right-click on Users and add a new one. But the program never asks me for a password. How can I specify it?
Also, no ...
0
votes
1
answer
136
views
Enabling TLS and TLS-MA simultaneously for different clients of a Oracle DB
We have a requirement where we want to enable TLS-MA for some of the clients connecting to a specific Oracle database while the other clients can continue to use TLS with server certificate.
We are ...
2
votes
1
answer
61
views
How to prevent misuse of rights in monitoring application?
I have a monitoring application that runs on the computer of each user in my organization. This application needs to insert some monitoring data in several tables of a database (MS SQL Server 2008 R2)....
0
votes
0
answers
1k
views
Bash Script Can't Connect to Azure Postgres using ENV Vars - "The Username should be in <username@hostname> format"
I have a bash script that exports ENV vars to use in connecting to an Azure Postgres DB (mydb.postgres.database.azure.com). For the user portion of that specifically it looks like this:
export PGUSER=&...
7
votes
1
answer
5k
views
"Corrupted key" error when creating/updating SQL Server 2012 credential for proxy account
Following a restart of a SQL Server 2012 SP3 instance caused by a reboot of the unresponsive host WINTEL server, I have a SQL Agent Log Shipping Copy job (which uses a proxy account to access the NAS ...
0
votes
1
answer
1k
views
pgBouncer - multiple servers with same username but different password
I have an active pgBouncer setup with one PostgreSQL server.
We are planning to add one more PostgreSQL server to the same pgBouncer. But the problem is that both databases servers have the same ...
1
vote
0
answers
520
views
Why is the authentication_string different from the other one if the passwords are the same?
I've set the same passwords for the following accounts: 'root'@'%', 'root'@'127.0.0.1'.
When I type select user, host, authentication_string from mysql.user I get different values for the ...
0
votes
2
answers
4k
views
Power BI report server: Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON' when trying to view a report
We have SQL Server 2019 and Power BI Report Server installed on the same host. we're using a virtual service account for Power BI Report Server. We get the following error when trying to view a report:...
4
votes
1
answer
447
views
Active Directory Name Change
Our Active directory will change the accounts name for example John Doe [email protected] to [email protected].
My question is do I need to change all the SQL Logins individually or the person can login ...
0
votes
1
answer
195
views
How to efficiently combine user authentication with token authentication?
What is the most efficient approach of authentication, considering an user based authentication system combined with a token based authentication system?
For this question please consider the ...
1
vote
2
answers
15k
views
Can't change authentication mode from Windows to both SQL Server and Windows
As the title suggests I'm having problems changing the authentication mode from Windows to both SQL Server and Windows mode in version 12.0.2. I have tried right right-clicking the server, go to ...
2
votes
1
answer
4k
views
On-premesis SQL Server setup for MFA against Azure AD
I am trying to set up multi-factor authentication in SSMS using an on-premesis SQL Server (Standard Edition). I believe the SSMS is simple enough. Under the "Login" tab, I have chosen &...
3
votes
1
answer
809
views
Cloned production SQL Server now Windows Authentication doesn't work
I needed to create a test environment for one of our applications that uses SQL Server as its data store. Our sysadmin cloned the existing production server to create the test server.
I can connect ...
4
votes
3
answers
3k
views
I am getting a failed login message in the SQL Server error logs however, nothing actually failed?
I have a server which runs third party software (called Visualcut) to email Crystal Reports to our users.
When I log onto the Visualcut Server, I can open the software and then preview a report. This ...
1
vote
1
answer
176
views
Default Schema Problems on server
When i connect to SSMS on my server through remote desktop and query my database using:
SELECT * FROM [sys].[database_principals] WHERE [principal_id] = USER_ID()
I am getting the correct results (...
6
votes
4
answers
18k
views
Re enable Windows Authetication in SQL Server [duplicate]
My old employee has disabled Windows Authentication in our server. Now I'm not able to access the SQL Server even though I have Administrator access to the server. I need to reset the sa password.
I ...
0
votes
2
answers
19k
views
Excel Data Connection to SQL Server using Windows Auth from untrusted machine
We have an Excel spreadsheet that uses a Data Connection to a SQL Server database. The database server is joined to our domain, and Windows Authentication is enabled.
Here is a sample of the ...
0
votes
2
answers
2k
views
Connect to a local PostgreSQL server using peer auth with pgAdmin
Context
I have a PostgreSQL server running on a remote machine, but I'm connected locally through VPN.
Its pg_hba.conf file is accepting peer auth for local connections;
local all ...
2
votes
1
answer
7k
views
MS SQL Login without password
I need to login to MS Sql from ODBC to my MS Sql instance on Linux server. Following are my question
Is there a way to do it without Active Directory (maybe with LDAP or ADLDS if it does not change ...
41
votes
3
answers
204k
views
Forgotten PostgreSQL Windows password
This morning I’ve been trying to connect the PostgreSQL database on my Windows 7 Professional desktop.
The default value is ‘postgres’, but sure enough I forgot what password I used when I originally ...