Working Linked Servers

Hi,

I was thinking abt linked servers deals only with multiple servers
physically inter-connected.

Now i come accross that we can link our non-sqlserver databases also.
It is thru the E.manager by


Security->linked servers -> Other databases -> access(jet 7.0).mdb

if it is ok , all the tables under that given db will be listed , but
is not opening via E.M.


Accessing the linked servers.
----------------------------------
select * from raghu...tablename.

raghu is the linked server name.

It works nice. Even u can give the rights also.Hope this useful to the
beginners.


With thanks.

re: Working Linked Servers

Raghuraman wrote:[color=blue]
> Hi,
>
> I was thinking abt linked servers deals only with multiple servers
> physically inter-connected.
>
> Now i come accross that we can link our non-sqlserver databases also.
> It is thru the E.manager by
>
>
> Security->linked servers -> Other databases -> access(jet 7.0).mdb[/color]

Where do you find "Security" ? right-clicking on something, or in a menu
somewhere ?

/jim

re: Working Linked Servers

On Fri, 28 Nov 2003 12:05:57 +0100, "Jim Andersen"
<jimVÆÆK@officeconsult.dk> wrote:
[color=blue]
>Raghuraman wrote:[color=green]
>> Hi,
>>
>> I was thinking abt linked servers deals only with multiple servers
>> physically inter-connected.
>>
>> Now i come accross that we can link our non-sqlserver databases also.
>> It is thru the E.manager by
>>
>>
>> Security->linked servers -> Other databases -> access(jet 7.0).mdb[/color]
>
>Where do you find "Security" ? right-clicking on something, or in a menu
>somewhere ?
>
>/jim
>[/color]
It's in the default left pane of enterprise manager, once you have a
server selected, under replication. Perhaps you don't see it if you
aren't an admin?

re: Working Linked Servers

Lyndon Hills <lyndon@nospam.tenegi.com> wrote in message news:<pfcfsvo1tnukva0d8umr1rpiebmhsdo3cn@4ax.com>. ..[color=blue]
> On Fri, 28 Nov 2003 12:05:57 +0100, "Jim Andersen"
> <jimVÆÆK@officeconsult.dk> wrote:
>[color=green]
> >Raghuraman wrote:[color=darkred]
> >> Hi,
> >>
> >> I was thinking abt linked servers deals only with multiple servers
> >> physically inter-connected.
> >>
> >> Now i come accross that we can link our non-sqlserver databases also.
> >> It is thru the E.manager by
> >>
> >>
> >> Security->linked servers -> Other databases -> access(jet 7.0).mdb[/color]
> >
> >Where do you find "Security" ? right-clicking on something, or in a menu
> >somewhere ?
> >
> >/jim
> >[/color]
> It's in the default left pane of enterprise manager, once you have a
> server selected, under replication. Perhaps you don't see it if you
> aren't an admin?[/color]




------
Hi,

Hills


For working with linked servers , You replied like , one can not see
the login rights etc if the particular user is not in the admin role
in the Enter prise manager regarding the replication.



Since the E.Manager is a open book so that any one can access any
database , Do you explain me When the sql server E.manager aks the
user's login and password .


With thanks

RAGHU