Unanswered: SQL Server 2005 Express connection problem!!
I`ve installed Visual C# 2005 Express edition for evaluation reasons. After that I also installed Microsoft SQL Server 2005 Express edition also for evaluation. I then downloaed the installation scripts for the Northwind database and tried to install them.
Unfortunately, every time I try to execute these scripts I get the error :
C:\SQL Server 2000 Sample Databases>osql -E -i instnwnd.sql
[SQL Native Client]Named Pipes Provider: Could not open a connection to SQL
[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
I`ve enabled named pipes in the configuration utility, but to no avail. This is also no firewall problem. It just can`t connect to SQL server. Anybody with similar problems or a possible remedy?
The script is trying to install to a default SQL instance (not a named instance), but SQL Express will only install as a named instance. You need to add a -S parameter to your OSQL command line to specify the server name.
instead of localhost use 'domain\server'.
if on a local machine its ur 'Computer name\named instance' where
named instance is usually 'sqlexpress' and computer name get from control panel ->system->computer name