Azure sql server & sql database : how to login without @servername using private ip

Question

hi

i am using the way to login with "id@servername" through SSMS after i blocked public ip and opened private ip.

but i want to find the way to login just with "id" like the way when i open public ip.

[public ip]
id : login id
pw : login pw

[private ip]
id : login id@servername
pw: login pw

Answer 1

Hi @오혜원 .

Welcome to Microsoft Q&A platform and thanks for using Azure Services.

As I understand your question, you want to login without @servername using private ip.
Here is a detailed Answer where several options are given for login to the DB: what-are-valid-connection-strings-for-ssms-login-box

Please take a look and let us know if this helps in your case. Do let us know if you need have any doubts.

------------------------------

• Please don't forget to click on or upvote button whenever the information provided helps you.
  Original posters help the community find answers faster by identifying the correct answer. Here is how
• Want a reminder to come back and check responses? Here is how to subscribe to a notification

Answer 2

i understand that i need to use DAC to login through what i want

but to use DAC, I use commands like

EXEC sp_configure 'remote admin connections', 1;
GO
RECONFIGURE;
GO
.

but i got these errors:
Could not find stored procedure 'sp_configure'.
Statement 'CONFIG' is not supported in this version of SQL Server.

Answer 3

hi i am using azure mssql db now.

that's why this command is not supported.

thanks for letting me know the view, sys.configurations.

i understand that 'remote admin conncections' options should be ON to login with what i want.

so i try to turn on the option using "ALTER DATABASE SCOPED CONFIGURATION". but it's not working.

how can i change the option on?