Hello Everyone,
I am seeking your advice. Currently, I have been trying to figure out how to integrate two backend SQL 2000 databases running under the same default instance/non clustered environment. One database is hosting my LANDesk 8.01 environment and runs under the sa/mixed mode. The other database hosts SMS 2003 running in windows authentication mode. Both require the default instance.
I am looking for any assitance including docs or links in integrating the two backend databases with the goal of central reporting (on the two). (in whatever way works, most likely Crystal Reports but also HTML).
Thanks,
-Matt
I am seeking your advice. Currently, I have been trying to figure out how to integrate two backend SQL 2000 databases running under the same default instance/non clustered environment. One database is hosting my LANDesk 8.01 environment and runs under the sa/mixed mode. The other database hosts SMS 2003 running in windows authentication mode. Both require the default instance.
I am looking for any assitance including docs or links in integrating the two backend databases with the goal of central reporting (on the two). (in whatever way works, most likely Crystal Reports but also HTML).
Thanks,
-Matt