The process of identifying the party logging into a system.

learn more… | top users | synonyms

3
votes
2answers
196 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
20 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
32 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
32 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 ...
3
votes
3answers
210 views

“Specify SQL Server administrators” - unusual default value

When installing SQL Server, you get to specify SQL Server administrators, i.e., the list of users initially in the sysadmin role. By default, this list contains the current user. (Image quoted from ...
0
votes
1answer
20 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
685 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 ...
3
votes
2answers
4k 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
0answers
24 views

Postgres and Windows AD using windows authentication

I am working with SQL SERVER 2012 and postgres 9.4.x version on windows OS. The service-x on this machine is running under user-1 and user-1 is member of AD group ADG1. during the installation of our ...
2
votes
1answer
4k views

MongoVUE connect to mongodb with authencation failed! [closed]

I had a mongodb, and a database named genbank. Genbank has a user whose role is "read" and "readAnyDatabase". It is very strange that I cannot connect to genbank through this role by MongoVUE, but I ...
0
votes
1answer
113 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 ...
4
votes
1answer
14k 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 ...
1
vote
0answers
34 views

Design of user database and basic authentication process [closed]

I want to know if somebody can give me very briefly information describing the design of a user database and the basic authentication process please? Thank you
7
votes
2answers
6k 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 ...
0
votes
1answer
221 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 ...
0
votes
1answer
1k views

#1044 - Access denied for user '#username'@'10.%' to database '#database'

I'm trying to connect my webpage to mySQL with ipage hosting. When I copy the snippet: <?php $link = mysql_connect('username.ipagemysql.com', 'username for mySQL', 'password for mySQL'); if ...
0
votes
1answer
11k views

Working example of OPENDATASOURCE command using SQL Authentication

I need to run some ad-hoc queries on several hundred servers that are not part of a domain. Each server has a low-privilege SQL user account that has read-only access to a few tables of interest. My ...
-1
votes
1answer
122 views

MongoDB denying API access, while console shell works

I am a MongoDB newbie, with a MongoDB instance running on a Ubuntu machine. If I login onto the machine's console and run mongo -u username -p password databasename I have permissions for the ...
2
votes
1answer
57 views

Postgresql import user from linux

I install postgresql 9.2 on a Ubuntu 12.10 machine I tried to import linux's user to postgresql but only way I can figure out is CREATE USER Jack WITH PASSWORD '1234'; and do it 10 times (if ...
0
votes
1answer
45 views

Best way to remap database login to new database user and keep previous database user

Here's what my environment looks like: Active Directory (mydomain.local) - Groups - group01 - Members - aduser01 SQL Instance - Logins - mydomain\group01 - ...
0
votes
0answers
31 views

SQL Server Windows authentication: VMs versus others

This really seems like a weird one to me. I have two VMs of interest, one is running Win2k8 R2 x64 and the other is running Windows 7 X64. The server is hosting SQL Server 2k8 while the latter has SQL ...
1
vote
1answer
159 views

Encrypted Connection on Sql Server

I want to make SQL server connection encrypted. I know that a certificate is needed, but I haven't been able to. So far, I: created certificate in IIS. added certificate in MMC "Certificates" ...
2
votes
0answers
33 views

How to prevent misuse of rights in monitoring application?

I have a monitoring application that runs on the computer of each user in my organization. This application needs to insert some monitoring data in several tables of a database (MS SQL Server 2008 ...
0
votes
0answers
34 views

non-default connect roles and proxy authentication

I've been reading up on proxy authentication and found the following to bits of Oracle documentation that I can't seem to implement. Page 8 of this PDF of new forms features: ...
0
votes
2answers
47 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 ...
5
votes
1answer
518 views

Is Oracle's dbms_utility.get_hash_value algorithm documented do reverse engineered anywhere?

I'm working with an existing database where passwords are hashed like this: DBMS_UTILITY.GET_HASH_VALUE(the_username || the_password, 1000000000, 1073741824) I know that this is bad for various ...
0
votes
0answers
97 views

Authentication error when running Sql Server Agent job

This problem is driving me crazy... In Sql Server 2012 I have a Agent job: Job_1, a proxy account: Proxy_1, a credential: Cred_1, the job has a few steps of type SQl Server Analysis Services Command, ...
1
vote
0answers
57 views

SSRS Datasource Escape Password

I am using a dynamic datasource inside a SSRS report to display detailed metrics about an instance. This dynamic datasource uses a SQL Login to connect to each instance listed by this report. The ...
1
vote
0answers
32 views

DB2 Setting up table access based on LDAP groups

I have a DB2 database installed and set up. My users can access any table that I grant SELECT to the PUBLIC group. However, it doesn't appear to acknowledge the groups the user is in in LDAP. The user ...
0
votes
0answers
78 views

can not login to SQL Management studio using “SQL Server Authentication”

i am able to login to sql management studio 2008 r2 using "windows authentication", but if i chnage the Authentication type to be "Sql server Authentication" instead of "windows authentication", i ...
9
votes
2answers
30k 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 ...
2
votes
1answer
792 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 ...
0
votes
0answers
37 views

Please help: kerberos authentication setup on postgresql

Requirement: Backend working with RHEL and postgresql and front-end working with windows,.net. please consider how the authentication method must be done. our main idea will be to have the ...
3
votes
0answers
101 views

Is it possible to have different authentication mode for SQL Server Database Engine and corresponding SQL Server instance?

I have installed the x64 SQL Server 2008 R2 Express with default settings and run MBSA 2.3 Microsoft analizer (using default settings too). Tried on clean Windows 8 installation (not 8.1) and Windows ...
0
votes
0answers
93 views

Please Help: LDAP authentication set-up over PostgreSQL

I received LDAP details and linux user details from my client. He asked me to set the LDAP over PostgreSQL. when i did so i am getting error: "invalid authentication method "ldap": not supported by ...
0
votes
0answers
210 views

workbench failed to connect — ssh

What are the connection parameters? How do I confirm each value? Workbench error: Lost connection to MySQL server at 'reading initial communication packet', system error: 0 I can easily ...
2
votes
2answers
137 views

SQL Alert: 020 - SSPI handshake failure. Tracking the cause?

I have done my best to find an article that answers this question but I have not had much luck. I manage the database across three domains. One domain has the ability to access the other two, but ...
0
votes
2answers
846 views

Access denied to user ODBC, but trying to login as root

I'm trying to do a backup of a MySQL database on Windows, but for some reason it's trying to log me in as ODBC instead of root - does anyone know why? As you can see below the red line, I can login ...
0
votes
1answer
60 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
351 views

LDAP authentication with Percona Server

Reading over this post it seemed to indicate this plugin allowed user authentication via LDAP Percona Server is bundled with the PAM plugin which opens a plethora of ways to authenticate to ...
0
votes
1answer
130 views

How to know my DB user?

I use the PL-SQL developer tool. I log in by using Prodcollops as user name to access the database. How can I find out if my DB user is Prodcollops, too, or if it is just a login name?
12
votes
4answers
90k 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 it to connect to MySQL server when I specify the host parameter. I can successfully connect without the -h parameter. Please see ...
9
votes
4answers
10k 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 ...
3
votes
1answer
62 views

Change linked server login per-query

Given the situation below, can I specify that the pre-configured linked server login should not be used for a particular remote stored procedure call? I have two SQL Server instances: [LOCAL] ...
1
vote
1answer
264 views

SQL Server : Changing Database Username

I have an odd situation and I hope someone can help me get out of this. The situation: I'm running an Azure SQL 2012 SP2 VM with Windows Server 2012. Since it's creation I promoted the server to be ...
0
votes
1answer
2k 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 ...
5
votes
3answers
8k 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 ...
0
votes
1answer
46 views

I cannot do anything on replSet when auth is enabled

I have a mongodb cluster with one replSet, 3 config servers, and 2 mongos instances. I logged into mongos using (admin, pwd). admin is given ["userAdminAnyDatabase", "dbAdminAnyDatabase", ...
1
vote
1answer
721 views

Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON' [duplicate]

Hi I get this error when connecting to SQL Server remotely from a website. I checked the SQL Server logs and get the error: Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'. Reason: Token-based ...
0
votes
1answer
69 views

Cannot log in to SQL Server 2008 R2

I have problem with my SQL Server 2008 R2 instance. I want to log in using windows authentication and server name "local", but error 2 is returned. I've tried to login with a server name of "IP ...