SQL Server Performance Forum – Threads Archive

Enterprise Library 2005

Hi all I tried setting up the quick start database script in SQL 2005 Express and I got this message: =========================================================
SetUpQuickStartsDB
Creates the tables required for the Data Access
QuickStart. The tables are created in the database
EntLibQuickStarts. The script will create the
database if it does not exist.
========================================================= —————————————-
SetUpQuickStartsDB.bat Started
—————————————- [SQL Native Client]VIA Provider: The specified module could not be found.
[SQL Native Client]Login timeout expired
[SQL Native Client]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 the default settings SQL Server does not allow remote
connections. —————————————-
SetUpQuickStartsDB.bat Completed
—————————————- Press any key to continue . . . ———————————————-
I have set the server to allow remote connections? Help!

Referhttp://blogs.msdn.com/sql_protocols/archive/2005/10/29/486861.aspx &http://blogs.msdn.com/sql_protocols/archive/2005/10/22/483684.aspx and I feel though it is not a direct solution, but worth to check it. Satya SKJ
Contributing Editor & Forums Moderator
http://www.SQL-Server-Performance.Com
This posting is provided â€œAS ISâ€ with no rights for the sake of knowledge sharing.

Yes, Express does not allow network connections until you configure it to. Use the SQL Server Configuration Manager to allow network connections.

Or the Surface Area Configuration utility.

]]>