Skip to main content

Questions tagged [authentication]

The process of identifying the party logging into a system.

Filter by
Sorted by
Tagged with
107 votes
2 answers
260k 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
42 votes
3 answers
206k 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
  • 615
34 votes
1 answer
201k views

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 shows: +-----------+------+-------------+-------------+-------------+-------------+-------...
d a i s y's user avatar
  • 443
31 votes
7 answers
195k views

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 -------...
user avatar
28 votes
2 answers
168k 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
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
23 votes
4 answers
182k 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
21 votes
5 answers
45k 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
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
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
15 votes
12 answers
187k 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,386
13 votes
5 answers
42k 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 ...
asbestossupply's user avatar
13 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
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
12 votes
3 answers
21k 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
  • 225
12 votes
3 answers
56k views

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's user avatar
  • 121
12 votes
7 answers
39k views

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, ...
alt's user avatar
  • 241
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
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
10 votes
4 answers
20k views

Mongo authentication user can't drop database

my question is - is it possible to define user in the Mongo database who will be able to drop the database? Maximum user privilege is "dbAdmin" but that privilege doesn't allow users to drop the ...
elBastarde's user avatar
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
2k 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 ...
Nano's user avatar
  • 139
10 votes
2 answers
8k views

Using host names in `pg_hba.conf`?

According to the PostgreSQL documentation: A host name specification that starts with a dot (.) matches a suffix of the actual host name. So .example.com would match foo.example.com (but not ...
Jacob Sparre Andersen's user avatar
9 votes
4 answers
36k views

MYSQL ERROR 2049 (HY000): Connection using old (pre-4.1.1) authentication protocol ref used (client option 'secure_auth' enabled)

when I tried to restore all database dump which is in 5.0 version to 5.6 version, it got restored and after that when I tried to reconnect, am getting the following error ERROR 2049 (HY000): ...
Praveen Prasannan's user avatar
9 votes
1 answer
21k views

Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'. (MsDtsSrvr)

I have a clustered environment which has many instances in it. I have modified the xml file to allow several instances to use ssis. Everything works great when the instances are on the same node as ...
user avatar
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
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
8 votes
3 answers
2k views

MySQL LDAP authentication

Is LDAP authentication and authorization in MySQL possible? What are the requirements (MySQL version, third-party software etc.)? How it's organized? Thanks.
Yasir Arsanukayev's user avatar
7 votes
2 answers
2k views

securely exposing sql server 2008 for windows authentication

My company wants to have approximately 100 of their sales people (distributed around the country) to be able to run stored procedures from excel and return the data onto the spreadsheet. We have sql ...
Alex Gordon's user avatar
7 votes
2 answers
14k 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 ...
neiltevetts101's user avatar
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
7 votes
3 answers
6k views

DB2 passwords with special characters

Our DB2 authentication is integrated with active directory, so the allowed passwords are controlled by it's policy. We have some users that are not being able to connect to the database through ...
Guillermo Vasconcelos's user avatar
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
7 votes
2 answers
16k views

Can I use OpenLDAP to authenticate users in Oracle?

I like to use OpenLDAP to authenticate my Oracle users. It should be possible to fetch at least the password from the directory. There appearently is something for the Oracle LDAP servers, but would ...
Sebastian Roth's user avatar
7 votes
2 answers
18k views

How to start MySQL after failure?

After I reboot my server, I can no longer start mysql. I have followed several solutions posted here: This This Or this Did not help much... :( I run the following commands to start the service: ...
Javi M's user avatar
  • 61
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
7 votes
3 answers
10k views

Howto use Windows Authentication with SQL Server 2008 Express on a workgroup network?

I have two computers running SQL Server 2008 Express: c01 and c02, I setup both for remote connection using windows authentication. Worked fine for c02 but not for c01. This is the error message I'm ...
mbadawi23's user avatar
  • 171
6 votes
5 answers
3k views

SQL Server with multiple databases (one per client) - what is the best security practice in terms of logins/users/permissions?

We have multiple SQL Servers with each holding dozens of databases - one per client (a client in this case means a customer organization). These databases are accessed via an application, but the ...
SQL_Guy's user avatar
  • 665
6 votes
4 answers
18k views

Re enable Windows Authetication in SQL Server [duplicate]

My old employee has disabled Windows Authentication in our server. Now I'm not able to access the SQL Server even though I have Administrator access to the server. I need to reset the sa password. I ...
Akhil K Nambiar's user avatar
6 votes
1 answer
11k views

Adding a local user account into SQL Server

I have a (developer) instance of SQL Server 2014 running in my machine. For quick background I'm on a small network like this: Workgroup: HOME Users HOME\PCA HOME\PCB HOME\PCC I'm HOME\PCA. Now I ...
e1445's user avatar
  • 63
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
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,668
6 votes
2 answers
2k views

Restrict Postgres superusers to local only connections

I have a database with several users: foo, bar, and super. I was looking at pg_hba.conf to lock down access. I'd like to allow foo and bar to be able to connect from any IP with password ...
425nesp's user avatar
  • 171
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
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
5 votes
1 answer
10k views

SQL Server SSL Encryption - SelfSign Cert working - why?

I realize this is strange behaviour and I wonder if it is supposed to be working that way when using SQL Server generated self-signed certificate. Client (Management Studio) with "encrypt ...
Noob's user avatar
  • 187
5 votes
2 answers
13k views

Is it possible to assign sql logins into a group?

This may be a bit too elementary question for this site but is it possible to control SQL Server authenticated logins using groups? So is it possible to assign sql logins under groups and give rigths ...
jrara's user avatar
  • 5,343
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
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
5 votes
1 answer
178 views

Always being logged in as SA and not Windows account

First off i would like to appologise if i sound stupid as i do not have much knowladge of SQL Server. I have recently started a project working with SQL Server 2008 R2. I have access to the database ...
Glen Robson's user avatar

1
2 3 4 5
7