Add the user to a fixed database role that has just enough permissions to accomplish their tasks. db_datareader and db_datawriter are a start for select, insert, update, delete permissions. It...

You need to allow remote connections in the SQL Server Surface Area Configuration utility found in your Configuration Tools folder.

You can also backup and move jobs by generating a SQL script after they have been created. Of course, to successfully recreate them on a different server by running the...

Remember that MSSQL '05 does not allow remote connections by default. Use SQL SSAC to make your db accessible to remote clients.

Snapshot or transactional replication from production server to reporting server should suffice. Log shipping would work for you as well. It depends on how often the information is updated and...