Connecting to SQL Express after Unattended Install

SQLScott

Good afternoon,

I have written a .NET app that kicks off an unattended install of SQL Server Express Advanced. After the install, the same app tries to connect to SQL Express adn run a script that creates a database plus a few other things.

However, the problem I am having is that my app cannot connect. I get the error:

"An error has occurrred while establishing a connection to the server. This failure may be casued by the fact that under the default settings SQL Server does not allow remote connections."

However, the unattended install goes great. No problems there. I know this because I can Open SSMS, run queries, created DB's, etc. I also know that it is not the remote connections issue because the unattended install is set to allow remote connections (both names pipes and TCP/IP).

So, why can't i connect I don't need to reboot after the install do I Please tell me i don't...and please tell me it is something simple I am overlooking.

Thanks...

Andrea Montanari

hi,

did you provide the correct SQL Server instance name in the connection string

did you provide the right info in it

can we see your connection string

regards

Ekrem Önsoy

You know, there are two "allow remote connections" thing. One is in the SQL Server Properties\Connections and the other one is in SQL Server Surface Area Configuration. Be sure they are set correctly.

Jens K. Suessmeyer

If you mean the configuration in the configuration manager compared to the information from the surface configuration manager, they are the same. See the screencast on my site for more information about enabling remote connections.

Jens K. Suessmeyer

---
http://www.sqlserver2005.de

---