<div>
Please keep in mind that an instance is addressed by ServerName\InstanceName where a SQL default (instance) is addressed just by ServerName.<br />
You sould try and add the Linked server on the instance the same way or in SSMS instead and generate script from there to see the differences.
</div>


Please keep in mind that an instance is addressed by ServerName\InstanceName where a SQL default (instance) is addressed just by ServerName.
You sould try and add the Linked server on the instance the same way or in SSMS instead and generate script from there to see the differences.

<div>
I used the script from the default instance, so they are exactly the same<br />

</div>


I used the script from the default instance, so they are exactly the same


<div>
It must be some sort of permissions issue, though I have also logged on as the sever admin account, could there be a port being blocked? 
</div>


It must be some sort of permissions issue, though I have also logged on as the sever admin account, could there be a port being blocked?

<div>
<div class="content wysiwyg-content">
Hi Experts<br />
<br />
I have a linked server that works fine on the local (default) server istance, I have created a script from the linked server and run it on a different &nbsp;server instance on the same box with the same credentials.<br />
<br />
When I try and query the linked server on the different SQL server instance , I get the error message &nbsp;that the table doesnt exsit or the current user does not have permissions on that table.<br />
<br />
The table does exsit and I can use the same syntax on the default instance and it works as expected. <br />
<br />
Has anybody else had this problem and do they know how to resolve it?
</div>
</div>


Hi Experts

I have a linked server that works fine on the local (default) server istance, I have created a script from the linked server and run it on a different  server instance on the same box with the same credentials.

When I try and query the linked server on the different SQL server instance , I get the error message  that the table doesnt exsit or the current user does not have permissions on that table.

The table does exsit and I can use the same syntax on the default instance and it works as expected. 

Has anybody else had this problem and do they know how to resolve it?

Linked server does not work on SQL server instance but work on another

Microsoft SQL Server 2005 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. It includes support for managing XML data and allows a database server to be exposed over web services using Tabular Data Stream (TDS) packets encapsulated within SOAP (protocol) requests.