SQL Server error
Posted on 2014-01-17
Could you please help on below error that we are getting in our end and cannot access DB Server. I am not very familiar with this error. Please post me how to troubleshoot this issue how we prevent from this in future( Can we setup any monitoring ?) . Thanks and much appreciates.
"In a nutshell, we are trying to use Linked Server to combine data from the SQL server and an Access file (no password on the Access file) but can't get the Linked Server to work. We tried to create the Linked using both Server Management Studio and T-SQL with the same result.
At the creation stage (sp_addlinkedserver) no errors are returned. However, all statements trying to use the linked server return some kind of error. The procedure sp_testlinkedserver is generating the error code 7303 but we are unable to resolve the issue."