Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 SQL Server Administration (2005)
 sql error [sqlstate 42000][error 50000]

Author  Topic 

orlando876
Starting Member

15 Posts

Posted - 2009-04-03 : 13:54:23
i am getting this error when i run an sql in the job
executed as user: somthing\username. you are not authorized to delete or update the folder. some condition userid=SqlAdmin [sqlstate 42000][error 50000] the step fail
.
i tried to run it from SQL server management on the database it gave a similar error but the process was carried out.
any help would be greatly ppreciated

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2009-04-03 : 14:07:34
does somthing\username account has relevant permissions to folder?
Go to Top of Page

orlando876
Starting Member

15 Posts

Posted - 2009-04-03 : 14:52:38
I have tried to look at all the permission I also make sure the user is an windows domain user
Go to Top of Page
   

- Advertisement -