Tech
Forums
Jobs
Books
Events
Interviews
Live
More
Learn
Training
Career
Members
Videos
News
Blogs
Contribute
Article
Blog
Video
Ebook
Interview Question
Collapse
Feed
Dashboard
Wallet
Learn
Achievements
Network
Rewards
SharpGPT
Premium
Contribute
Article
Blog
Video
Ebook
Interview Question
Register
Login
Cannot Connect To Your Azure SQL DB Logical Server - Azure SQL Server
WhatsApp
Mahender Pal
4y
9.1
k
0
0
25
Blog
Recently I setup Azure SQL Server from Azure portal UI and I wanted to access it from outside so I configured all required steps so that it is accessible remotely like following screen,
but still I was getting following error while trying to connect to Azure SQL Server from my machine,
Cannot connect to your Azure SQL DB logical server/Azure SQL MI server, exception: Cannot open server “…..” requested by the login. The login failed.”
While troubleshooting this issues, luckily I found this
post
.
Based on this post if you are getting this error, you can suffix @YourSQLServerName in your user name.
For example suppose I am trying to access my devssisdbserver.database.windows.net using following User:
[email protected]
and getting above error.
So to resolve this issue I have to suffix my sqlserver name after the user name, so I tried using
[email protected]
@devssisdbserver and it worked !
Hope it will help someone !!
Azure SQL Server
Up Next
Deploy Database From Local To Azure Using Deploy Database To SQL Azure Option In SQL Server
Ebook Download
View all
A Guide to Azure Artificial Intelligence
Read by 6.5k people
Download Now!
Learn
View all
HIMBAP
We are expert in Microsoft Power Platform.
Membership not found