Questions tagged [windows-authentication]
The windows-authentication tag has no usage guidance.
6
questions
0
votes
1answer
58 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
0answers
34 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 ...
3
votes
2answers
83 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 ...
10
votes
2answers
893 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 ...
1
vote
3answers
707 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 ...
1
vote
1answer
76 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 ...
