Linked server - Error 7412, 7311

• SQL Galaxy

  One Orange Chip

  Points: 29472

  More actions

  August 27, 2014 at 11:27 pm

  #292801

  I have created Linked server into SQL 2008 R2 - 64 bit instance.

  Remote Link server - SQL 2000.

  Execution failed due to as below errors, how to fix it this issues?

  Supports the interface, but returns a failure code when it is used. [SQLSTATE 42000] (Error 7311) OLE DB provider "SQLNCLI10" for linked server "Linkedserver.IPAddress" returned message "Unspecified error". [SQLSTATE 01000] (Error 7412) OLE DB provider "SQLNCLI10" for linked server " Linkedserver.IPAddress " returned message "The stored procedure required to complete this operation could not be found on the server. Please contact your system administrator.". [SQLSTATE 01000] (Error 7412). The step failed.

  SQL 2008 R2 - installation path is D drive. I checked at installation folder and instcat.sql file not avilable

  osql -U sa -P MyPassWord -S Database.IpAddress -i “D:\Program Files\Microsoft SQL Server\MSSQL\Install\instcat.sql”

  should i run these command for fixing that issues? I have doubt Database.IpAddress, does it link server IP or destination server IP?

  rgds

  ananda