Database Administrators Stack Exchange
Database Administrators Stack Exchange

Questions tagged [sa]

7 questions
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
4
votes
1 answer

How to revoke SA permissions that seem to be "stuck" to a login?

Apologies in advance if I don't use some terminology correctly here. I'm not a DBA but I've been temporarily forced into the role. I've inherited an application that runs on SQL Server 2016 Enterprise - one instance for PROD and another for TEST. …
yhelothur
  • 43
  • 3
1
vote
1 answer

Confused - I disabled sa account for security reasons - My sql agent jobs owned by sa now fail

All the articles over the years tell me that disabling sa wont affect any jobs owned and run by sa. I'm running the SSMS builtin Maint wizard job: "Misc Cleanup.Subplan_1" and "DB Integrity Check.Subplan_1" and also a Ola Hallengren "Index Optimize…
Jeff Shervey
  • 21
  • 3
0
votes
1 answer

SQL Server read-only SystemAdmin account

Is there a way to create a sysadmin like account with only read privilege's. I know that you can give a lot of grants to an account like view server state, view any definition, view any database etc, etc.. but still than this user will not always…
Ludo
  • 66
  • 3
0
votes
1 answer

Sql Server - Unable to create new database due to lack of admin role

I can log onto Sql Server Management Studio without issues. I can't create a new DB however as it appears that I don't have permissions. I can't give myself more permissions I can't modify the SA login. I thought my default my windows BUILTIN…
Amanda Brandimore
  • 9
  • 1
0
votes
1 answer

Can not login with windows authentication after changing sa and windows passwords

I changed sa and Windows administrators password successfully, I can login to server with sa without any problem, services working normally, database is not corrupted and working without any problem. Problem is I cannot login with Windows…
Yuzarsif
  • 5
  • 1
  • 3
0
votes
2 answers

Why is the disabled SA user listed as logged in?

I was looking for the last time users have been logged into the system and saw SA as being used. Strange is that SA is disabled by default and not used on our systems. How is that possible, what am I missing? The query used to list users: SELECT…
TheNixon
  • 371
  • 4
  • 12