Database Administrators Stack Exchange
Database Administrators Stack Exchange

Questions tagged [windows-authentication]

31 questions
10
votes
2 answers

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 login with my sa account and I don't have another…
Nano
  • 139
  • 1
  • 3
  • 11
4
votes
2 answers

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 disabled by default So I tried to enable the sa…
Behseini
  • 141
  • 1
  • 2
3
votes
1 answer

Can I use a linked server that uses Windows Authentication when I'm logged in with SQL Authentication?

I'm using SQL Server 2016 (SP1) Standard Edition. I have a linked server that uses Windows Authentication and needs to because it connects to a non-SQL Server database. It uses an OLE database provider. I have a third-party application that needs to…
sqltracy
  • 31
  • 3
3
votes
0 answers

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 was typed in, even in Domain\Username…
kjwhal-dfin
  • 31
  • 1
3
votes
0 answers

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 recommended default user account of NT…
jnm2
  • 141
  • 1
  • 1
  • 7
3
votes
2 answers

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 consume the pre-login handshake acknowledgement. …
Circle Hsiao
  • 455
  • 1
  • 6
  • 19
2
votes
2 answers

Error while connecting Local DB 2012 in Windows 7 PC using SSMS

I am trying to access LocalDB 2012 on my Windows 7 SP1 PC. I have successfully installed LocalDB and started the instance using the command line, and it is currently running. However, when I attempt to connect to this LocalDB instance using SQL…
RD Seeker
  • 35
  • 4
2
votes
1 answer

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 in the company for replication purpose. Password…
nlks
  • 21
  • 1
2
votes
1 answer

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 Kerberos Configuration Manager to diagnose the…
JuliousGonsalves
  • 21
  • 1
  • 1
  • 2
2
votes
5 answers

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 work at my dev of course. I am trying: CREATE…
jericzech
  • 977
  • 8
  • 22
1
vote
0 answers

SQL Server Agent Job Failing with Linked Server Error 7437 and Impersonation Issues

I have two servers, ServerA and ServerB, both of which are part of the same domain (test). For both servers, the SQL service account and SQL Agent service account are configured to use the domain account test\SQLAdmin. I want to establish a…
Mangesh Auti
  • 111
  • 3
1
vote
1 answer

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 the process requires that anyone in the firm…
Allen R. Brady
  • 111
  • 3
1
vote
0 answers

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 Authentication. I can connect to the instance fine…
medina
  • 197
  • 1
  • 2
  • 7
1
vote
3 answers

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 noticed that on first two servers, domain users are…
Aleksey Vitsko
  • 6,148
  • 5
  • 39
  • 70
1
vote
1 answer

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 using my Windows Authentication account. I have…
KamSami
  • 113
  • 2
1
2 3