snippetModerate
How to change name for administrator login on azure sql server
Viewed 0 times
serversqlloginazurenameforhowadministratorchange
Problem
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
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
Solution
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.
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.
Context
StackExchange Database Administrators Q#88944, answer score: 15
Revisions (0)
No revisions yet.