The previous DBA had setup writing DB Maintenance Plan reports to a remote server. I am new to MSSQL (I primarily work with Oracle). I have configured another MSSQL 2000 server similar to previous ones, but the reports are not going into the remote database tables. Everything on the 'Reporting' tab for the DB Maint. Plan looks the same as older ones. Also, the SQL Agent service starts as a domain user, such as previous setups.
I am not sure what to check from here. I appreciate any help. Thanks.On SQL Agent, properties select forwading server to the new server you just setup.
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment