All Questions
Tagged with authentication windows
19 questions
0
votes
1
answer
4k
views
Connect DBeaver to PostgreSQL 13
I've been using PostgreSQL 10 and 12 on Windows successfully with DBeaver in the past. Now I've set up a new development machine and installed the current PostgreSQL 13.0.1 and the current DBeaver 7.2....
- 303
1
vote
1
answer
3k
views
Windows Login can't access SQL Server even with SYSADMIN role
I'm working on AD permissions and have removed my user account from the Domain Admins security group. Now I'm having difficult accessing my SQL Server database with my Windows login. The login is in ...
- 13
1
vote
1
answer
1k
views
Running loadjava with Windows authentication
I want to run following command under Windows with Oracle Database 12c installed:
loadjava -force -genmissing -r -user username/password@database -verbose core-1.7.jar
The problem is that I use ...
- 111
3
votes
1
answer
3k
views
set Windows authentication for postgres
I'm trying to set Windows authentication for a postgres server.
The process is not well documented and makes the whole thing, obscure.
I found this doc but it is quite unclear.
In the necessary ...
- 707
1
vote
0
answers
2k
views
Why MS SQL Express cannot find my local Windows user?
First of all: My Images use german as a language, sorry for that but maybe you find the problem though.
So I am setting up a SQL Database on a MS SQL Server 2016 Express.
While doing so I am using ...
MrMan
1
vote
0
answers
63
views
SQL-Server for Linux WORKGROUP authentication handling
I installed SQL-Server for Linux on a linux Centos 7 distro, it works fine, but I need a workgroup authentication. It's required by the client (SAGE Ligne 100) which runs on a Windows workstation. ...
- 11
1
vote
1
answer
445
views
Using Mixed mode authentication to authenticate Active Directory users to an application
I have a vendor supplied application that I have very limited access to change. The application controls a machine, and cannot easily be logged off between users (expect up to 5 user changes per hour)...
- 13
1
vote
0
answers
39
views
Switch Between Windows Authenticated Users On Single Windows Account
We have a CRM that has been developed in house in Microsoft Access 2003. We are also in the process of moving from an MS Access backend to a SQL Server backend.
I have been researching different ...
- 179
10
votes
2
answers
41k
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's ...
- 109
1
vote
1
answer
159
views
Windows authentication only
I'm busy installing MSSQL 2016, and strongly considering using Windows Auth only. That can interfere with no local installation, but it has occurred to me that if another machine or process wanted to ...
- 404
4
votes
2
answers
12k
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 ...
- 387
2
votes
1
answer
14k
views
sqlsrv_connect: use Windows authentication?
I have a PHP server running under IIS on serverIIS1, and a MS SQL database on serverDB4. I created some PHP code that runs on the serverIIS1 server:
$serverName = "serverDB4\serverDB4";
$...
- 139
1
vote
1
answer
851
views
db2 connecting to a db via alias and storing user name and password
I created a TCP node and I catalogued a db into it. The catalogued db needs user name and password to be accessed. Is there anyway I can store username and password in the cataologue (or other way)? I ...
43
votes
3
answers
217k
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 ...
- 625
3
votes
1
answer
2k
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 --> ...
anon