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 th
e
installation I also installed the backward compatibility tools. The operatin
g
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.Hi, Jose
I think you need to install the backward compatibility components on
the client computer. You can download them from:
http://download.microsoft.com/downl...rver2005_BC.msi
Razvan|||I have just installed the components on the client machine and the app now
works perfectly.
Thank you very much for your advice, Razvan.
Jose Antonio.
"Razvan Socol" wrote:
> Hi, Jose
> I think you need to install the backward compatibility components on
> the client computer. You can download them from:
> http://download.microsoft.com/downl...rver2005_BC.msi
> Razvan
>
No comments:
Post a Comment