Questions tagged [authentication]
The process of identifying the party logging into a system.
285
questions
0
votes
0answers
8 views
Authentication failure in parent child SSIS packages
I'm troubleshooting an issue for our developers.
A web app using windows authentication calls a stored procedure that executes an SSIS package. The SSIS package uses an "Execute Package Task," to ...
0
votes
1answer
19 views
db2 expired password but cannot reset
Has anybody encountered this problem with a db2 server? I'm running a development database and connecting to the database gives me a password expired error. Trying to reset it will give me an invalid ...
0
votes
0answers
11 views
Postgresql 10: Ldap authentication failing
I configured the pg_hba.conf of Postgresql 10 with following
host Tom Tom XXX.XX.XXX.XX/32 ldap ldapserver=XX.XX.XXX.XX ldap ldapbasedn="ou=People,dc=example,dc=com" ldapbinddn="cn=Tom,ou=People,...
0
votes
0answers
9 views
LDAP Authentication failing on Postgres9.1
Can any one please suggest what need to be done to make the LDAP authentication work on PostgreSQL 9.1. I am getting the below message
invalid authentication method "ldap": not supported by this ...
0
votes
0answers
10 views
Can't login into MariaDB slave servers
I have set up a master and a slave for MariaDB using the Bitnami docker image. The replication seems going smoothly:
MariaDB [(none)]> show processlist;
+-----+-------------+--------------------+--...
0
votes
1answer
31 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 ...
0
votes
0answers
18 views
Cannot connect to SQL Server DB instance using inetegrated Security [duplicate]
We are on SQL Server 2012(SP4) 11.0.7001.0(X64) Standard Edition(64-bit)
In one of our production servers we cannot connect to the instance using Windows Authentication- getting this error:
"The ...
0
votes
1answer
59 views
Can I connect to the database as the user “dbo”?
If not, why?
During security audit we are being asked if the dbo login is interactive. My understanding is that the account is automatically created and managed by SQL server itself and is not ...
0
votes
2answers
22 views
Postgresql - roles without linux accounts?
Basic question:
what I'm reading describes how to create linux users in parallel with postgresql roles.
However, I don't see the value in creating any of these users in linux - I just want to create ...
2
votes
2answers
49 views
How to find out all the permissions that belong to a specific server/ database role in SQL Server? [duplicate]
I can separately query all the server or database level permissions, but I want to know other thing. What server role do the given permissions exactly belong to? For example I want to see all the ...
1
vote
0answers
21 views
How does Oracle authenticate a user?
I'm learning Oracle and below is my testing of starting up an Oracle instance and make the database available.
oracle:[~]$ sqlplus
SQL*Plus: Release 19.0.0.0.0 - Production on Mon Aug 5 09:29:30 ...
1
vote
1answer
69 views
Windows Login can't access SQL Server even with SYSADMIN role
I'm working on AD permissions and have removed my user account from the Domain Admins security group. Now I'm having difficult accessing my SQL Server database with my Windows login. The login is in ...
0
votes
1answer
47 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 ...
-3
votes
1answer
176 views
The login is from an untrusted domain and cannot be used with Windows authentication
I am facing this issue after trying to run a Windows application on sharing client side in a workgroup environment, while this application working on server machine fine.
0
votes
1answer
103 views
Postgresql 11 SSPI authentication failing
On windows 2016 in AD setup when I try to use SSPI with postgresql 11 and following settings :
pg_hba.conf:
host all all 127.0.0.1/32 sspi map=newmap #IP4
pg_ident.conf:
newmap ...
1
vote
1answer
36 views
Disallow superusers and single-user mode in POSTGRESQL
I have a doubt about superusers and single-user mode.
I want to restrict the access to a certain database, in a way that only those users which I gave privileges can see the structure of my database....
0
votes
1answer
28 views
differences in the authentication scheme - could it be because of Kerberos?
I am using this script to check the connections to my sql server:
select
C.client_net_address,
S.host_name,
c.session_id,
c.net_transport,
c.protocol_type,
c.auth_scheme,
s.program_name
from sys....
1
vote
0answers
47 views
Cross Domain log shipping not working
I know there are many blog posts similar to this, and I have read them all and as far as I can tell things are setup correctly, but I still get invalid username or password when kicking off the copy ...
1
vote
1answer
27 views
MySQL change user login from one plugin type to another
I'm in the process of testing MySQL 8.0.
I have set up a test database, and the first thing I want to do is import my user account from MySQL 5.7.
So to do this I run:
/*ON MySQL 5.7*/
SHOW CREATE ...
1
vote
1answer
75 views
How to identify a Windows Remote Desktop user by SQL Server session id?
In SQL Server I've got the session id of a process that is blocking other processes. Now I'd like to identify the specific user or machine that causes this blocking. The users are authenticating using ...
0
votes
1answer
22 views
Should i place Registered-Users Info in every table? to Restrict user access to his Own Data only
Database: Relational Database - MySQL
I am making a database with multiple tables. In order to see his data from tables, User will need to log in. I only need to display those information(through web-...
0
votes
1answer
685 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
&...
10
votes
2answers
881 views
Locked my sa user out
So I was trying to change some settings in my Microsoft SQL Server Management Studio 2019. I change the login mode from mixed (Windows and SQL authentication) to only Windows and now I am not able to ...
1
vote
1answer
67 views
Question on Enabling Kerberos Authentication using SetSPN for Availability Listener alternative DNS name
We have Availability Group, and original DNS name that was given to AG Listener, is too long (something like longername-Listener-01.mydomain.com); Its hard for us to change original DNS name of ...
0
votes
2answers
34 views
ssms does not let me change to server authentication mode and I can not log in
I have been using SSMS and logging in through server authentication for a week now and yesterday when I tried to login it suddenly told me "no process on the other end of the pipe".
I researched ...
0
votes
0answers
116 views
Authintcation error 28000 + 18456
I have been trying to link my mssql database to Django. When I run the Django server I get the error below. For normal query (out of Django), it works fine, however, the Django doesnt even connect. ...
0
votes
1answer
60 views
SQL Server Authentication
I am able to access a database using the Windows Authentication method in DBeaver. However, when I switch to different account in Windows and I would like to access the datebase, I used SQL Server ...
0
votes
0answers
21 views
SSIS DB issues when trying to run Package from SSISDB to getch ADO directoty users list
I am working on task that involves using Dev server to fetch ADO directory user information. I am connecting through SQL script i Script task and passing my User authentication. This is working fine ...
0
votes
2answers
174 views
Attempting to backup to remote NAS but access is denied
I was attempting to use Ola Hallengren's scripts to backup to a remote NAS, but it was failing and not giving any direct errors, so I tried doing it manually using Server Management Studio and got the ...
3
votes
0answers
210 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, ...
1
vote
1answer
31 views
Source of Entry in Postgres
I want to make a small web app using Postgres as database.
Is there a way to accept database access if and only if the SQL command is coming from my app, blocking any other access to the database?
1
vote
0answers
96 views
SSRS Azure SQL Database Active Directory - Universal with MFA
Does anyone know when support for Active Directory - Universal with MFA will be included in Reporting Services?
It's available in SSMS.
Visual Studio 2017 Data Source Properties
Reporting Server ...
0
votes
0answers
29 views
Authenticate Oracle Users (DBs on Linux Servers) through AD Without Buying Any New Products
We are wanting to authenticate Oracle Users (DBs on Linux Servers) through Active Directory Without Buying Any New Products. We don't want to buy any Oracle products such as OID/OUD etc.
1.) Is there ...
1
vote
2answers
387 views
Disable / bypass authentication in PostgreSQL
I need to run benchmarks (pgbench) in different environments on different versions of PostgreSQL. Authentication works inconsistently and is a generally huge headache / adds a lot of fragile ...
0
votes
0answers
107 views
.Net Connector -Authentication error - Reading from the stream has failed
We have recently found too many Authentication Errors in our application. It is not continuous, however it appears multiple times in a day and gets stuck. We are having ASP.Net Application hosted on ...
1
vote
1answer
69 views
Can I query from two databases if my web application is connected to one database?
I have a local database, DB1, that I created and is connected to my web application. My web application takes in stored procedures from DB1 and queries them. My application connects to SQL Server ...
0
votes
1answer
36 views
Am I on the right track for a customer user login database design?
I am designing a back end database that will handle registration and login. I need to be able to deal with different account and authentication types.
The main issue here, that is different from ...
0
votes
1answer
50 views
How to use mysql_plugin utility?
I tried to follow this official documentation to install unix_socket plugin using mysql_plugin utility but getting an error that
Cannot read plugin config file unix_socket. Bad format in plugin
...
1
vote
0answers
62 views
sys.login_token doesn't include particular windows groups while they can be listed by sys.database_principals
When I query
SELECT principal_id, name, [type]
FROM sys.login_token
I found some local windows groups were not there.
However, when I check by
SELECT principal_id, name, [type]
FROM sys....
0
votes
1answer
562 views
How to get Kerberos working against a named SQL Server instance in Power BI Report Server?
I have a Power BI Report Server working perfectly connecting to SQL Server machines with a default instance only. I can also connect to SSAS named instances with the proper SPNs and by allowing ...
0
votes
1answer
182 views
Percona PAM with AD authentication using SSSD
I have installed percona PAm plugin on my Percona server as shown below:
mysql> show plugins;
...
| auth_pam | ACTIVE | AUTHENTICATION | auth_pam.so | GPL |
| ...
1
vote
0answers
167 views
Which client authentication methods make sense when calling `initdb`?
Postgres offers many client authentication methods:
Trust Authentication
Password Authentication
GSSAPI Authentication
SSPI Authentication
Ident Authentication
Peer Authentication
LDAP Authentication
...
1
vote
2answers
451 views
How to Disable Windows Authentication in SQL Server
I would like to say that as per my Organization requirement they want to Disable Windows Authentication in SQL Server.
My Environment is as follows:-
1) Microsoft Azure
2) Windows Server 2016
3) ...
0
votes
1answer
195 views
Running loadjava with Windows authentication
I want to run following command under Windows with Oracle Database 12c installed:
loadjava -force -genmissing -r -user username/password@database -verbose core-1.7.jar
The problem is that I use ...
1
vote
1answer
264 views
How to verify if given user@host with 'password' exists in MySQL 8.0+?
I write sanity check script for an application. One of the tests is supposed to verify that a given user@host with 'password' exists in MySQL. I'm using simple native hash passwords. In MySQL5.7- ...
1
vote
1answer
461 views
Can the new “SCRAM-SHA-256” password authentication mechanism in Postgres 10 and later work with any JDBC drivers?
Postgres 10 added support for a new password authentication mechanism, Salted Challenge Response Authentication Mechanism (SCRAM-SHA-256, see RFC 7677). Discussed by Michael Paquier.
➥ Can this ...
0
votes
1answer
364 views
Can `listen_addresses` system configuration setting in Postgres stop pre-authentication exploits?
You can set various configuration parameters for Postgres by either editing the postgresql.conf file manually or by calling ALTER SYSTEM commands.
One of those config settings is listen_addresses. ...
1
vote
2answers
2k 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 ...
0
votes
1answer
30 views
Integrated Authentication vs? [closed]
my coworker and I had a debate and I am looking for Reddit to resolve it! We have PHP web apps running on IIS and are looking to setup the security to the database using one approach:
-What would you ...
0
votes
2answers
65 views
Where is the cache for the MySQL caching_sha2_password auth plugin stored?
Where is the cache for the new default authentication plugin caching_sha2_password in MySQL 8 stored? I want to know for future reference how to clear it in case I ever run into any problems using it.
