Re: Distributed Query - Linked Servers?

Hi Gerry

This is Mark Han, the Microsoft SQl Serve support engineer. I'm glas to
assist you with the issue.

according to your description, I understand that you would like to let the
linked server work. As I explain before, please send an emai to me. I have
make a detail list for you to configure the double hop linked server. my
email is v-fathan@xxxxxxxxxxxxxxxxxxxx(please remove the online).

Besides, to configure a linked server is based on the scenario. I need to
registry SPN for the 2 SQL Server and other setting on the AD. To explain
the setting in detail, we need show you some screen-shot but the
screen-shot is not convenient to be attached in the post. So it is
suggested to give me a email.

I look forward to hearing from you.

Best regards,
Mark Han
Microsoft Online Community Support
=========================================================
Delighting our customers is our #1 priority. We welcome your
comments and suggestions about how we can improve the
support we provide to you. Please feel free to let my manager
know what you think of the level of service provided. You can
send feedback directly to my manager at: msdnmg@xxxxxxxxxxxxxx
=========================================================
This posting is provided "AS IS" with no warranties, and confers no rights.
=========================================================

.

Relevant Pages

  • RE: Linked server 7302 error
    ... button for each of the 'Access Permissions' ... the startup account for the SQL Server service is in the ... Microsoft Online Partner Support ... Under the linked server security tab, ...
    (microsoft.public.sqlserver.connect)
  • RE: Script-Out Linked Server?
    ... There is no script out function available for Linked Server. ... to add the Linked Server is using the following TSQL script: ... Microsoft Online Community Support ... where an initial response from the community or a Microsoft Support ...
    (microsoft.public.sqlserver.setup)
  • RE: securing Access to DB on remote Server
    ... SQL instances/servers via linked server. ... Microsoft Online Community Support ... where an initial response from the community or a Microsoft Support ...
    (microsoft.public.sqlserver.security)
  • RE: DAO SQL Linked Server code reference
    ... Could you let me know which linked server are you going to select from? ... If it is a linked server that is linked to your SQL Server default ... Microsoft Online Community Support ... where an initial response from the community or a Microsoft Support ...
    (microsoft.public.data.oledb)
  • RE: 0x80004005 - you need permission to view its data
    ... The first one says to install the latest Jet service pack on the server, ... When I use enterprise manager to browse the linked server from the SQL ... server machine I can see the tables in the database. ... > Access 97 has been out of support boundary and is not officially supported. ...
    (microsoft.public.sqlserver.security)
Loading