Danb7183 (4/22/2009)The db_datawriter & db_reader gives the 'users' that are external to the domain all the rights that I believe they currently have (i.e. right to connect, add, delete, modify...

Glad I could help. @=)

Just went back to my old "Upgrading DBA skills to SQL 2005" book.

Before establishing a mirroring session, you must configure the communication mechanism through which mirroring will occur. This involves...

Ah, yes. You're absolutely correct on that. @=)

If it's an Active / Passive cluster, Steve, there won't be necessarily be multiple instances. One instance that swaps back and forth between the cluster as it fails is the...

Gift Peddie (4/21/2009)

---

You could do that but some of your intranet users will error out with Login failed and Null user errors because AD does not resolve Asp.net and SQL...

Dan,

I'm a little confused. Are you trying to create logins on a user-by-user basis or on an application-by-application basis?

I previously thought you were talking about the later. Now it sounds...

Mackempete (4/21/2009)

---

Ahh good idea I didnt think of that! I've just checked and it is set to use the SQL network name cluster resource rather than the individual node name....

DOH!

Ignore this problem / question, please. Sorry for wasting the bandwidth.

The developer who created the package forgot to put the destination connection strings in the config file, so on those...

Question, do you have your mirroring looking at the literal server name for the source? Or are you using the virtual cluster name for your mirrored source?

I'd say, at a...

Consider creating individual Domain User (plain vanilla, not admin) accounts and grouping them together in a AD Security Group. This way, you can manage all the actual group policies all...

All eight rows will show the same output. But package design was already completed a couple of weeks ago. I'm hoping to avoid major redesign given the dependencies on this...

This post is in the wrong forum. It should be in the T-SQL Forum, not SSIS. Ask the moderator to move it.

Is this a homework assignment?

Who created the package? What permissions did they save the package with?

It sounds like access to the package itself is restricted to a specific Username / password.