无法使用AZURE VM中的SQL Server身份验证登录SQL Server [英] Could not able to login , into SQL server using SQL Server Authentication in the AZURE VM
问题描述
嘿，
我是Azure的用户.
I am the user of Azure.
我使用镜像"MicrosoftSQLServer:SQL2016SP1-WS2016:Enterprise:latest"创建了虚拟机
I created a Virtual Machine using the image "MicrosoftSQLServer:SQL2016SP1-WS2016:Enterprise:latest"
能够使用"Windows身份验证"成功登录SQL Server.
Successfully able to login into SQL server using "Windows Authentication"
启用了"sa"登录.当我尝试使用"SQL Server身份验证"登录时，它失败了.
Enabled the "sa" login. When i tried to login using "SQL server Authentication" it is failing.
即使我也观看了"https://channel9.msdn.com/Blogs/raw-tech/How-To-Fix-Login-Failed-for-User-Microsoft-SQL-Server-Error-18456"的视频-逐步-
Even I followed the video of "https://channel9.msdn.com/Blogs/raw-tech/How-To-Fix-Login-Failed-for-User-Microsoft-SQL-Server-Error-18456-Step-By-Step"
问题仍然存在.
有人可以为此提供一些解决步骤吗?
Can someone please provide some resolution steps for this
推荐答案
嘿
我是Azure的用户.
I am the user of Azure.
我使用镜像"MicrosoftSQLServer:SQL2016SP1-WS2016:Enterprise:latest"创建了虚拟机
I created a Virtual Machine using the image "MicrosoftSQLServer:SQL2016SP1-WS2016:Enterprise:latest"
能够使用"Windows身份验证"成功登录SQL Server.
Successfully able to login into SQL server using "Windows Authentication"
启用了"sa"登录.当我尝试使用"SQL Server身份验证"登录时，它失败了.
Enabled the "sa" login. When i tried to login using "SQL server Authentication" it is failing.
即使我也观看了"https://channel9.msdn.com/Blogs/raw-tech/How-To-Fix-Login-Failed-for-User-Microsoft-SQL-Server-Error-18456"的视频-逐步-
Even I followed the video of "https://channel9.msdn.com/Blogs/raw-tech/How-To-Fix-Login-Failed-for-User-Microsoft-SQL-Server-Error-18456-Step-By-Step"
问题仍然存在.
有人可以为此提供一些解决步骤吗?
Can someone please provide some resolution steps for this
美好的一天 Medchal ，
Good day Medchal,
根据您的描述，您正在虚拟机上使用SQL Server，该虚拟机是托管基础结构(IaaS)-虚拟机是服务，而不是SQL Server或数据库.这是托管的
服务(PaaS)-获得数据库服务，但无法控制数据库的主机.
According to your description, you are using SQL Server on Virtual machine, which is hosted infrastructure (IaaS) - the Virtual Machine is the service and not the SQL Server or the Databases. This forum is for Azure SQL Database which is a hosted
service (PaaS) - you get service of database but cannot control the host of the database.
简而言之，您不在正确的论坛中，但让我们尝试解决这个问题(下次最好在正确的论坛中提问)
In short, you are not in the right forum for the question, but let's try to solve it (next time it is best to ask in the right forum)
1.使用sa时，您是尝试远程连接还是从虚拟机连接?
1. When you use sa, do you try to connect remotely or from in the virtual machine?
如果这是远程连接，请检查此教程:
https://docs .microsoft.com/en-us/azure/virtual-machines/windows/sql/virtual-machines-windows-sql-connect
If this is a remote connection then please check this tutorial:
https://docs.microsoft.com/en-us/azure/virtual-machines/windows/sql/virtual-machines-windows-sql-connect
我的猜测是您没有配置网络安全组"规则
My guess is that you did not configured the "Network security groups" rules
2.如果这样做不能解决您的问题，请提供您得到的完整的错误消息和屏幕截图
2. If this did not solve your issue, then please provide the full exact error message which you get and a screenshot
这篇关于无法使用AZURE VM中的SQL Server身份验证登录SQL Server的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
