Get error when 'dtsrun' is run on client machine. Error:
[dbnetlib][ConnectionOpen(Connect()). SQL Server does
not exist or 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
********************************
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"

Are you able to connect to SQL Server from this client machine, using the
same login credentials, via Query Analyzer or Enterprise Manager?

--
HTH,
Vyas, MVP (SQL Server)
http://vyaskn.tripod.com/
Is .NET important for a database professional?
http://vyaskn.tripod.com/poll.htm




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

Get error when 'dtsrun' is run on client machine. Error:
[dbnetlib][ConnectionOpen(Connect()). SQL Server does
not exist or 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
********************************
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"

Yes, I am able to connect via Query Analyzer and
Enterprise Manager.

The package being run outputs data to a directory(Access
file).

The SQL Server account used to run the package does not
have authorization to access the directory.

The only way to access the directory is to use windows
authentication where the user can be granted directory
sharing/security access.

Just wondering if there are any references to local server in your package.
Could you open the package from the client machine and run it interactively,
to see what happens?

--
HTH,
Vyas, MVP (SQL Server)
http://vyaskn.tripod.com/
Is .NET important for a database professional?
http://vyaskn.tripod.com/poll.htm




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

Yes, I am able to connect via Query Analyzer and
Enterprise Manager.

There was no 'local' server - used specific name of the
server.

Tried to run package with client Enterprise Manager - SQL
Server Account. Same error: "Access Denied".

Only way I have gotten it to run is with Windows
Authentication on the server. With Windows
Authentication I had access to the output directory.

The solution to my problem was to login using the
Enterprise Manager from a client computer - logging in
with a SQL Server username(was logging in using terminal
services and Windows Authentication). This way the
Package is be created with a client account.

Then when a Package is executed, it is executed with the
client authentications.

Thanks for input,
Jim Peters