cannot install Northwind database in SQL Server Express

Hi,

I tried to install the Northwind database into SQl Server Express via the instnwnd.sql script using the command line:

osql -E -i instnwnd.sql

after a time out though I get this message:

"[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
connections."

I already granted access to the administrator account on my machine.

Anyone knows what I need to do more?

Thanks in advance

greetings from Belgium,

Anthony

Are you running osql on the same machine as SQL Server or on a remote machine? If you are executing this on a remote machine, you need to enable remote connections.

Thanks
Laurentiu

|||

Hi Laurentiu,

No, I'm running SQL Server on the same machine.

Thanks for your reply,

Anthony

|||

You should specify the SQL Express instance name:

sqlcmd -E -S.\sqlexpress -i instnwnd.sql

The same will work for osql, of course. Make sure you type the dot. If you're connecting remotely, replace the dot with the machine name.

Thanks
Laurentiu