Re: SQL Server 2008 bulk load error

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

I appreciate your input. I am going to simply try to copy the raw data to a system that is a member of domain A - and eliminate the security context issues completely.

:)

Tibor Karaszi wrote:
I see. Thanks for the detailed explanation (needed for me since I don't have "trust issues" up to date). You didn't say what SQL command that your user is executing, but I going to assume BULK INSERT or INSERT with subselect haing OPENROWSET and the bulk provider. The point is to understand whether it is the SQL Server service which is accessing the file or something else (like Agent - if you are using a scheduled job and integration services; for example). Say that it *is* SQL Server that is accessing the file, then if the user in question has sysadmin SQL Server priviliges, then the service account is attempted. This sees to fit with what you are seeing. One thing that *might* be helpful is using Proxies and Credentials (see CREATE CREDENTIAL and Books Online index "proxy accounts [SQL Server Agent]"). I'm not entirely certain it will help, though since a) the user might be sysadmin and in that case the case *might* be that we'll habe no impersonation and b) your domain and trust setup (but here my Windows/Ad copetence starts failing me).

.

Relevant Pages

  • Re: Balancing security needs in ADO.NET applications
    ... See my article http://www.developer.com/db/article.php/3693236 that shows how to put together a hierarchical TableAdapter using SPs. ... Hitchhiker's Guide to Visual Studio and SQL Server ... SQL Server credentials or the application's logon/pw. ... all they can do is run specific SPs that carefully guard the data and do not permit gross operations like dropping tables or changing rights. ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Login failed for user . The user is not associated with a trusted SQL Server connection.
    ... he never mentioned he is impersonating in asp.net - so no delegation needed. ... Cassini runs with the credentials of the interactive user - which seems to have access to sql - in contrast to the local ASPNET account - which i am trying to tell him since 2 days.... ... yes - use explicit credentials and enable mixed mode auth in sql server to get this to work. ...
    (microsoft.public.dotnet.security)
  • Re: Balancing security needs in ADO.NET applications
    ... you can't control security at this level) user access is determined by their ... SQL Server credentials or the application's logon/pw. ... Hitchhiker's Guide to Visual Studio and SQL Server ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: IIS 6 and SQL Server - two seperate boxes
    ... make use of a risky solution. ... login to your SQL Server is that exploiting a "known vulnerability"? ... And the credentials could be stolen on ... the server (e.g. from a web.config file if you are using a static account), ...
    (microsoft.public.inetserver.iis.security)
  • RE: SQLXML Newbie Question...
    ... create SQL Server logins, but how do you pass the credentials to the service? ... Mark ... I want to plae my web service on the public internet but it needs ...
    (microsoft.public.sqlserver.xml)