SQL 2005 remote connection
I really enjoy the new SQL 2005 management studio, everything I need in one location. However I have issues when I try to connect to any production databases (SQL 2000 or 2005).
In the Connect To Server windows, if I browse for any remote services, I can see my databases, but I have all the time the same message if I try to connect to one of them ‘under the default settings SQL Server does not allow remote connections (provider, etc…)
I double checked SQL Surface tool and Named Pipes and TCP/IP protocols are enabled, I read already few blogs and forums on the subject, but still don’t know what to do.
Any help?