SELECT *
FROM OPENROWSET('SQLOLEDB','yh';'sa';'king',
'SELECT * FROM pubs.dbo.authors ORDER BY au_lname, au_fname') AS a用名字可以正确访问.SELECT *
FROM OPENROWSET('SQLOLEDB','10.8.4.133';'sa';'king',
'SELECT * FROM pubs.dbo.authors ORDER BY au_lname, au_fname') AS a
用IP不能正确访问.为什么机器都在域里
FROM OPENROWSET('SQLOLEDB','yh';'sa';'king',
'SELECT * FROM pubs.dbo.authors ORDER BY au_lname, au_fname') AS a用名字可以正确访问.SELECT *
FROM OPENROWSET('SQLOLEDB','10.8.4.133';'sa';'king',
'SELECT * FROM pubs.dbo.authors ORDER BY au_lname, au_fname') AS a
用IP不能正确访问.为什么机器都在域里
用户 'sa' 登录失败。原因: 未与信任 SQL Server 连接相关联
为什么IP不行啊
from openrowset
(
'sqloledb','server=服务器IP址;database=databaseName;uid=userid;pwd=userpwd','select * from tableName'
)
这样我连接了下我们服务器,没有问题,可以连接上