What about seperating your networks using VLAN's?

I must agree. You will need to remove the info from the msdb.

Need error messages to assist further.

Depends if the app is web based or a console application. It also depends on what they are running on their desktop, how much memory is available on the desktop,...

servername, port number (hostname,XXXX) or

ip address, portnumber (x.x.x.x, xxxx).

Not something i would recommend. tread lightly.

He is only concerned about events outside the application. You can control access for users using groups. If the member is a member of any group that has a denied...

Remove the users windows account. Supply them with the SQL account information (Should have read-only access). Have them use this account to query. Create a ODBC connection using the SQL...

Thanks for the assistance. Greatly appreciated.

I have a product for you. I ran into this when I was Moving DB's from one server to another. http://www.sqldts.com/242.aspx DTSBackup2000 Works great for moving jobs between or just...