MS Sql Server Connection sample problem

bunkscene · Post by **bunkscene** » Wed Nov 29, 2006 1:38 pm

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

MichaelNesmith · Post by **MichaelNesmith** » Wed Nov 29, 2006 2:05 pm

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.

bunkscene · Post by **bunkscene** » Wed Nov 29, 2006 2:54 pm

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

MichaelNesmith · Post by **MichaelNesmith** » Wed Nov 29, 2006 3:43 pm

Firewalls or other security software interfering with connections?

bunkscene · Post by **bunkscene** » Wed Nov 29, 2006 4:24 pm

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

Gizm0 · Post by **Gizm0** » Wed Nov 29, 2006 6:53 pm

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