我正在尝试将Skyward数据库(进度数据库)连接到MS SQL Server。我在做什么连接?首先在系统DSN的ODBC管理器中建立到Progress数据库的ODBC连接。(在System DSN中,我正在为SQL Server选择ODBC驱动程序)。在安装过程中,我在服务器名称上输入IP地址。在那之后,我测试了我的连接,它给出了一个错误:连接未建立。我不知道为什么无法连接?我正在正确输入主机名。
之后,单击已配置的驱动程序
之后,如果我测试此连接。它失败了。
如果我选择其他驱动程序datadirect SQL Server
之后,我单击“测试连接”,它显示验证主机名和端口的错误
Please help me to connect skyward database and one more thing skyward is hosted on another server which is cloud-based.
Based on your screen shot showing the use of Integrated Authentication and it failing, you will want to confirm the account which you are signed on as and running the ODBC connection test as has appropriate permission to connect the applicable SQL Server instance.
Note: You may need to confirm this SQL security is in place with the database administrator(s) of the SQL Server instance.
You may need to manually specify the port which the ODBC connection will connect to the SQL Server instance in case it cannot find it dynamically or it's using the wrong port.
Click on Client Configuration from the Create a New Data Source to SQL Server window.
From the Add Network Library Configuration window, make sure the Dynamically determine port is unchecked and specify the port number in the Port number field.
Find Listening TCP Port for the SQL Server Instance
USE [master] EXEC xp_readerrorlog 0, 1, N'Server is listening on', 'any', NULL, NULL, N'asc' --EXEC xp_readerrorlog 0, 1, N'Server is listening on'
Note: You may need to get this information from the database administrator(s) of the SQL Server instance.
Consider using an SQL Login credential rather than using integrated authentication to authenticate to gain access to the SQL Server instance.
在“添加网络库配置”窗口中,检查“使用用户输入的登录ID和密码进行SQL Server身份验证”选项,然后将“登录ID”和“密码”放入这些字段中。
注意: 您可能需要与数据库管理员联系以进行此设置,以及获取用于此身份验证级别的登录ID和密码。
本文收集自互联网,转载请注明来源。
如有侵权,请联系[email protected] 删除。
我来说两句