12

I have myserver.database.windows.net with administrator login John.
I'd like to change it to Peter.
It is possible, if so, how ?

Alter which works with local sql server, doesn't work here

ALTER LOGIN John WITH NAME=Peter

enter image description here

  • This MSDN thread from 2009 says you just need to re-create the server - but I'm curious if there are any better solutions in the past 6 years. – LowlyDBA Jan 9 '15 at 15:50
  • Did you tried reset admin password – TheGameiswar Jan 10 '15 at 21:25
  • @TheGameiswar Sure. I can change the password, but that's not a problem. I'd like to rename Administrator Login. – Hoppus Hoppard Jan 12 '15 at 10:10
12

So this may be an old question, but the problem is still relevant today. The only way that you can alter the administrator of an Azure Sql Server, is to create a new SQL Server. Once the administrator has been set, you can reset their password, but not the name.

I just ran into this same issue and had the same #facepalm moment.

| improve this answer | |
  • To just add oneadditional thing it does state in the documentation that the initial administration account created is treated like the "sa" account in the full version of SQL Server. So it would be assumed a restriction of not modifying it in this manner is there, although you can at least rename it on the full version. – user507 Jul 29 '15 at 4:57

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.