Urgent help How to enable SA account or add another login in SQL server with sysadmin permission We don't have any login with sysadmin permission no built in administrators nothing.
Urgent help
How to enable SA account or add another login in SQL server with sysadmin permission
We don't have any login with sysadmin permission no built in administrators nothing. Authentication is mixed mode. Only 2 logins exists in SQL server one is SA and other is AD group and none of them as sysadmin permission.
Already tried starting sqlserver in single user mode and getting error like SQL server installation is either corrupt or has been tempered with. Although we are able to bounce the services successfully.
Replies
You normally get it's corrupt when you are not using a correct path to the .exe file...see if you are missing the quotes when you start SQL service ..try to start with the below in CMD as admin : path -c -m "sqlcmd"...then open another CMD as admin type sqlcmd and then use reset command
If you can afford changing SA password then use psexec to change the sa password without any down time. Refer following link for more details : https://www.mssqltips.com/sqlservertip/2682/recover-access-to-a-sql-server-instance/
who have installed SQL server, that account consists of sysadmin account.
No account is having sysadmin access
If you have full access on windows level it will be Very simple... Take 5min down time. Put the service in single user mode. From command prompt connect to sql Create one test login with sysadmin permission. Note: you don't have but you can able to create login on sql server if you have full access to Windows.
Thanks Rama for suggestions I have already tried that. It is not working because in background it looks for not authority system login which is not there in SQL. Hence it is failing in that way too.
Ankit Yogesh Garg even it was not in sql also you can able to create... But you should have windows level full access
Do you have an account which is part of local administrator group?
No we don't have any local administrator group.
Ankit Yogesh Garg on the windows box???
Yes.
