The object actually has the EXECUTE permission. The EXECUTE permission was denied on the object 'sqlbackup', database 'master', schema 'dbo'. with no server or store procedures changes, it stopped working and is now giving this error: We do use redGate Backup Pro, so the store procedure inside calls that extended store procedure which is on master: dbo.sqlbackup. I would really appreciate, if someone can give me detailed steps explaning how to solve this problem.I developed a custom stored procedure that allows one of our developers to take the last full backup of a client that dropped service. Should I create a user called 'User1' on my MachineB(Destination Machine)? I generally login into my Windows 2003 Server machine with user called 'User1' and I use the same 'User1' to connect to SQL Server through the Management Studio Screen. Here are some details of the user that I use to login. How do I know which user is running the MSSQL Server service? Are they referring to the user which I use to connect to my SQL Server Database engine throuhg the SQL Server Management Studio?Īlso they are suggesting 'domain user', and as I said before I do not have domain network just regular simple workgroup network. Well it sounds plausible, but I don't know what are the exact steps to do this. "Check in Services and make sure that the MSSQLServer service is run asĪ domain user and that domain user has rights to these network I have already searched over the internet and I found out that loads of people have the same issue, and they were suggested something like this: Whenever I tried to execute the above piece of code, I get the error message "Access is denied", but if I try to copy the file from the Command Prompt (cmd.exe) with the copy command, the file copies fine over the network. Here is the T-SQL code that I am trying to execute:ĮXEC xp_cmdshell 'copy D:\Data\file.txt \\MachineB\Documents' I am having some trouble copying data over my workgroup network from my Windows 2003 Server Machine (machineA with SQL SERVER 2005) to one of my network Machine's drive(MachineB).
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |