MS SQL Instances

mikesm · Post by **mikesm** » Thu Jul 20, 2006 5:41 am

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

MichaelNesmith · Post by **MichaelNesmith** » Thu Jul 20, 2006 5:56 am

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.

mikesm · Post by **mikesm** » Fri Jul 21, 2006 3:14 am

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!

MichaelNesmith · Post by **MichaelNesmith** » Fri Jul 21, 2006 4:07 am

Did you enable network protocols and mixed mode auth on the instances you are trying to connect to?

mikesm · Post by **mikesm** » Fri Jul 21, 2006 4:17 am

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.

MichaelNesmith · Post by **MichaelNesmith** » Fri Jul 21, 2006 5:16 am

Both plug-ins use the exact same connection mechanisms - in fact, they are built on the same code base.