connection problem

From: JW (juanaonline@yahoo.com)
Date: 09/10/02 

From: "JW" <juanaonline@yahoo.com>
Date: Mon, 9 Sep 2002 15:43:06 -0700

You can use the linked server feature on SQLServer. Before
use the remote server name directly in your script, set up
this remote server as a linked server first in your local
server. Or you can use OpenRowset statement to dynamically
connect to the remote server on the fly.

>-----Original Message-----
>hi all
>
> Im trying to connect to remote database in the Query
Analyser ,when i
>try to run a select statement i get this error
> Login failed for user (My window user). And i know
the user name and
>password to connect to
> remote database name,but i dont know how to specify
them in the
>statement.
>
>
>thanks in advance
>rohith
>
>
>.
>

Relevant Pages

  • Re: copying data from one server to another
    ... EXEC sp_addlinkedserver 'RemoteServer', N'SQL Server' ... Based on security settings you may need to map remote server logins. ... Then you just run a normal query referencing the linked server table with 4 ... 'SET IDENTITY_INSERT ON' before execute insert ...
    (comp.databases.ms-sqlserver)
  • RE: dbcc against remote sql server
    ... SQLPERFwith a remote server as a linked server. ... If there is anything I misunderstood, ... create a stored procedure on the remote linked server first: ...
    (microsoft.public.sqlserver.programming)
  • Linked server using ODBC Provider and DB transaction.
    ... I need to have some stored procedure that reference a linked server but not ... provider going to a ODBC System DSN to the remote server. ... but I also need to have transaction. ...
    (microsoft.public.sqlserver.odbc)
  • Problem with Linkserver and new user
    ... If this via NT Authentication then check the security tab ... on the linked server and ensure that option "Be made using ... Otherwise map the user's account to a specific remote user ... >Access to the remote server is denied because no login- ...
    (microsoft.public.sqlserver.programming)
  • RE: remote scripting how to
    ... I re-engineered the following script from the example ... if i check taskmanager i can see the exe sitting there on the ... remote server but not doing what its supose to do, ... > will launch a file remotely on a machine, or copy the file to launch on the ...
    (microsoft.public.windows.server.scripting)