The process of identifying the party logging into a system.

learn more… | top users | synonyms

0
votes
1answer
114 views

How to set up an SQL Server authentication login for a database instead of using Windows Authentication

Not sure what I am doing wrong so I have included the parameters I used which I used the existing login and this article for reference: ...
0
votes
1answer
25 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 ...
0
votes
2answers
143 views

Mapping a Login to a User

On my production system I login to SQL Server with CPSDOM\mconnors. When I execute SELECT CURRENT_USER; it returns CPSDOM\mconnors. We use Windows authentication on our DBs. On my test system I ...
0
votes
1answer
2k 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({ ...
0
votes
1answer
3k views

Excel Data Connection to SQL Server using Windows Auth from untrusted machine

We have an Excel spreadsheet that uses a Data Connection to a SQL Server database. The database server is joined to our domain, and Windows Authentication is enabled. Here is a sample of the ...
1
vote
1answer
150 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 ...
2
votes
1answer
29 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 ...
1
vote
1answer
20 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 ...
0
votes
1answer
5k views

sql server authentication login failed

I have SQL Server 2014 on my Windows Server 2012 R2. I can connect locally to SQL Server from Management Studio using Windows Authentication. I decided to switch to SQL Server Authentication ...
17
votes
4answers
76k 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 ...
4
votes
1answer
41 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 ...
6
votes
1answer
943 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 ...
3
votes
1answer
1k 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 ...
3
votes
1answer
45 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 (leeand00@example.org), that have been sent to the SQL2.example.org server to SQL3.example.org (admittedly this is ...
6
votes
1answer
218 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 ...
0
votes
1answer
53 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 ...
1
vote
0answers
44 views

SQL Server 2014 proxy error

I'm rather confused by this one and can't see any options in previous posts about similar things. I've created a credential -> proxy account, that will run a PowerShell script. When I run the ...
1
vote
1answer
160 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 ...
-1
votes
1answer
63 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 ...
1
vote
2answers
238 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 ...
0
votes
0answers
7 views

Basic Authentication: External API Calls

In another vein, the question of pulling data from external APIs into was answered here: Pulling data into Access from an external API That call does work, but only if authentication is not needed. ...
2
votes
1answer
249 views

Running SQL job: The login is from an untrusted domain and cannot be used with Windows authentication

I have two databases in different servers (server1 , server2) server1: Login : login1 / password :123 /member of sysadmin (user user1,password:pass) server2 : Login :login1 / password :123 ...
16
votes
4answers
124k 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. ...
1
vote
3answers
12k views

Can't backup a Postgres database: FATAL: Peer authentication failed for user “postgres”

I can connect to my database no problem remotely, either from PHP scripts on our webserver or using PGAdmin3. Unfortunately, when I try to run pg_dump backups locally on the server itself, I get: ...
5
votes
3answers
595 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 ...
0
votes
0answers
165 views

Getting “LDAP authentication failed” when connecting to Vertica via JDBC

I'm trying to connect to a Vertica 7.1.1 database using DBeaver. I've downloaded the 7.1.2 JDBC driver (I couldn't find a 7.1.1 driver available for download) and configured DBeaver to use it. When I ...
0
votes
1answer
72 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 ...
3
votes
1answer
233 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 ...
0
votes
1answer
55 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 ...
1
vote
1answer
186 views

Azure SQL Database “Login failed for user” contained users.

I'm having a similar issue to this question (http://dba.stackexchange.com/posts/123094/edit)! I have followed the following article: ...
1
vote
0answers
79 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 ...
3
votes
1answer
2k 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 ...
2
votes
0answers
129 views

PostgreSQL 9.3 running on Linux - need to authenticate vs. Windows Active Directory

Database server is Ubuntu Linux 3.13.0-68-generic Database is PostgreSQL 9.3.10 LDAP set up according to https://cdc.iseage.org/tutorial-pam-ldap-authentication-active-directory-debianubuntu/ ...
1
vote
2answers
506 views

What reasons can lock an Oracle account

There could be a lot of reasons why an Oracle account can be locked. When an account is locked and the users is asking for our help, following could be the possible cause of account lock: A user ...
0
votes
0answers
34 views

Database Authentication Through IIS 7.5

I have just deployed a new MVC application to a test server via IIS 7.5. This application uses a SQL Server 2008 R2 database to manage its data. When I am logged onto the test server and access the ...
0
votes
1answer
275 views

Trouble Shooting “Unable to complete login process”

Issue On one of our SQL Server witness servers (This is part of our Database Mirroring setup for SQL Server 2008 R2) we have just started getting the below event in the windows event log. The ...
2
votes
1answer
70 views

MySQL create user incorrectly updates user table

I recently upgraded from mysql-community 5.7.4 to 5.7.8. All packages show the newer version is correctly installed. I reinitialized my database using mysqld --initialize and corresponding steps. I ...
3
votes
2answers
127 views

Cannot register SPN, error 0x80090350, state 4

This is my first time trying to configure kerberos. I need it for SQL. I'm running SQL Server 2008 R2 on Windows 2008 R2 server. I have an Active Directory account for SQL Server 2008 R2. The ...
3
votes
0answers
801 views

How to set up users in SQL Server 2008 Express over workgroup? (no domain)

The situation is this: simple network, one server not a domain controller, running SQL Server 2008 Express (64bit). 8 workstations running windows 7 pro connected to it. Last week after Windows ...
3
votes
2answers
5k views

DB2 to require password each time

I am using db2inst1 to connect to a database in DB2 which I have installed on my machine. Therefore, db2inst1 user does not require username/password authentication (borrows them from the OS). I would ...
1
vote
1answer
186 views

Please explain SYSCS_UTIL.SYSCS_CREATE_USER() function

Can someone please explain to me how SYSCS_UTIL.SYSCS_CREATE_USER() works? I tried adding a new user like this: SYSCS_UTIL.SYSCS_CREATE_USER('user', 'someP@ss'), and it gave an exception Error code ...
2
votes
2answers
92 views

SSPI error and DotNetMethod exception while connecting to the SQL DB using powershell script

I wrote the following script with the original connection names and credentials. $SQLServer = "servername" $SQLDBName = "dbname" $SqlQuery = "select * from tbl_Employee " $SqlConnection = ...
1
vote
0answers
729 views

ORACLE SSL using Microsoft Certificate Store for PKI

I am trying to set up PKI SSL authentication between client and server using a Microsoft Certificate Store. Client: Windows 7 64 bit with Oracle client 11.2.0.3.0 Server: Windows 2008 R2 64 bit with ...
3
votes
1answer
332 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 ...
-1
votes
2answers
36 views

Windows Authentication Server Role Verification

I am using SQL Server 2008 R2.I am connected with Windows Authentication, I wanted to verify/check whether the Login had a sysadmin Server Role using code. Is there any script to verify the same? ...
6
votes
4answers
6k 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 ...
3
votes
2answers
3k 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 ...
1
vote
1answer
243 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 ...
2
votes
0answers
147 views

How do I authenticate a Database User by a LDAP Server and then to login with the SQL Developer, without using the OID/Apex?

I want to create a global User, identified by a LDAP_DN. My Problem is: I can automatically create users, but when I try to log on to the database, I get the error message that the login data are ...
4
votes
1answer
87 views

Should Service Broker use SQL or Windows Authentication?

I was curious what the best practice would be, for properly setting up Service Broker in SQL Server 2008. Should I use a SQL authenticated user, or should I use a Windows NT Authenticated user based ...