Questions tagged [windows-authentication]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
10
votes
2answers
873 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
216 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
68 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 ...