wincc跑在远程服务器140.80.0.24上,服务器上面的mssql已配置为可以使用sql server账户登录,且已新建一个具有权限的sql server账户wincc_db_reader,使用以下python脚本登录:
DSN = r'Provider=WinCCOLEDBProvider.1;' \
r'Catalog=CC_nj_dongl_23_03_29_10_56_44R;' \
r'Data Source=140.80.0.24\WINCC;' \
r'User ID=wincc_db_reader;' \
r'PassWord=_Asdzzz2233'
Source = r"Tag:R,('pv_ky\JL_PA_FQGJ_LT'),'2024-02-18 04:00:00.000000','2024-02-18 04:02:00.000000'"
Rs = win32com.client.Dispatch(r"ADODB.Recordset")
Rs.ActiveConnection = DSN
Rs.Source = Source
Rs.CursorType = 1
Rs.CursorLocation = 3
Rs.Open()
报错:
(-2147352567, '发生意外。', (0, 'Microsoft SQL Server Native Client 11.0', 'Login failed. The login is from an untrusted domain and cannot be used with Windows authentication.', None, 0, -2147467259), None)
请问该如何解决