Get error when 'dtsrun' is run on client machine. Error:
[ConnectionOpen(Connect()). SQL Server does not exist of
access denied.

'Access denied' - no authorization outside the server.
What kind of security authorization is necessary?

Thanks,
Jim

********************************
SQL Server 2000 on Windows 2003
Client - Windows XP with SQL 2000 client

DTSRUN with what parameters.

DTSRUN with no parameters is probably looking locally and seeing as you only
have the client you have no server hence the "Server does not exist"
message.



--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.allisonmitchell.com - Expert SQL Server Consultancy.
www.SQLDTS.com - The site for all your DTS needs.
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org


"Jim Peters" <anonymous (AT) discussions (DOT) microsoft.com> wrote

Parameters:

DTSRun /S "blindset"
/U "will"
/P "yates"
/N "Accounting_Claims_Paid_Detail"
/G "{AE56D92F-C9C7-4DAB-9AF0-857DC02675C2}"
/A "startdate":"7"="11/15/03"
/A "enddate":"7"="12/1/03"
/W "0"

OK

Can you do

Start | Run | isqlw -Sblindset -Uwill -Pyates



--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.allisonmitchell.com - Expert SQL Server Consultancy.
www.SQLDTS.com - The site for all your DTS needs.
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org


"Jim Peters" <anonymous (AT) discussions (DOT) microsoft.com> wrote