I have a server that I need to link to an SQL server so employees can run reports through the report manager on the web interface. At one point the two servers were linked and working, but now I am missing several of my tables, views, etc. I’m running MS SQL Server 2005. I have been collecting a bunch of nightmares while trying to fix this problem in the Microsoft Server Management Studio. The outside server should be able to connect to SQL through an ODBC provider. I can’t figure out what I am doing wrong, any help would be greatly appreciated?
Thanks,
CC
