Results 1 to 4 of 4
  1. #1
    Join Date
    Apr 2004

    Unanswered: SQL Server 2005 Express connection problem!!

    Hello everybody

    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
    Server [2].
    [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?

    George Papadopoulos

  2. #2
    Join Date
    Feb 2004
    In front of the computer
    Provided Answers: 54
    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.


  3. #3
    Join Date
    Apr 2004
    ok. This is how I gave the command now :

    osql -E -S localhost -i instnwnd.sql

    but, I still get the same error. Am I not using the command correctly?

    Do I also need to enter an instance name?
    Last edited by divined; 06-26-06 at 04:22.

  4. #4
    Join Date
    Mar 2006
    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

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts