>I backed up a SQL database on a server and restored the database onto another server. The database on the source server is functioning properly. Both servers are up and running properly with the existing databases that are currently on the servers. After restoring the database onto the destination server, I attempted to open a table and return the top X number of rows. However, I received "Provider can not be found. It may not be properly installed." I need a solution to correct the problem.
How do you access the database? Can you access it with Enterprise Manager?
--sb--