Re: schedule job - login in dynamic sql

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: kriste (kriste_l_at_hotmail.com)
Date: 03/23/04 

Date: Tue, 23 Mar 2004 23:22:41 +0800

Can someone pls help me out on this?

"kriste" <kriste_l@hotmail.com> wrote in message
news:uhl8NHKEEHA.3016@TK2MSFTNGP11.phx.gbl...
> Hi Greg,
>
> This is how I setup the link server.. I create the link server @ SQL-EM
and
> entered the id/password.
> At the query, I was able to call up and access the link server.
>
> Eg. Server A, link server B.
> I have a job in server A where it includes 2 steps, on succeed of step 1,
> step 2 that use the
> dynamic sql (embedded with link server B) will be run. The problem now is
I
> have id/password problem in running step 2.
>
> I don't understand what do u mean by openrowset. This is a sp and not
> calling from program to do updating.
>
>
> "Greg Obleshchuk" <greg-n-o-s-p-a-m-@ag-s-o-f-t-w-a-r-e.com> wrote in
> message news:%23kaZbgJEEHA.3256@TK2MSFTNGP09.phx.gbl...
> > Hi,
> > The schedular is not doubt run with a different password than your user
> (via
> > QA). You link server sounds like it is set-up to pass through current
> User
> > ID.
> > You can set up the link server to use a single User ID and password but
> that
> > would mean that anyone using that linked server would have the same
access
> > (Which might be update and something you might not want)
> >
> > You could always try using openrowset, which allows you to pass the USER
> ID
> > and password through to the other server and doesn't require a linked
> server
> > entry.
> >
> > regards
> > Greg
> >
> >
> > "kriste" <kriste_l@hotmail.com> wrote in message
> > news:#yo1GgIEEHA.3424@tk2msftngp13.phx.gbl...
> > Hi,
> >
> > I've created a sp that used dynamic sql and embedded with linked server
> > name. It was tested working @ the query analyser.
> > But when that was placed in the schedule job to be run, it give error
that
> > login/password was incorrect.
> >
> > Both my servers maintained difference set of login/password. Can someone
> > highlight me how should I set the login/password that sp in the job?
> >
> > thx.
> >
> >
>
>

Relevant Pages

  • Re: SQL Server Upgrade MSP Error: 29538 on KB934458 Upgrade
    ... Greg also can use this workaround to solve his issue. ... Server Setup asks and try running Setup again and please tell us what ... > installation aborts I assume in an inconsistent state. ...
    (microsoft.public.sqlserver.setup)
  • Re: Server Not Responding
    ... > Hi Greg, ... > Welcome the public newsgroup. ... > As for the issue that certain user cannot log on the SBS server, ... > 822158 Virus scanning recommendations on a Windows 2000 or on a Windows ...
    (microsoft.public.windows.server.sbs)
  • Re: [SLE] [Resolved] Help with swat (from Samba)
    ... >I don't run X on my servers, so only having localhost access gave the ... >> I upgraded a test server directly from 9.0 to 10.0 ... >> Greg Freemyer ... Please note - Due to the intense volume of spam, we have installed site-wide spam ...
    (SuSE)
  • Re: net logon service not running
    ... Hey Greg, I would start by removing the updates one at a time..this has ... I have a test bench server that I am going to do just that in a few minutes ... I had them restart the server, ...
    (microsoft.public.windows.server.active_directory)
  • Re: laptop question for this or the mobile group?
    ... > Hi Greg and all: ... > display and the windows etc are not displayed properly (too large for the ... Killing X server doesnt work, ... This was on a Dell Inspiron 5100, and it's caused by incorrect mapping ...
    (freebsd-questions)