Access right's for executing stored procedure on sql server

  • Hello

    I have a stored procedure generating a xml file populated with values from my database, when i run it directly from my mssql server it

    runs fine and works, but when i try to execute it from my client running delphi and using ADOConnection and is a part of the workgroup all the xml elements in the xml file is empty. I send argument's with my stored procedure and it is no problem , Is missing access right's the reason for this behavior and have you any solution's for this problem?

    I appreciate any answer

  • Is the account you're using to connect from Delphi the same account you're using when you run the stored procedure directly?

    K. Brian Kelley
    @kbriankelley

  • Yes it's the same account with the same password

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply