[Company Logo Image] 

Home Up Contents Coffee Break Credits Glossary Links Search

 
Not a valid login name in this version of SQL Server

 

 

Home
Analysis Services
Azure
CLR Integration
High Availability
Open Source
Security
SQL Server 2008
SQL Server 2012
SQL Server 2014
SQL Server 2016
SQL Server 2017
SQL Server 2019
Tips
Troubleshooting
Tuning

Not a valid login name in this version of SQL Server.


Applies to: SQL Azure Database V12.
 

Problem Description.
 

When you try to create a login with the name "sa"  you may receive the following error message:

CREATE LOGIN sa WITH PASSWORD='new_password'

Msg 40616, Level 16, State 1, Line 1
'sa' is not a valid login name in this version of SQL Server.


Cause.


"sa" is not allowed as login name on SQL Azure database.


Workarounds.


Try creating the login with a different name.

If you are trying to create an "sa" login on SQL Azure with sysadmin privileges same as on-premises instance of SQL Server because you have an application that requires a login with that specific name, then you may have to consider using SQL Server IaaS as database server of your application. Alternatively, you can try to contact the manufacturer of the software for more options on how to make that application work with SQL Azure using a different login name. If you created the application, please consider changing the need to use "sa" login as part of the application normal operation.

 

 

 

.Send mail to webmaster@sqlcoffee.com with questions or comments about this web site.