Problem connecting to SQL 2005 through SQLCMD

• Kekakos Elias

  SSC Veteran

  Points: 213

  More actions

  May 20, 2006 at 12:21 pm

  #112917

  Hello, I have a serious problem and I need a resolve as fast as you can. I have installed sql server 2005 express edition. By default the shared memory is enable and all others are disable. I enabled all of them and I tried to connect through the SQL MANAGER EXPRESS EDITION. Anyway I can login only with Network protocol SHARED MEMORY. But when I run the sqlcmd I have the following error:

  C:\Program Files\Microsoft SQL Server\90\Tools\Binn>sqlcmd -U sgvaultuser

  Password: HResult 0x7E, Level 16, State 1

  Shared Memory Provider: The Shared Memory dll used to connect to SQL Server 2000 was not found [126].

  Sqlcmd: Error: Microsoft 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..

  Sqlcmd: Error: Microsoft SQL Native Client : Login timeout expired.

  Can any one tell me why I cannot connect through the sqlcmd utility? I have WinXP SP2

  Thanks Elias

• David Scotland-132255

  SSCertifiable

  Points: 5599

  More actions

  May 20, 2006 at 12:48 pm

  #639127

  When you enable the other network protocols you meust restart the sql server service for this to take effect so once the service is restarted all the other protocols that you've enabled should work.

  sqlcmd will try by default to connect with whatever protocol you have set as number one in the list of protocols to force it to use the protocol you want you can change the syntax of the connection string slightly e.g to use shared memory

  sqlcmd -S lpc:<computer name>

  or to use TCP/IP

   

  sqlcmd -S tcp:<computer name>,<port number>

   

  hth

   

  David