Re: SQLCMD can't connect to SQL Server Express SP2

Did you open a port in the firewall?
Did you confirm that the SQL Server Browser Service is running on the Vista computer?
See http://msdn2.microsoft.com/en-us/library/ms345343.aspx
--
Rick Byham (MSFT)
This posting is provided "AS IS" with no warranties, and confers no rights.

"Klerman Gutierrez" <mcs@xxxxxxxxxxxxxxxxxxxxxxxx> wrote in message news:OuzvQrpXIHA.3652@xxxxxxxxxxxxxxxxxxxxxxx
Hello.
This is my first post here, and I don't know if this question has been answered before. I didn't see the answer at least in the topics I reviewed.
I have just installed SQL Server Express SP2 in a machine with Windows Vista Ultimate, but I can't connect to it with SQLCMD nor with OSQL.
I always receive a message like this (I'll translate from spanish):
"Named pipes connection provider can't open a connection to SQL Server"
I have followed the steps suggested in the Microsoft Support Site article number 914277 "How to configure SQL Server 2005 to allow remote connections", but still I receive the same messages.
Is there something else I should check in this machine ?
TVMIA,
Klerman Gutierrez




.

Relevant Pages

  • 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: Connection from remote computer to network SQL Server
    ... There is no firewall on the W2K machine acting as the SQL server. ... I tried making the SQL machine a "trusted" on the router. ... connection works. ... To find the IP address of your computer inside the network, ...
    (microsoft.public.access.adp.sqlserver)
  • ADO.net Orcas Samples Install Problem
    ... An error has occurred while establishing a connection to the server. ... When connecting to SQL Server 2005, this failure may be caused by the ... SqlInternalConnectionTds connHandler, Boolean ignoreSniOpenTimeout, ... or am I better off with a full SQL Server install. ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: OpenDataSource SQL Server xpress problem
    ... I tried your suggestions with some success. ... I tried setting up the .odc file through the Word Mail Merge wizard as ... If I work through the dialog to connect and then click the 'Test Connection' ... but I suspect it's because until recently most SQL Server ...
    (microsoft.public.word.mailmerge.fields)
  • Re: Exception trying to import data from Excel .
    ... An attempt to install Microsoft SQL Server 2005 this week has not gone ... The connection type "EXCEL" specified for connection manager ... to create a connection manager for an unknown connection type. ...
    (microsoft.public.sqlserver.tools)
Loading