Questions tagged [authentication]

The process of identifying the party logging into a system.

Filter by
Sorted by
Tagged with
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. ...
Just a learner's user avatar
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 ...
statichippo's user avatar
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 ...
stergosz's user avatar
  • 1,195
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....
newbie14's user avatar
  • 969
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 ...
AKIWEB's user avatar
  • 605
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 ...
Christopher Garcia's user avatar
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 ...
Racer SQL's user avatar
  • 7,376
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\...
flipdoubt's user avatar
  • 223
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 ...
Praveen Prasannan's user avatar
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 ...
yigitt's user avatar
  • 153
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,787
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 ...
beldaz's user avatar
  • 1,690
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 ...
Nathan C's user avatar
  • 167
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 ...
Eduard Ramos's user avatar
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 ...
jcho360's user avatar
  • 1,999
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? ...
MicSim's user avatar
  • 2,481
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?
user51936's user avatar
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....
Marcello Miorelli's user avatar
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:...
Robert's user avatar
  • 695
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
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 ...
Ben Collins's user avatar
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 ...
Silvano González's user avatar
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 ...
Raffian's user avatar
  • 215
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 ...
Alireza's user avatar
  • 3,636
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 ...
user avatar
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 ...
Jirka Hanika's user avatar
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 ...
SQLPRODDBA's user avatar
  • 1,908
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 ...
db2's user avatar
  • 9,658
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, ...
Navaneet's user avatar
  • 913
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 ...
Greg's user avatar
  • 3,242
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: ...
diegohb's user avatar
  • 151
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)...
ravi's user avatar
  • 143
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 ...
reza's user avatar
  • 143
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 ...
pgunston's user avatar
  • 665
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
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 ...
Nikhil's user avatar
  • 31
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 ...
Manngo's user avatar
  • 2,819
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 ...
BAE's user avatar
  • 259
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 ...
Alex Pulver's user avatar
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 | +------+----------+-...
qazwsx's user avatar
  • 3,447
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 ...
Evan Carroll's user avatar
  • 62.9k
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 ...
M.Ali's user avatar
  • 1,960
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 | +-------------------------+---------------------...
thitemple's user avatar
  • 113
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 ...
user53864's user avatar
  • 165