Well, it looks like youre using windows auth. In such a case, you need to make sure that the acct you're using has rights in sql. It also...

As long as you have a method, it doesn't matter if there's a better one. You're going to do this only once really and any method will only vary...

Well, there are much better ways to do what you're trying to do. Why don't you just copy the data from the tables over instead? You can try...

Y, I've run it a couple times too. Though I wouldn't use it for anything with really high transactions, it worked really well for our lesser sql boxes.

Y, I used to do french support for MS and you've definitely got a lang problem here.

MSDN has different langs posted, but barring that, here's the french download for sql...

Y, it sounds like you're doing a ton of stuff in a single transaction. Simple mode won't help you in that case because it's a single trans. So...

Sounds like you've got some issues to work out then...

Correct.

It's in db properties, not server properties.

An excellent plan if I've ever heard one...

If you have it in synch mode, just remember that anything you do on the primary has to be done on the mirror...

Go into DB properties and give him 'view database state'. I'm having a hard time finding all the perms that gives, but it sounds like a good place to...

Well, keep in mind that the mirror in unavailable to anything until it's brought online. That means that there really isn't any maint you can do on it....

Excellent... now it's just a matter of time.

Did we ever establish SQL2K or 2K5?

OK, let's isolate the problem. Give him sa and have him connect from his workstation. Then have him connect from another box. This way we'll see if...

Maybe start with the obvious. How are the packages failing? What's the erorr he'd getting?

I'd start there, and move on to a profiler trace of security activity when...