Skip to main content

Questions tagged [authentication]

The process of identifying the party logging into a system.

Filter by
Sorted by
Tagged with
5 votes
1 answer
8k views

Postgresql cannot peer authenticate using usermap (provided user name (^dbuser^) and authenticated user name (^sysuser^) do not match)

I am trying to peer authenticate some users using usermap. What I am trying to do is to map user mailreader as you can see: postgres=# \du List of roles Role name | ...
Dimitrios Desyllas's user avatar
3 votes
1 answer
21k views

AWS RDS Postgres pg_hba.conf auth-method

I'm starting to use Amazon Web Service's Relational Database Server product (AWS RDS) and want to confirm I have not made a security blunder. My configuration: Postgres Publicly accessible Inbound ...
Peter L's user avatar
  • 151
21 votes
2 answers
77k views

The certificate chain was issued by an authority that is not trusted

some time ago I installed SQL server 2016 developer edition on a windows 10 home edition environment (a laptop to be precise) and everything was fine. then someone - an administrator on the box - ...
Marcello Miorelli's user avatar
4 votes
1 answer
2k views

SSMS connections not using KERBEROS over VPN - why?

I have a very simple setup. SQL Server X (2012) and SQL Server Y (2016). X has a linked server to Y using the setting "Connections will: Be made using the login's current security context". SPNs are ...
SomeGuy's user avatar
  • 2,013
2 votes
1 answer
2k views

Access Control not logging successful logins on MongoDB 3.4 Community

After adjust the verbosity of the parameter "accessControl" with the command: db.setLogLevel(5,"accessControl") The log file still not login successful login. On mongo 3.2: 2017-04-20T15:56:06.661+...
Jeferson Santana's user avatar
2 votes
0 answers
124 views

Quite possibly a stupid and long authentication question

First off, I am not remotely a DBA. But I'm basically responsible for the application and we don't have a DBA, so here I am. There's two separate errors that may be related but occur at separate ...
XavierMace's user avatar
3 votes
2 answers
577 views

SQL Server 2008 Authentication mode changed on its own

This morning we experienced an issue where our production server seemed to decide to change from Mixed authentication mode to Windows only authentication of its own volition. I was curious to know if ...
agpoweredmg's user avatar
1 vote
1 answer
312 views

Using Mixed mode authentication to authenticate Active Directory users to an application

I have a vendor supplied application that I have very limited access to change. The application controls a machine, and cannot easily be logged off between users (expect up to 5 user changes per hour)...
Blaine's user avatar
  • 13
1 vote
0 answers
38 views

Switch Between Windows Authenticated Users On Single Windows Account

We have a CRM that has been developed in house in Microsoft Access 2003. We are also in the process of moving from an MS Access backend to a SQL Server backend. I have been researching different ...
Elias's user avatar
  • 169
1 vote
1 answer
834 views

Error with pgAdmin III and pg_hba.conf

I have a problem with my Pgadmin3.. I used to use the last year, but this year I can't connect with the localhost server with pgadmin This is the message error: FATAL: no pg_hba.conf entry for host "...
Lucuano Alzugaray's user avatar
1 vote
1 answer
441 views

Auditing authentication issues in a distributed environment

I'm trying to get a better handle on what locked out a specific user when multiple Oracle databases are involved using database links. Setup: sqlplus kjohnston@db2 create user testuser identified ...
Kris Johnston's user avatar
1 vote
0 answers
25 views

Mysql+auth plugin - logging external username

When using an an auth plugin (specifically pam) does the general query log record the external username for connections?
symcbean's user avatar
  • 339
0 votes
1 answer
49 views

Why can hr create an Oracle DB session though not using PWFILE?

I have created a database. HR schema has been enabled. connect / as sysdba is known as operating system authentication. connect hr/password is not operating system authentication right ? If yes, I ...
user118627's user avatar
12 votes
2 answers
3k views

Configure unconstrained delegation for BULK INSERT

I have a pair of Microsoft SQL Server 2016 nodes in an Always On Availability Group. I am trying to perform a BULK INSERT (using a SQL Server 2016 Management Studio query) on a file located on a ...
Muh Fugen's user avatar
  • 221
9 votes
2 answers
33k views

How to get psql to prompt for a password with the superuser postgres?

I'm using PostgreSQL 9.6.2 on Windows 7 and when I start psql from the command prompt with: psql -U myusername it asks for a password just fine and logs in. However if I do: psql -U postgres it'...
pazeltov's user avatar
1 vote
2 answers
406 views

postgres authentication external

I have to implement some safety authentication rules on postgresql DB with a windows server. For example, rules may be "users not used for a period longer than three months will be locked" or "...
Gian Piero's user avatar
0 votes
1 answer
1k views

Enable user authentication in Mongo DB

We are at Mongo 3.2. We deployed our first app with mongo without user authentication in db schema. Now we want to enable authentication at db level but want to avoid application downtime doing the ...
viren's user avatar
  • 511
12 votes
3 answers
2k views

Determine whether mixed mode auth is enabled without logging in?

Is it possible in SQL Server to determine whether mixed mode authentication is enabled without logging on to SQL Server?
Jez's user avatar
  • 695
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 ...
SQLServerVillain's user avatar
5 votes
3 answers
12k views

Connect to sql server with windows authentication in different domains

I get we have two options while connecting to remote SQL Servers or other domains with Windows authentication: runas /netonly method adding windows credentials But doesn't Windows authentication ...
yigitt's user avatar
  • 153
1 vote
1 answer
443 views

Using linked server from Windows 10 PC [closed]

I have been using SQL Server linked servers for years, and they have been working fine. But now when I try to run a query (on a machine with Windows 10) using linked server I get this error: Login ...
Stewen's user avatar
  • 11
0 votes
2 answers
114 views

Restored DB to Dev and test environments, now user can not login

I took a backup of our production database and restored it to both the test and development environments last night, but this morning a single user is not able to login to the test/dev DBs. I can go ...
Matthew Verstraete's user avatar
2 votes
2 answers
6k views

Oracle 12c: Password File Questions

For one of my assignments I have been attempting to demonstrate password file functionality. However, I have run into some unexpected behaviors. I have tried searching around for answers but can't ...
Stazz's user avatar
  • 45
2 votes
1 answer
415 views

Oracle DB Security Issue: Anyone can login using SQL*PLUS, with any username, and any wrong passphrase

I'm using Oracle DB 11g-R2 on CentOS 6.4, and unfortunately there is a terrible issue freaking me out. Anyone can login using SQL*PLUS, with any username, and any wrong passphrase. Consider somebody ...
Parsa Samet's user avatar
1 vote
1 answer
197 views

Does DB2 LUW v10.5 Support Windows Authentication and How is it Set?

We have a DB2 LUW v10.5 FP1 Express Edition. Can someone please confirm that this database supports Windows Authentication over the network (and if so, kindly provide some steps to do it) or does it ...
dbakuno's user avatar
  • 11
0 votes
1 answer
886 views

How to Enable Windows Authentication in Firebird 2.5

I am trying to enable Windows Authentication on a remote Firebird 2.5 database. I modified the Firebird config file and changed the authentication method to 'MIXED', restarted the Firebird services ...
dbakuno's user avatar
  • 11
3 votes
1 answer
835 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 ...
Jeff's user avatar
  • 505
1 vote
1 answer
73 views

MySQL Authentication Error After Re-applying the mysqldump after an upgrade

After upgrading from a lower version of MySQL 5.5.* to MySQL 5.5.52, after reapplying the mysqldump that I took before the upgrade, I am receiving the following error: Authentication to host '...
contactmatt's user avatar
1 vote
1 answer
1k views

Will changing a MySQL user's password break existing connections?

If I update a user's password or privileges in MySQL, how does this affect existing connections? In particular, if I change the replication user password, will it break replication for connected ...
augurar's user avatar
  • 141
1 vote
0 answers
70 views

Connection to Reporting service fails in SQL Server 2012

I am trying out Form authentication in Reporting Service to work. But not successful. The problem is I can't connect to report server both from Management Studio and Report Manager. Actually I am ...
LittleBirdy's user avatar
1 vote
1 answer
141 views

Windows authentication only

I'm busy installing MSSQL 2016, and strongly considering using Windows Auth only. That can interfere with no local installation, but it has occurred to me that if another machine or process wanted to ...
ProfK's user avatar
  • 404
4 votes
2 answers
27k views

Using postgres database from another computer

I have PostgreSQL version 9.5 installed at my machine (Windows 7 Enterprise x64 bit version). I have several databases in schema 'public'. I would like to use/access one of these databases from ...
Jibran Khan's user avatar
1 vote
0 answers
137 views

When mirroring accounts for Sql Server Windows Authentication, do both have to be local?

I understand that when using windows authentication to connect to a remote SQL Server instance, two local accounts with the same username and password can be used (i.e. "mirrored" local accounts). ...
Ronnie's user avatar
  • 245
0 votes
1 answer
264 views

sql auth vs nt auth in SQL server

Ok, so everything I read says best practice is to us NT authentication in SQL server. And I can see some advantages to that but using NT auth how do I force users to access the data using only my ...
rbarc's user avatar
  • 1
1 vote
1 answer
67 views

Managing Security for a Log Shipped db across two (unconnected) domains

SQL Server 2008 (soon to be 2012). We have a vendor that is providing us with log shipped backups of our production database. We use this log shipped database for BI staging, reporting, etc. I've ...
paulbarbin's user avatar
2 votes
1 answer
19k views

Windows Authentication fails with "Cannot generate SSPI context"

We have a Windows Server 2012 with SQL Server 2012 instance. Its services used to run under an Active Directory account from an old domain, from Windows 2000 Server. A few years ago we replaced our ...
Hikari's user avatar
  • 1,553
3 votes
1 answer
3k views

SQL Server, connecting without windows authentication?

I am confused about how this works: I was reading the SQL Server documentation on authentication here: Choose an Authentication Mode It says: Windows Authentication is always available and cannot be ...
Jose V's user avatar
  • 165
3 votes
1 answer
863 views

What sort of SPN / AD Computer Delegation do you need for delegation of credentials to a linked server that connects to a file share?

The idea here is to perform a double hop and delegate the credentials of the client ([email protected]), that have been sent to the SQL2.example.org server to SQL3.example.org (admittedly this is ...
leeand00's user avatar
  • 1,712
1 vote
1 answer
11k views

psql: FATAL: password authentication failed for user "GuardDog_02"

In postgresql 9.5.1, I created a user called GuardDog_02. I gave it a password. And I gave it permissions to create db and user: CREATE USER GuardDog_02 WITH PASSWORD 'apple100' CREATEDB CREATEUSER; ...
Daniel Viglione's user avatar
0 votes
1 answer
3k views

The target principal name is incorrect. Cannot generate SSPI context

When attempting to log on to a SQL Server that lives on a different domain, I get the following error: The target principal name is incorrect. Cannot generate SSPI context. I am using Windows ...
Neil P's user avatar
  • 1,274
7 votes
1 answer
1k views

SQL Server 2008R2 Alias not working

I have an interesting situation here. We're basically trying to migrate some SQL Server infrastructure to new hardware, and one of the boxes (single-instance, 2-node cluster) is running 2008R2. The ...
NateJ's user avatar
  • 804
-1 votes
1 answer
2k views

Login failed for user sa, Error 18456

I have just installed SQL Server 2014 Developer Edition. I started SQL Server instance on Configuration Manager, with Log on as LocalSystem feature, because it is the only option, which isn't caused ...
plaidshirt's user avatar
20 votes
2 answers
81k views

psql: FATAL: Peer authentication failed for user

I just installed PostgreSQL 9.4 on Ubuntu 15.10. I created a user with createuser -P myuser I created a database with createdb -O myuser mydatabase I edited pg_hba.conf and added local mydatabase ...
Daniel's user avatar
  • 317
5 votes
3 answers
4k views

Who is the person using a SQL login?

Is it possible to find out who used a SQL-Server login? Let's assume we suspect a person to abuse a SQL login that is supposed to be used by an application only to logon to SQL-Server. Is the domain ...
Magier's user avatar
  • 4,797
1 vote
1 answer
5k views

How to disable all password requirements in Oracle?

When I try to create a new database using DBCA it stops me because my password isn't complex enough. I am working with Oracle in a VirtualBox VM on my own laptop, so I don't need the password ...
Dave's user avatar
  • 121
4 votes
2 answers
10k views

Using a Different Windows Account for Invoke-Sqlcmd

I'm attempting to make a Powershell script that needs to interact with SQL Server, so part of the script will involve invoke-sqlcmd. However, the script can't be scheduled as a job in SQL Server and ...
Dylan Bacon's user avatar
0 votes
1 answer
162 views

SQL Server 2014 Authentication

I recently installed SQL Server 2014 in my machine. I configured my user and provided high level access for the same. While connecting through SSMS 2014; if I choose 'Windows Authentication', I can ...
Kavin's user avatar
  • 1
1 vote
1 answer
5k views

How to pass credentials to a linked server in another domain?

I am trying to link two SQL Servers (2008R2 and 2014) which are running in two separate (!) Active Directory domains. The problem is that I can login into the remote server only with a Windows ...
SQL Police's user avatar
1 vote
0 answers
870 views

admin user creation is giving error in mongodb 3.0

I am trying to create admin user in mongoDB and it's giving me following error. MongoDB 3.0 version is being used. Error : 2015-12-10T15:23:47.065+0000 E QUERY Error: couldn't add user: Could not ...
Nikunj Shukla's user avatar
1 vote
2 answers
4k views

Azure SQL Database "Login failed for user" contained users.

I'm having a similar issue to this question (https://dba.stackexchange.com/posts/123094/edit)! I have followed the following article: https://azure.microsoft.com/en-gb/documentation/articles/sql-...
Stephen Neal's user avatar

1 2 3
4
5
7