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
cannot install Northwind database in SQL Server Express
ScottieVBA
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
SimonP
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
mgoertz - msft
Hey! Thanks! I have search a lot before inding that (-S)
WillTartak
Hi Laurentiu,
No, I'm running SQL Server on the same machine.
Thanks for your reply,
Anthony