Sql with installaware

[rajanji]

I am using Installaware studio edition and having problem installing SQL Server using Installaware.

I have a VB.NET Applicaiton that uses SQL SERVER Standard Edition database and i am using installaware to create database on client machine.

I have included SQL EXPRESS with SP3 runtime and just loaded a sql script and when i am installing it on client machine its showing some error 40 .

Need help on this ...

If am not using the correct way to configure SQL database from installaware kindly suggest or advice where is the problem

Thanks and Regards,
Rajan Arora.

[sashi]

SQL SERVER – Fix : Error : 40 – could not open a connection to SQL server.

An error has occurred while establishing a connection to the server when connecting to SQL server 2005, this failure may be caused by the fact that under default settings SQL server does not allow remote connection. ( provider: Named Pipes Provider, error: 40 – could not open a connection to SQL server. )

Fix/Workaround/Solution:
Step 1) Make sure SQL SERVER is up and the instance you try to connect is running.
Step 2) Your system Firewall should not block SQL Server port.
Step 3) Go to Computer Management >> Service and Application >> SQL Server 2005 Configuration >> Network Configuration
Enable TCP/IP protocol. Make sure that SQL SERVER port is by Default 1433.
Step 4) Now follow this KB Article of MSDN depending on your server.

SQL Error : 40

[rajanji]

How to make these settings happen on client computer using installaware so that the client does not face this problem because my client would want na to just install the program and use it.