Take a look at "Security Considerations for Integration Services" in BOL.  There are many links that you may find useful.  There are SSIS roles that can be used, and...

I watched the user stop MSSQL from EM, but I think you just shed some light on the subject.  I believe that both users are local admins on the server.  That...

If anyone knows the exact permissions needed in EM to stop MSSQL I would also like to know.  One day one of our SQL Servers mysteriously stopped and I asked...

Great links.  Thanks.

Linda

Don't forget the SQL 2005 is much more secure.  What worked for SQL 2000 (removing sysadmin) may not necessarily work for 2005 🙂

The application install completed and the 2 databases...

Granting sysadmin rights and then taking it away is what I wanted to avoid.  I would venture to guess that "something" would break after removing sysadmin.  I personally think it...

I forgot there was one persistent error in the Application Log (below), but it turns out that the person doing the install was typing in the incorrect password. 

#50070: Unable...

This happened to me before too.  Take a look under Tools\Replication\Configure Publishing, Subscribers, & Distribution.  Go to the Subscribers tab and hit the elipsis button to see the login name...

Look in the SQL 2005 Books on Line topic "Features Supported By the Editions of SQL Server 2005" and near the bottom you'll see that Peer-to-Peer is only available for...

When you set up Log Shipping, did you select the option to create a new database on the destination server?  If so, maybe there is a permission issue to copy...

You should download the Microsoft SQL Server 2005 Upgrade Advisor.  This will help you find upgrade problems before you actually upgrade.  You can also run a Profiler trace on your...

Don't forget that mirroring isn't actually available until sometime next year.  Also, if you have a very large database, you're going to need tons of disk space (for the mirrored...

Also, don't restore msdb from one server to another.  I did this once and made a bit of a mess 🙂  The sysjobs table contains a column called originating_server that...

I happened to watch a 2005 web cast the other day and the presenter mentioned that Log Shipping was available in the 2005 Enterprise & Standard editions.  I asked whether...

You might want to start by checking logs:  the SQL Server error log, the Log Shipping Monitor Backup History and Copy/Restore History (right click on Monitor).  Error 2754 in Books on...