Page 1 of 1

MS SQL Instances

Posted: Thu Jul 20, 2006 5:41 am
by mikesm
Hi.

Has anybody except me problem with new plug-in MS SQL Instances?

I am trying InstallAware Studio 6 and i have a problem with "MS SQL Server connection" example, I don't know why, but this example doesn't work corect.

Concrete problem - sometimes MS SQL Instances doesn't return corect result, it returns nothing! The same example work correct on one computer, on second no!

Thanks

Posted: Thu Jul 20, 2006 5:56 am
by MichaelNesmith
This plug-in uses network connections. Make sure you do not have firewalls or other software potentially blocking connections - they might be the culprit in the errant behavior.

Posted: Fri Jul 21, 2006 3:14 am
by mikesm
I tryed it on 4 PCs connected to network. PC1 - there is SQL Server 2000.
I'm able to connect PC1/SQL Server 2000 from PC2(WXP SP2) but not from PC3(WXP SP2) and not from PC4 (W98).

I turned off the firewall too, installed MSDE 2000 on the localhost tryed plug-in on localhost, but result of SQL Instances on PC3 is nothing!

Posted: Fri Jul 21, 2006 4:07 am
by MichaelNesmith
Did you enable network protocols and mixed mode auth on the instances you are trying to connect to?

Posted: Fri Jul 21, 2006 4:17 am
by mikesm
Yes!
I'm able to connect and manage all servers and all instances by MS SQL Server plug-in, but I'm not able to see them from concrete PC (WXP SP2) by MS SQL Instances plug-in.

Posted: Fri Jul 21, 2006 5:16 am
by MichaelNesmith
Both plug-ins use the exact same connection mechanisms - in fact, they are built on the same code base.