Questions tagged [windows-authentication]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
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 ...