Questions tagged [authentication]
The process of identifying the party logging into a system.
44
questions
23
votes
4
answers
181k
views
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. ...
13
votes
5
answers
41k
views
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 ...
107
votes
2
answers
258k
views
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 ...
1
vote
1
answer
1k
views
Secure method beside phpMyAdmin for remote mysql
Recently, one of my centos linux servers was hacked and the cause of due to phpMyAdmin. It was said due to this problem PhpMyAdmin vulnerability CVE-2011-2505 (http://www.cve.mitre.org/cgi-bin/cvename....
41
votes
3
answers
203k
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 ...
25
votes
2
answers
97k
views
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 ...
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 ...
10
votes
4
answers
17k
views
SQL 2008 R2 creates user/schema when Windows user creates tables
We added a server login and database user that map a Windows Group to a SQL 2008 R2 instance using the following script, with the names changed for anonymity:
USE master
go
CREATE LOGIN [DOMAIN\...
10
votes
2
answers
19k
views
mysqladmin not taking inline password
I am trying to set a cron job for taking backup from my slave machine. So I need to stop the slave
I issued a command
mysqladmin --user=root --password=test_pass stop-slave
But it is throwing ...
5
votes
3
answers
11k
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 ...
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 ...
4
votes
1
answer
5k
views
Proxy authentication for PostgeSQL
The following seems likely to be a fairly common situation, but I haven't seen any solutions.
I have a PostgreSQL database containing views that are specific to the $user, in order to restrict data ...
3
votes
1
answer
41k
views
Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'. Reason: Token-based server access validation failed
As the title states, I'm getting the following error when attempting to use a ASP.NET webapp:
Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'. Reason: Token-based server access validation failed ...
3
votes
2
answers
2k
views
Cannot register SPN, error 0x80090350, state 4
This is my first time trying to configure kerberos. I need it for SQL Server.
Considerations
I'm running SQL Server 2008 R2 on Windows 2008 R2 server.
I have an Active Directory account for SQL ...
2
votes
1
answer
181
views
mysqladmin user account not secure?
I still playing with my own DB trying to learn and saw this:
I could change the root password without any problem at all... If I'm in the server I can create an algorithm to start testing password ...
2
votes
2
answers
3k
views
Any security related reasons to prefer Windows Authentication over Sql Server Authentication?
This is a rather short question:
When using Microsoft SQL Server (version 2005 and newer), are there any security related reasons to prefer Windows Authentication over SQL Server Authentication?
...
0
votes
1
answer
1k
views
How to know the Database user Login History from begining? [closed]
I need to know one particular user's login and logout database history from beginning in SQL SERVER 2005.
Can anyone help?
0
votes
1
answer
476
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....
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:...
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 - ...
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 ...
12
votes
1
answer
11k
views
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 ...
11
votes
3
answers
20k
views
Postgres connection access denied on IPv6 address
Installed PostgreSQL 9.1 x64 on Windows, set up a listen address, but when connecting with pgAdmin I get the following error. Not sure why PostgreSQL is seeing my IPv6 address and not my regular IP ...
8
votes
4
answers
2k
views
Is splitting a 'users' table for authentication purposes a good idea?
Suppose I have a user table in my site in which there are around 2-3 Million users (records) in the table.
For speeding up my login process, is it a good approach to split my user table, one for ...
7
votes
1
answer
28k
views
Windows Authentication for a non-local non-domain Login
I have SQL Server 2008 R2 installed on a Windows Server 2008 R2 box. There is no domain in the network.
Is there any way for me to add a Windows Login on SQL Server for a non-local and non-domain ...
6
votes
1
answer
3k
views
Connecting to SQL Server using cached credentials
While migrating from SQL authentication (user-password) to integrated security I ran into an unexpected combination of requirements.
SQL clients are services running under a LOCALSYSTEM or ...
6
votes
1
answer
7k
views
SQL Server and SSPI handshake failed error
Recently I faced an issue where users from one domain were unable to login to SQL Server and getting this error:
Error: 17806, Severity: 20, State: 2.
SSPI handshake failed with error code ...
6
votes
2
answers
53k
views
Grant table privileges to a user connecting from any host
I have a user account - let's call it 'wordpress' - that I need to allow to access a few catalog tables in another e-commerce database on the same server. I've configured the user with three host ...
5
votes
1
answer
9k
views
Connect to SQL Server using windows authentication from another PC without Active Directory
I have SQL Server 2008 R2 Express installed on a PC.
I have some other PCs that are connected to this PC on a local network.
Currently, those PCs connect to SQL Server using SQL Authentication, ...
5
votes
1
answer
12k
views
Create Linked Server to AlwaysOn Availability Group Listener
I have an alwayson availability group setup using SQL 2014 and Windows Server 2012 R2. There are 3 nodes in the group. The SQL Service is running as a Managed Service account on each node (1 MSA for ...
4
votes
1
answer
2k
views
Domain group hierarchical group membership and SQL Logins mapped to AD groups [closed]
SQL Version: Microsoft SQL Server 2005 - 9.00.4035.00 (X64)
Nov 24 2008 16:17:31
Copyright (c) 1988-2005 Microsoft Corporation
Standard Edition (64-bit) on Windows NT 6.1 (Build 7601: ...
4
votes
2
answers
3k
views
Secure way to connect: Windows Authentication or SQL Server Authentication and why?
Which is the best way to create a connection string for SQL Server?
Should I be using a trusted connection string (windows authentication) or an untrusted connection string (sql server authentication)...
4
votes
1
answer
8k
views
postgres and passwordless authentication
We have users for out postgres database and none have passwords... Do not know the history behind it.
When I try to use clients to connect to these databases, for instance, pgadmin III, the ...
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 ...
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 ...
3
votes
1
answer
12k
views
What's the procedure to set up username/password on mongodb?
I have tried setting up username / password .But none of the methods seems to work.
1. In mongod.conf ----> remove **#auth=true** to **auth =true**
2.Started the mongod server --> sudo service ...
3
votes
1
answer
9k
views
PostgreSQL: Using the .pgpass file
I have been reading up on the .pgpass file, but I can’t get it working for me.
My .pgpass file looks something like this:
127.0.0.1:5432:accounts:fred:p@55w0rd
I set the privilege to 0600 (this is on ...
2
votes
1
answer
2k
views
When upgrading config servers to use WireTiger, the running config server with wiredtiger does not authenticate the existing pass and user?
In order to upgrade mongodb to 3.0.0, I am upgrading my config servers to use WireTiger. I followed the subsection of Change Config Server to Use WiredTiger. There are 18 steps. I run mongodump --port ...
2
votes
1
answer
12k
views
How to run stored procedure in another database on the same server using a different login?
I have 2 databases (A and B) on the same server. Database A has user ua defined, and database B has user ub defined.
I have a stored procedure in A, running as ua, that needs to run a stored ...
2
votes
1
answer
620
views
Why does OS login not exist in the user table, but I can still login to MySQL?
mysql> select user, password, host from user;
+------+----------+---------------------------------------------+
| user | password | host |
+------+----------+-...
2
votes
1
answer
747
views
MariaDB multiple auth modules for a user?
MariaDB has pluggable authentication, like PostgreSQL. Unlike PostgreSQL, I can't figure out how to support two forms of auth for a user. For instance, in PostgreSQL we can have the following in our ...
1
vote
3
answers
13k
views
SSRS Reports Manager Security Configuration
I happen to be setting up a reporting server at work from scrach. Having very little almost no experience of sql server administration I am finding it really difficult to configure the security ...
1
vote
1
answer
3k
views
Error in login in with root user in new mysql server
I've installed a MySQL server in CentOS 6.2 machine
+-------------------------+---------------------+
| Variable_name | Value |
+-------------------------+---------------------...
1
vote
2
answers
2k
views
Mysql master-master permission replication issue
I came to know it's safe to replicate mysql database to have the users and permissions replicated, from a post in ServerFault is-it-ok-to-replicate-mysql-db. I have setup master-master replication ...