连接失败[{" code"：9056，" message"：“无法连接到SQL Server：'DESKTOP-R022H7L \\ MSSQLSERVER1'，数据库：'AdventureWorks2014'，用户：'pc-admin'。” ;}] [英] Connection failed [{"code":9056,"message":"Cannot connect to SQL Server: 'DESKTOP-R022H7L\\MSSQLSERVER1', Database: 'AdventureWorks2014', User: 'pc-admin'."}]
问题描述
我是初学者 在ADF中，我正在探索Azure数据工厂，从本地计算机sql server数据库中提取数据，并使用Azure数据工厂推送到azure blob。但是我面临着与本地sql server连接的问题。
I am beginner in ADF so just i am exploring the Azure data factory for pull the data from local computer sql server database and pushing to the azure blob using Azure data factory. but i am facing the issues with connect with local sql server.
我在建立链接服务和本地计算机sql server db之间的连接方面做了什么 -
what i have done to establish the connection between linked service and local computer sql server db-
步骤1-连接
步骤2创建链接服务。并选择sql server然后填写一些细节
step-2 create a linked service. and selected sql server then filled with some details
步骤3-创建集成运行时 - 创建与自托管的新集成并安装本地sql server机器的exc文件
step 3- created integration runtime- create new integration with self hosted and install the exc file where local sql server machine
step3-然后填写服务器主机：DESKTOP-R022H7L \ MSSQLSERVER1
step3- then filled with server host :DESKTOP-R022H7L\MSSQLSERVER1
step4- 数据库名称：AdventureWorks2014
step4- database name: AdventureWorks2014
step5 - 身份验证类型：SQL身份验证以及我尝试使用Windows身份验证。
step5 - Authentication type : SQL Authentication as well i tried with windows auth.
步骤6 - 用户：本地系统用户名如pc-admin，密码 - 这些系统的密码。
step 6 - user : local system user name like- pc-admin, password- password of those system.
所以请指导我如何完成这项任务。谢谢
So please guide me how to complete this task. thanks
推荐答案
您好，
您是否可以通过自带的计算机上的SQL Server Management Studio连接到此SQL Server是否安装了主机集成运行时？
Are you able to connect to this SQL Server via SQL Server Management Studio on the machine with self-hosted integration runtime installed?
这篇关于连接失败[{" code"：9056，" message"：“无法连接到SQL Server：'DESKTOP-R022H7L \\ MSSQLSERVER1'，数据库：'AdventureWorks2014'，用户：'pc-admin'。” ;}]的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
