InstallAware

Hi. I just installed the demo version of InstallAware and I cannot get the MS Sql Server Connection sample to work. All I did was create a new project using the sample. I built it and run it. The dropdown does not show any of the sql servers that should exist. I manually type the name of the server and click next, but it says connection failed.

All the servers have SQL Server 2005.


Do I need to do something else in the sample? Any help is appreciated.


Thanks,
Dave

Hi Dave,

You need to enable mixed mode authentication and network connections to your servers. I believe this is documented in the help file entry for the SQL command.

Thanks for the quick reply. The settings on the servers allow windows authentication and sql server atuhentication and they all allow remote connections.


Can you think of any other possible issues?


Dave

Firewalls or other security software interfering with connections?

nope, no firewalls. It's all internal servers. I can connect to them from any machine using Sql Management studio.

Under which account are SQL Servers running?
It should be Network Service in order to work correctly.