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
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It only takes a minute to sign up.
Sign up to join this communityI 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
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.
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.