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.
| Author |
Topic |
|
steelkilt
Constraint Violating Yak Guru
255 Posts |
 Posted - 2003-12-23 : 11:48:31
|
| Hi. I'm trying to implement log shipping as described here on sqlteam forums and am running into permissions issues when I try to run the backup job that copies data to backup devices.What's happening is that win 2k is for some reason having a problem with my normal userid, which is a member of all the necessary admin groups. this userid lives in a domain outside of the SQL server's domain (sql server is a member server), but this has not been a problem in the past.the error message received is:"could not obtain information about windows nt group/user 'domain\username. sqlstate 42000 error 8198.microsoft has info on this at this link:http://support.microsoft.com/default.aspx?scid=kb;en-us;241643but the workaround suggests using a local account to solve the problem --this is not an option for me because I need to use the original, problem account to xcopy later on to another member SQL server. successful xcopy requires that the user account be an admin on the receiving server, and this is not do-able with a local account on the "sending" server because this local account does not appear in the win 2k "look in" selection box when I try to add it as an admin on receiving server.anyone had any experience with this problem?thx |
|
|
Wanderer
Master Smack Fu Yak Hacker
1168 Posts |
Posted - 2003-12-24 : 02:40:27
|
| umm .. just a thouhgt here ... sounds like you don't have trusted domains, since they are in 2 different domains. can this be set up ? Maybe people who know more about domains and trusted relationships could shoot down or expand upon this ...*#&#* *#&#* *#&#* *#&#* Chaos, Disorder and Panic ... my work is done here! |
 |
|
|
|
|
|
backup script fails w/ SQLSTATE 42000 error