Re: Trying to install the northwind database but run into problem

A couple of things:
1. If you're connecting from a remote machine, ensure remote connections are
enabled and for the right protocols (look for remote connections in the
Surface Area Configuration tool)
2. Explicitly specify the server and instance (if appropriate) names so
you're not accidentally connecting to the wrong default instance.

Look in the SQL Server event log to see if your connection attempt even made
it to SQL Server.


joe.

"TonyJ" <johansson.andersson@xxxxxxxxx> wrote in message
news:%238KqUojuHHA.4412@xxxxxxxxxxxxxxxxxxxxxxx
Hello!

I have found a document that says run from command line
osql -U sa -i [password] -i instnwnd.sql

This file instnwnd.sql exist from where I execute the osql/sqlcmd command

When I do so I get this error
"C:\Program\Microsoft Visual Studio .NET
03\SDK\v1.1\Samples\Setup>osql -U sa
-P [sa] -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
connections."

I can also read that osql does not support all feture of SQL Sever 2005
Use instead sqlcmd. I then tried with sqlcmd but this give this error
"C:\SQL Server 2000 Sample Databases>sqlcmd -U sa -P [sa] -i
instnwnd.sql
HResult 0x2, Level 16, State 1
Named Pipes Provider: Could not open a connection to SQL Server [2].
Sqlcmd: Error: Microsoft SQL Native Client : An error has occurred while
establi
shing a connection to the server. When connecting to SQL Server 2005, this
failu
re may be caused by the fact that under the default settings SQL Server
does
not
allow remote connections..
Sqlcmd: Error: Microsoft SQL Native Client : Login timeout expired".

I found that error HResult 0x2, Level 16, State 1
depends on TCP/IP is not enabled.
I set TCP/IP enabled and shared memory and names pipes. I have also
restarted the sql server but I
still get the same error.

Have you out there any suggestion

//Tony




.

Relevant Pages

  • RE: Shared Memory Provider error
    ... I tried the lpc sqlcmd and indeed got an error: ... Shared Memory Provider: The Shared Memory dll used to connect to SQL Server ... An error has occurred while establishing a connection to the server. ...
    (microsoft.public.sqlserver.connect)
  • Re: What is the best way to connect to a server not on the network?
    ... That 192 IP address is most likely not a remote one. ... but doesn't object to migrating the data to SQL server. ... I tried using ADO within Access to create a connection string to the remote ...
    (microsoft.public.access.modulesdaovba)
  • Re: Performance reduction of SQL 2005 server when connected from V
    ... Rick Byham (MSFT), SQL Server Books Online ... against the slow SQL 2005 remote server succesfully (through the SSMSE ... will tell you what process ID is your current connection. ...
    (microsoft.public.sqlserver.connect)
  • Re: Error "SQL Server does not allow remote connections"
    ... The application could not connect to the sql server db. ... network is blocking the connection. ... SqlInternalConnectionTds connHandler, Boolean ignoreSniOpenTimeout, Int64 ... integratedSecurity, SqlConnection owningObject) +737554 ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: Performance reduction of SQL 2005 server when connected from V
    ... One of my computers says 9.0.9091.2 but that computer has a future build of SQL Server on it, ... will tell you what process ID is your current connection. ... How can I check out if the SQL Server Native Client version is the same ... > found no reduction in the speed of the SQL 2005 server remote> connection. ...
    (microsoft.public.sqlserver.connect)
Loading