Questions tagged [windows-authentication]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
1
vote
0answers
30 views

Cross domain authentication - 'The target principal name is incorrect. Cannot generate SSPI context'

I have problem with windows authentication. I have two domains (Lets say A and B), and server which is at the domain A. It is an default instance on the server and it uses AD account as an service ...
0
votes
0answers
85 views

Could not obtain information about Windows NT group/user 'WIN2016\mssqlUser', error code 0x80090304 After creating new user only

I've added Ubuntu 20.04 under a Active Directory Domain Controller and after I create a new User subsequent queries fails with error 1> CREATE LOGIN JohnyBonzela WITH PASSWORD = '***#' 2> GO 1&...
1
vote
0answers
74 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 ...
2
votes
5answers
227 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 ...
0
votes
1answer
88 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
0answers
407 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 ...
0
votes
0answers
19 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
1answer
23 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
0answers
32 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 ...
0
votes
1answer
21 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 ...
0
votes
1answer
78 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
42 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
585 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
949 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
2k 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
108 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 ...