Topic: Remote access sql server 2008
There are 2 servers Superac and Webac
Superac - windows server 2008, sql server 2008
Webac - windows server 2003, sql server 2005
On Webac all adjustments normally work... Remote access is included, the coordinator etc.
And here with 2008 I can not understand... Prompt :
I fulfill request on Webac to Superac
select * from OPENDATASOURCE (' SQLOLEDB ', ' Data Source=172.18.2.212; User ID=opt; Password=123456 ').ac.dbo. LP insert into OPENDATASOURCE (' SQLOLEDB ', ' Data Source=172.18.2.212; User ID=opt; Password=123456 ').ac.dbo. LP (login, pas) select ' qwq ', 12
The first select works, and insert is not present... The pancake was worn out... Why so ??
Msg 7343, Level 16, State 2, Line 11 The supplier of an OLE DB "SQLNCLI" for a linked server "(null)" cannot INSERT INTO the table "[SQLNCLI]".