Questions tagged [windows-authentication]
The windows-authentication tag has no usage guidance.
21
questions
0
votes
0
answers
105
views
Kerberos client authentication times out with SQL error 87
Apologies for the length of this but I'm app developer, not a SQL DBA nor network Admin, so I'm out of my area and just wanted to be sure I documented everything as well as I could.
This is a problem ...
0
votes
1
answer
145
views
PostgreSQL client on Windows to access PostgreSQL server on Linux using Active Directoy Kerberos authentication
TEST 1 - PostgreSQL with Active Directory authentication
I have installed PotgreSQL Server v15.3 on Red Hat 8.8 and integrate PostgreSQL authentication using Active Directory.
In pg_hba.conf I have ...
- 327
3
votes
1
answer
1k
views
Not Able to Enable sa Account in SQL Server 2019 Express after Login with Windows Authentication Mode
I have installed SQL Server Express 2019 on my machine and after installation, I am able to login into server using the Windows Authentication method like
And as you can see the sa account has been ...
- 131
2
votes
1
answer
100
views
Securing Functional/Service ID for MSSQL with Windows Authentication
I'm currently assessing a setup of Data warehouse implementation in our environment, based on the requirements:
A functional/service ID to be setup to access multiple DB servers of other applications ...
- 21
2
votes
1
answer
10k
views
The target principal name is incorrect. Cannot generate SSPI context. (Microsoft SQL Server)
we have an issue connecting remotely to SQL Server via SSMS with Azure AD users. Any attempt to log in to a SQL Server instance in AWS with Windows Authentication throws an SSPI error. We've tried the ...
0
votes
1
answer
2k
views
Can not login with windows authentication after changing sa and windows passwords
I changed sa and Windows administrators password successfully, I can login to server with sa without any problem, services working normally, database is not corrupted and working without any problem.
...
- 5
1
vote
1
answer
277
views
Insert a record via VBA without SQL authentication
I maintain a SQL Server database that's used as a workflow tool for a team of a few dozen users. Those users interact with the database via an MS Access front-end and Windows Authentication. Part of ...
- 111
2
votes
0
answers
567
views
Did SQL Server ever add user principal name support?
I ran into an issue today where the User Principal Name was greater than 20 characters in length, so the samAccountName was capped at 20.
This resulted in SQL Server not finding the user when the UPN ...
- 21
2
votes
5
answers
2k
views
CREATE Windows User in database for not existing domain
Is it possible to create a Windows User in the database when the domain is not accessible?
I am preparing database at my dev environment outside of the targeted domain.
Created user is not expected to ...
- 945
0
votes
1
answer
555
views
How to setup Linked Server connect with different Domain Account with Windows Authentication
we have two SQL Server 2017 "ServerA" and "ServerB" on Windows Server 2016 in the same domain.
Both SQL Server have a Login defined "mydomain\dbaccount".
On ServerA we ...
2
votes
0
answers
1k
views
Is it possible to run SQL Server as 'NT Service\MSSQLSERVER' and EXECUTE AS a domain account?
For clarity, I'm asking how to resolve this
without running SQL Server as a domain account and
without making sa the database owner.
In a nutshell
If I install SQL Server 2019 and go with the ...
- 121
0
votes
0
answers
33
views
AD groups authentication doesn't work at the console of SQL Server 2017
I come up with this. A Domain admin windows user is able to login to a SQL Server 2017 instance from any client computer, but it can not login from the console of the server. TCP/IP and Shared memory ...
0
votes
1
answer
58
views
SQL Server 2017 on RHEL Linux with IDM for AD authentication
We are using Red Hat IDM to authenticate AD users to SQL Server. Users can login successfully to SQL Server with SSMS and SQL CMD with AD Authentication. But running some elevated commands from SSMS ...
0
votes
0
answers
43
views
Login MSSQL using Active Directory account from local Windows account [duplicate]
Due to Coronavirus, we on my company are working from home. I had setup a virtual machine and am using VPN to connect to company's intranet.
It happens that we use company's AD account to log in ...
- 1,533
0
votes
1
answer
28
views
"Could not find login" failures for remote LocalSystem that exists
I imagine security changed in some way for Windows 2016, but I'm unable to determine what exactly.
For context: We have a variety of remote clients that handle data processing within a (non-SQL) data ...
- 1
0
votes
1
answer
341
views
How to prevent logins using Windows Authentication in SQL Server?
SQL Server supports creating logins using SQL, Windows, certificates and asymmetric keys. Is it possible to remove the option of creating logins with Windows authentication (and just allow SQL ...
1
vote
0
answers
84
views
SSMS Connect to remote SQL instance with Windows Authentication
I have a remote SQL instance
(Microsoft SQL Server 2016 (SP2-CU3) (KB4458871) - 13.0.5216.0 (X64)
I can connect to the instance fine locally on the box through SSMS using both Windows and SQL ...
- 197
3
votes
2
answers
937
views
SSMS cannot connect remote server by IP through Windows authentication
I'm trying to connect a remote server by IP,port via Windows authentication.
It will end out with the following error
Connection Timeout Expired. The timeout period elapsed while
attempting to ...
- 435
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 ...
- 139
1
vote
3
answers
3k
views
NTLM vs Kerberos authentication - questions
We have 4 servers, all are members of the same Domain:
1. SQL 2012 on Windows Server 2016
2. SQL 2012 on Windows Server 2012
3. SQL 2017 on Windows Server 2016
4. SQL 2017 on Windows Server 2016
I ...
- 5,472
1
vote
1
answer
130
views
Can I query from two databases if my web application is connected to one database?
I have a local database, DB1, that I created and is connected to my web application. My web application takes in stored procedures from DB1 and queries them. My application connects to SQL Server ...
- 113