Questions tagged [authentication]

The process of identifying the party logging into a system.

Security has two basic components: authentication and permissions. Authentication deals with verifying that the entity logging onto the system is who they claim to be and permissions associate various allowable actions with that entity.

Authentication can get its credentials from a number of sources. In some cases a login and password must be provided. Two factor authentication systems require something from a physical token (common on on-line banking systems) or possibly biometric information such as a fingerprint (sometimes used on laptop computers) in addition to the password.

For convenience, some authentication systems such as Kerberos manage authentication centrally through an authentication server that is trusted by other machines. The authentication server has a list of machines or services that can request login tokens, along with credentials that those machines can use to demonstrate the authenticity of requests for session information.

On login to the authentication server, an ephemeral 'session' token is issued that can be presented for authentication on other systems through a secure protocol. The authentication server will then supply details of the login credentials associated with the token. The authentication protocol also has a secure mechanism by which the servers requesting session credentials can validate themselves to the authentication server, which prevents the session token from being leaked by spoofing an authentication request.

The most widely used implementation of Kerberos is Microsoft's Active Directory.

347 questions
110
votes
2 answers

Connect to SQL Server with Windows Authentication in a different domain

I am trying to connect to a remote SQL Server on a VPN in a different domain. When I enter the Server name on the SQL Server and choose Additional Connection Parameters to add some extra stuff needed by my school: Integrated Security=SSPI; User…
stergosz
  • 1,225
  • 2
  • 10
  • 7
43
votes
3 answers

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 installed it. I have googled and found a post…
34
votes
1 answer

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…
d a i s y
  • 443
  • 1
  • 4
  • 7
31
votes
7 answers

Access denied for user 'root'@'%'

I used to access the root user in MySQL just fine. But recently, I am no longer able to. I am able to login fine : mysql -u root -p Here is the mysql status after login : mysql> status -------------- mysql Ver 14.14 Distrib 5.5.28, for…
jules testard
28
votes
3 answers

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: "mongoadmin" , pwd: "mongoadmin", roles:…
Robert
  • 705
  • 3
  • 12
  • 20
25
votes
2 answers

How can I get my linked server working using Windows authentication?

I'm trying to get a linked server to ServerA created on another server, ServerB using "Be made using the login's current security context" in a domain environment. I read that I'd need to have SPNs created for the service accounts that run SQL…
23
votes
4 answers

MySQL error: Access denied for user 'a'@'localhost' (using password: YES)

I use the root account created the account 'a'@'%'. But I can't use the account to connect to MySQL server when I specify the host parameter. I can successfully connect without the -h parameter. Please see the transcript below. I hope someone can…
Just a learner
  • 2,082
  • 7
  • 36
  • 57
21
votes
2 answers

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 - decided without telling me, to rename said box. after…
21
votes
2 answers

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 myuser md5 I restarted PostgreSQL with sudo service…
Daniel
  • 327
  • 1
  • 2
  • 7
21
votes
5 answers

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 IP to the firewall rules so I could connect to…
Ben Collins
  • 312
  • 1
  • 2
  • 9
15
votes
12 answers

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 English) and I had to shut down our servers. Looking for…
Racer SQL
  • 7,546
  • 16
  • 77
  • 140
13
votes
5 answers

Audit logins on MySQL database

Is there a way to audit logins to MySQL? I'd like to be able to create a username for each employee and thereby create an audit trail of logins. However, googling has turned up no good results. The more we can audit, the better. At the very least,…
asbestossupply
  • 295
  • 1
  • 3
  • 6
13
votes
1 answer

How to prevent a login from 'listing' a table or view definition in PostgreSQL?

Is there a way to prevent a login from listing the tables and columns in a schema? I have to give access to a remote login to query on a single view; however, I also must make sure that such login cannot list every object on that schema. Is there…
12
votes
7 answers

SQL Server 2012 Can't log in with machine account

We're migrating an IIS/SQL Server site from 2008 to 2012, and I'm having a problem with authentication. We use Windows Authentication to authenticate as DOMAIN\COMPUTER$, but this isn't working, giving an error saying: Login failed for user…
alt
  • 241
  • 1
  • 2
  • 7
12
votes
3 answers

Cannot log in using SA with SQL Authentication

I can not log in to SQL Server 2008 using SQL Server authentication. I can only log in using Windows Authentication Mode. I chose only defaults while installing SQL Server 2008 R2.
khan
  • 121
  • 1
  • 1
  • 3
1
2 3
23 24