运行sqoop连接sqlserver的命令碰到如下问题:
问题:WARN tool.EvalSqlTool: SQL exception executing statement: com.microsoft.sqlserver.jdbc.SQLServerException: 用户 ‘sa’ 登录失败。 ClientConnectionId:4a96ee65-f785-40fd-9377-2ba0a679b4fe
问题: WARN tool.EvalSqlTool: SQL exception executing statement: com.microsoft.sqlserver.jdbc.SQLServerException: The TCP/IP connection to the host 192.168.13.241, port 1435 has failed. Error: “拒绝连接. Verify the connection properties. Make sure that an instance of SQL Server is running on the host and accepting TCP/IP connections at the port. Make sure that TCP connections to the port are not blocked by a firewall.”.
上述问题可以总结为一个问题
解决的方法是
刚刚开始的时候我们本地ip还是241,但是本地ip变了没发现
把这里的ip也改一下,然后重新启动一个sqlserver,一定要重新启动。