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

오혜원 41 Reputation points
2022-10-26T07:35:05.057+00:00

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

Azure SQL Database
SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,710 questions
0 comments
Accepted answer
  1. ShaktiSingh-MSFT 13,271 Reputation points Microsoft Employee
    2022-10-26T07:58:33.863+00:00

    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 130616-image.png or upvote 130671-image.png 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
    0 comments

2 additional answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. 오혜원 41 Reputation points
    2022-10-26T08:21:45.003+00:00

    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.

  2. 오혜원 41 Reputation points
    2022-10-27T04:15:32.927+00:00

    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?