How do I link an outside server to MS SQL 2005 server? - TechRepublic
Question
August 23, 2010 at 08:21 AM
cc3p0

How do I link an outside server to MS SQL 2005 server?

by cc3p0 . Updated 15 years, 10 months ago

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

This discussion is locked

All Comments