Re: sqlxml bulk load permission error

From: Graeme Malcolm (graemem_cm_at_hotmail.com)
Date: 08/31/04 

Date: Tue, 31 Aug 2004 17:58:22 +0100

Just checking the obvious, is the server configured for Mixed authentication
(Windows and SQL Server Logins), or Windows authentication (only Windows
logins)? Windows authentication is the default.

I'm a little confused when you say you've "tried with the administrator and
the sa user". Administrator is a Windows login (so you wouldn't specify it
in a connection string; you'd use integrated authentication), SA is a SQL
Server login (so you would specify it in a connection string when the server
is configured for mixed authentication).

Can you post the exact error message?

Cheers,
Graeme 

-- 
----
Graeme Malcolm
Principal Technologist
Content Master Ltd.
www.contentmaster.com
"Chris Harrington" <charringtonDEL@ETEactiveinterface.com> wrote in message 
news:%23A8A%23g3jEHA.2680@TK2MSFTNGP15.phx.gbl...
Hi,
I wrote a script which uses SQLXML bulk. All is fine when I have a
connection string with
    Integrated Security=SSPI
but when I put in explicit passwords, I get "error connecting to the data
source". I have tried with the administrator and the sa user.
Thanks,
Chris

Relevant Pages