The process of identifying the party logging into a system.
1
vote
1answer
42 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 ...
0
votes
1answer
34 views
Kerberos Authentication Issue
I'm getting these errors when testing a linked server from SQL Server 2012 to SSAS 2012 (both servers are Windows 2012 and clustered)
"An error was encountered in the transport layer" and "The peer ...
0
votes
1answer
65 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:
...
1
vote
1answer
42 views
dcexec login failure
I have a SQL Server 2008 R2 instance that I have been trying to get Data Collection setup on. I get everything setup, but there is no data that gets uploaded. I've traced the root of the problem to be ...
0
votes
3answers
415 views
Connecting to SQL Server instance through C#
I made a program, using c# and sql server with sql authentication. It works properly in my device, but after making the program setup file .exe extension using Innosetup, I cannot connect to my ...
2
votes
1answer
65 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 ...
0
votes
0answers
56 views
Use Oracle Wallet without autologin enabled
Question: is it possible to use the Oracle Wallet without enabling auto login in Wallet manager?
Problem I'm facing: When auto login is disabled, the sqlplus call:
sqlplus /@orcl
fails with:
...
0
votes
1answer
117 views
SymmetricDS fails to start for PostgreSQL 9.2
I'm trying to get SymmetricDS up and running with PostgreSQL.
I've followed the tutorial (almost) exactly.
(I have not set up a separate node yet since, for my purposes, I need that separate node to ...
2
votes
2answers
2k 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): ...
2
votes
1answer
62 views
Choosing A PostgreSQL Authentication Method For A Large Course
I am teaching a first course in databases for the first time. Students will need to have a database management system to which they can connect to do much of their work for the course. I have chosen ...
2
votes
0answers
108 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 ...
2
votes
2answers
388 views
SQL server windows authentication through network
I am using sql server 2008 r2.There are about 50 pc in my office connected in network by using LAN.In a sql server 2008 r2 express(installed in windows 8) i have created all users windows account with ...
-1
votes
0answers
62 views
Changing password doesn't work [closed]
I need to login to a database. I have good credentials, but when I was trying to login with SQL Developer, I got this error message:
ORA-28001: the password has expired
Then I tried to login ...
2
votes
1answer
114 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 ...
1
vote
1answer
336 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
1answer
153 views
PostgreSQL LDAP authentication
We are setting up a PostgreSQL 9.1 database at work. There are no classified data in the database, but we want to know who is doing what. We are using LDAP authentification on the network, so we would ...
1
vote
3answers
243 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 ...
0
votes
2answers
96 views
Is there any way to connect to one server and utilize a linked server using Windows authentication and NTLM?
I currently have SQL Server 2005 (Server A) that has a SSAS 2005 linked server (Server B). The powers that be do not want to enable Kerberos authentication, so I'm stuck with NTLM.
The problem is ...
1
vote
0answers
56 views
Re enable Windows Authentication [closed]
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.
4
votes
3answers
322 views
Re enable Windows Authetication in SQL Server
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 ...
2
votes
1answer
302 views
Cannot connect to SQL Server after setting sa password to blank
I have installed SQL Server 2008 R2 on a Windows 2008 server. I need to set the sa password to blank for some reasons to make an application works; but it seems like the password changes automatically ...
2
votes
1answer
302 views
If the users need INSERT/UPDATE/DELETE permissions, is Windows auth still more secure than SQL Server auth?
Some background first:
The problem described below wouldn't exist at all if the database in question would have been built with a DBA's mindset:
Data access only through views and stored procs --> ...
0
votes
0answers
12 views
Vote to a db server using session key
I do not know if this is the right stackexchange site to ask this question, but I believe that is relevant.
I am trying to implement an e-voting protocol. At some point the protocol says that server 1 ...
0
votes
2answers
58 views
Error log - What does this mean and what can I do about it?
I have the following repeated errors in my error.log and I don't know what it means or what I should/can do about it:
Access denied for user 'root'@'[some IP]' (using password: YES)
There are ...
2
votes
1answer
116 views
SQL 2008: Why is *any* user, with minimal permissions able to restart/stop the SQL instance through Management Studio
So I'm on a project that I need to help admin SQL 2008 .
I'm coming from a MySQL background.
Why is it that a basic user, with the most basic/default permissions, through Management Studio is able to ...
1
vote
0answers
649 views
connect sql server using windows authentication in another pc
I am having sql server 2008 r2 express installed in a PC. I have some other PC which are connected to this pc in a local network.Now those PC connect to my pc's sql server using sql authentication. ...
0
votes
3answers
704 views
SQL server ODBC connection for Active Directory user who doesn't log in to the windows
Do you think it is possible to create a SQL server ODBC Connection for an active directory user who doesn't log in into the windows.
Ideally this type of users will be used in the batch process. So, ...
2
votes
2answers
92 views
Logging only mySQL logins on heavily used system
I have an audit requirement where they want all database access (logins) logged. We have a very large distributed system of hundreds of mySQL servers (shards, slaves, slaves of slaves) that are ...
3
votes
1answer
145 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: ...
0
votes
0answers
557 views
SQL Server 2012 SSIS\SharePoint Kerberos auth [closed]
I have some issues setting up Kerberos together with SQL Server and SharePoint. Any help will be much appreciated! =)
GOAL:
Use Kerberos to avoid double-hop issue.
USAGE:
User logs onto ...
3
votes
3answers
950 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
407 views
How do you authenticate the database connection when using Reporting Services Forms authentication?
I'm looking into using Forms authenticaiton for SSRS. I got it working using Microsoft's sample found here: http://msftrsprodsamples.codeplex.com/wikipage?title=SS2008!Security%20Extension%20Sample
...
1
vote
1answer
234 views
PostgreSQL - using password/md5 authentication with empty password
I have the following role in my system:
CREATE ROLE test LOGIN INHERIT NOCREATEDB NOCREATEROLE NOREPLICATION;
There is no password. Trying to connect to the db from within the same machine using ...
10
votes
3answers
13k 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
...
1
vote
1answer
653 views
Issue with connecting to the mysql database
We have an outstanding issue with VCC in chicago, there is an issue connecting to the mysql database
If an agent does a refresh of the monitor they will be logged out.
This is the error we ...
4
votes
2answers
222 views
Integrated Security Success on Master, Fails on Other Database
I'm a bit perplexed as to why my connection string is selectively succeeding on the master database in SQL Server 2005. Here are the details of my app. Any ideas where to look? I'm clearly missing ...
0
votes
1answer
4k views
user “sa” cannot connect to SQL Server Express 2008 R2
Goal: connect to SQL Server Express 2008 database using SQL Server authenticated account "sa", rather than my Windows authenticated account.
When installing SQL Server 2008 Express, I took all ...
1
vote
2answers
680 views
Login Failed for User
I have written a code in Visual Studio.NET and used data from SQL Server 2008. But after debugging, it says:
Login failed for user 'sunny'.
When I try to set the user as something else, it keeps ...
2
votes
2answers
276 views
How do I monitor which Windows user is logging in as SA? [duplicate]
Possible Duplicate:
ProcessID Owner with third party app
Several of our applications use the sa account to login to our SQL Server 2008 instance. As these applications are poorly designed ...
2
votes
2answers
106 views
remote connection
Im trying to connect to a remote sql server using windows authenication. I'm using visual studio 2012 and going to a remote sql server 2012. I have already checked in sql studio that it is set up for ...
0
votes
2answers
663 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 ...
6
votes
1answer
5k 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 ...
1
vote
2answers
576 views
MySQL 5.5 accepts password but then closes connection
Apologies in advance for lack of information. I have installed MySQL 5.5 x64 on a Windows XP Professional x64 development machine. Today, upon trying to connect with any tool(MySQL workbench, PHP ...
1
vote
1answer
113 views
Default Schema Problems on server
When i connect to SSMS on my server through remote desktop and query my database using:
SELECT * FROM [sys].[database_principals] WHERE [principal_id] = USER_ID()
I am getting the correct results ...
4
votes
1answer
146 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 ...
0
votes
1answer
406 views
Unable to reset the password of users in postgres
Evrytime i run, su - postgres it asks me for a password which I did not set. I simply installed the postgres. I have gone to the pg_hba.conf.
# Database administrative login by Unix domain socket
...
1
vote
1answer
710 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 |
...
5
votes
1answer
384 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 ...
1
vote
2answers
3k views
Microsoft SQL Server says my login is disabled, even in single user/DAC mode
I'm locked out of a local database, and the single-user mode option that has worked for me in the past isn't working for me here. I could use some options to try.
It's saying the account is disabled, ...
2
votes
1answer
104 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 |
...
