Take the 2-minute tour ×
Server Fault is a question and answer site for system and network administrators. It's 100% free, no registration required.

I have 2 servers that are on different domains.

Server 1 - Windows Server 2003, SQL Server 2008 Server 2 - Windows Server 2008 R2

On Server 2 I have customer management software that connects to the SQL Server on Server 1. Server 2 is supposed to replace an older server.

Old Server - Windows Server 2003.

In the old setup the customer software was on Old Server and connected to Server 1 no problem (SQL Authentication). Now if I try to connect from Server 2 (customer software) to Server 1 (SQL Server) I get the following error.

To connect to this server you must use SQL Server Management Studio or SQL Server Management Objects (SMO)

I have installed SSMS 2008, Connectivity SDK, and Compatibility Components on Server 2 as some websites suggested this was the problem. They did not help.

Note that on Server 2 I can successfully setup and test a DSN and connected via SSMS but just not with the software.

Does anyone have any ideas?

share|improve this question

1 Answer 1

Did you try installing the Microsoft SQL Server 2008 Management Objects Collections (from here) ?

That is the SMO (Shared Management Objects) that it mentions in the error message and it is the replacement for DMO which is part of 'Microsoft SQL Server 2005 Backward Compatibility Components' which I assume is what you have already tried.

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.