Connect SQL Server 2005 through SQL-DMO

Hi,
I have installed in one computer a named instance of SQL Server 2005
Developer Edition. In that computer there is also a SQL Server 2000 instance,
which is the default. For SQL Server 2005 I have allowed local and remote
connections through TCP/IP. The SQL Browser service is active too. During the
installation I also installed the backward compatibility tools. The operating
system of the server is Windows 2000 Professional.
I am trying to execute an VB.NET app that uses SQL-DMO in order to create a
database and several logins and users in the SQL Server 2005 instance. When I
execute it on the server, the app works perfectly, but the problems appear
when I try the same from another computer. The client computer is another
Windows 2000 Professional, but just with the SQL Server 2000 client tools
installed, no SQL Server 2005 client tools.
I think that there may be missing some extra steps to configure the server
in order to allow remote connections throug SQL-DMO.
Any suggestions would be greatly appreciated.
Jose Antonio.
Jose Antonio wrote:
> Hi,
> I have installed in one computer a named instance of SQL Server 2005
> Developer Edition. In that computer there is also a SQL Server 2000
> instance, which is the default. For SQL Server 2005 I have allowed
> local and remote connections through TCP/IP. The SQL Browser service
> is active too. During the installation I also installed the backward
> compatibility tools. The operating system of the server is Windows
> 2000 Professional.
> I am trying to execute an VB.NET app that uses SQL-DMO in order to
> create a database and several logins and users in the SQL Server 2005
> instance. When I execute it on the server, the app works perfectly,
> but the problems appear when I try the same from another computer.
> The client computer is another Windows 2000 Professional, but just
> with the SQL Server 2000 client tools installed, no SQL Server 2005
> client tools.
> I think that there may be missing some extra steps to configure the
> server in order to allow remote connections throug SQL-DMO.
> Any suggestions would be greatly appreciated.
> Jose Antonio.
I believe that SQL 2005 comes with DMO for backward compatibility only
and that in order to use DMO on a SQL 2005 serve, you are going to need
either the DMO distributable files from SQL 2005 or have the SQL 2005
client tools installed.
David Gugick
Quest Software
www.quest.com
|||Hi David,
Yes, installing the backward compatibility package on the client computer
solved the problem.
Thanks.
Jose Antonio.
"David Gugick" wrote:

> Jose Antonio wrote:
> I believe that SQL 2005 comes with DMO for backward compatibility only
> and that in order to use DMO on a SQL 2005 serve, you are going to need
> either the DMO distributable files from SQL 2005 or have the SQL 2005
> client tools installed.
> --
> David Gugick
> Quest Software
> www.quest.com
>