December 17, 2008 at 10:24 am
Good Morning All,
This topic is not exactly a SQL question, but it is remotely related. Via SQL DB backups. Maybe someone could advise me as to a solution. I have asked this question on another forum but have received no answer.
This is the problem that I am encountering.
I have moved some of my databases to another server within the same domain. When I try to backup the DB's I am getting an error that states I do not have the "rights" to the \\server\share.
Using this command " \\server\share" I can hit the share from any other server on the domain, it is just from this one particular server that the problem occurs. Is there a security setting that needs to be changed or set?
Looking at the event logs I am seeing these errors(*):
*Windows cannot bind to domain. (Local Error). Group Policy processing aborted.
* Windows cannot query for the list of Group Policy objects. Check the event log for possible messages previously logged by the policy engine that describes the reason for this.
At this point I am stumped, can someone advise me as to a solution?
Regards,
Paul
December 17, 2008 at 10:43 am
This is just a preliminary guess...
Although *you* can access the share... can the sql server login account that is doing the backups access it?
December 17, 2008 at 10:58 am
Hi Seth,
Thank you for your reply. Yes, I am running the backup with administrator credentials. The problem seems to be a setting on the "server" that we moved some the DB's. The functionality of the backup application we wrote has been working for a quite a while; it continues to function correctly on the other servers where the DB's are being backed from. It is just when I try to copy the backups from this "new" server that the access problems are now occurring.
The reason that we moved the DB's to a different server is that we are migrating the DB's from SQL 2005 to SQL 2008. So we installed SQL 2008 on this "new" server to test before migrating the rest to SQL 2008.
Regards,
Paul
December 17, 2008 at 11:08 am
When you say you are running the backups with administrator credentials - what does that mean?
Can you find out what user is running the SQL Server service and what user is running the SQL Server Agent service? If this is a domain account - does that domain account have access to the file share?
If it is not a domain account running those services - that is going to be your problem.
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
December 17, 2008 at 12:01 pm
Good Morning,
The problem seems to be an active directory authentication issue. The server in question does not have a object in the AD for it under computers. We have tried several times to create the server object in AD with no luck. We are going to take another approach.
Thanks and Regards,
Paul
These are the log errors we have received:
*Windows cannot bind to domain. (Local Error). Group Policy processing aborted.
* Windows cannot query for the list of Group Policy objects. Check the event log for possible messages previously logged by the policy engine that describes the reason for this.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply