RE: sp_addscriptexec ERROR
From: belgiozen (anonymous_at_discussions.microsoft.com)
Date: 02/20/04
- Next message: RS: "Re: Red X on publication and distribution agent"
- Previous message: Pascal Duchemin: "3rd party replication tool"
- In reply to: anonymous_at_discussions.microsoft.com: "RE: sp_addscriptexec ERROR"
- Messages sorted by: [ date ] [ thread ]
Date: Fri, 20 Feb 2004 12:12:36 -0800
The agent has permissions to write /read files to that
directory...It might be the client osql utility not to see
the network path.The client connects to server with sa
account...
>-----Original Message-----
>
>>-----Original Message-----
>>Maybe agent doesn't have permissions on that folder?
>>.
>>
>The sql agent process runs with LOCAL WINDOWS ADMIN and
>connects to database with SA account...
>
>May the problem be related with the connection type of
the
>user???
>The user conncts to Publisher by using a dial-up
>Connection, so they are not in the same network actually..
>When I run a select query in SYSMERGESCHEMACHANGES system
>table at the client, I see the SCHEMATEXT column in
>SYSMERGESCHEMACHANGES table is referenced as if the
>machine containing the referenced script is on the same
>network with the subscriber.
>The path is;
>1\\PFBUSINESS\FTPSHARE\20040219195526170
\UPDATE_GETPLAN.sql
>
>.
>
- Next message: RS: "Re: Red X on publication and distribution agent"
- Previous message: Pascal Duchemin: "3rd party replication tool"
- In reply to: anonymous_at_discussions.microsoft.com: "RE: sp_addscriptexec ERROR"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
