Home Forums Programming General Upload directory in Stored Procedure RE: Upload directory in Stored Procedure

  • almost certainly permissions, because the call to disk is not going to use the account you are expecting it to.

    when you access any resource OUTSIDE of SQL server, like network shares, local hard drives and folders,

    SQL Server uses either the account set up as the proxy account, or if that is left blank(the default) it uses account it starts with to try and access the resource:

    or if the above was blank, the account in services:

    That account is often an account which has never logged into the domain, and was never assigned permissions to get to the local disk or network share.

    so you typically want to create a new user on the local machine or in active directory which would have access to the shared network resources in question, and then to change the startup account that SQl server is using;

    here's an example where i put in my account instead, with my domain account and password, and then i can test the shared path i was trying to access/use before;

    [/quote]

    Lowell


    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!