September 12, 2011 at 7:58 am
I have changed windows login roles from sysadmin to public. How can I change it to sysadmin back.
September 12, 2011 at 9:45 am
Do you still have a sysadmin login that can connect to the instance?
-- Gianluca Sartori
September 12, 2011 at 12:12 pm
No. I dont think I have overriden the log in roles. And, I dont know the default password of SQL authentication. This login has sysadmin role associated.
Is there any way to brought back the changes again?
Thanks
October 6, 2011 at 8:59 pm
You need to be able to login with an account that has security admin or sysadmin access.
What login did you use to change the logins to the public role in the first place?
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply