SQL SERVER – Fix: HResult 0x274D, SQLCMD Level 16, State 1 Error: Microsoft SQL Native Client : Login timeout expired

SQL SERVER - Fix: HResult 0x274D, SQLCMD Level 16, State 1 Error: Microsoft SQL Native Client : Login timeout expired tcpip While Working with SQLCMD in SQL Server 2005 I encountered following error. Let us learn in this blog post how we can solve Fix: HResult 0x274D, Level 16, State 1 Error: Microsoft SQL Native Client : Login timeout expired.

HResult 0x274D, LEVEL 16, State 1
TCP Provider: No connection could be made because the target
machine actively refused it.
Sqlcmd: Error: Microsoft SQL Native Client : An error has
occurred WHILE establishing a connection TO the server. WHEN
connecting TO SQL Server2005, 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

Solution/Fix/WorkAround:

By default SQL Server 2005 has TCP/IP connections disabled. To enable TCP/IP support, use the SQL Server Configuration Manager tool, select SQL Server 2005 Network Configuration, select Protocols, double-click onTCP/IP, and turn on Enabled.

Question: I just installed the latest version of SQL Server and now I am not able to find SQL Server Configuration Manager. What should I do?

Here is another blog post on this subject: How to Find Missing SQL Server Configuration Manager? – Interview Question of the Week #089

Please leave a comment with your experience.

Reference: Pinal Dave (https://blog.sqlauthority.com)

SQL Error Messages, SQL Server, SQL Server Security, sqlcmd
Previous Post
SQL SERVER – T-SQL Paging Query Technique Comparison – SQL 2000 vs SQL 2005
Next Post
SQL SERVER – Performance Optimization of SQL Query and FileGroups

Related Posts

4 Comments. Leave new

  • Girish Sumaria
    July 12, 2007 1:07 am

    Can I connect to SQLSERVER 2005 database from SQLSERVER 2000 Query Analyzer?

    Can I Subscribe from SQLSERVER 2005 database to SQLSERVER 2000 publication?

    Reply
  • i m working for a project in jsp for that ii need to connect it with sql server 2005
    there is a problem while creating a DSN to SQL server 2005

    i had enabled all the settings in sql server configuration manager,including TCP/IP, and named pipes
    but still i m not able to create dsn, so i request yoy to please solve my problem.

    the error i m getting

    [SQL Native Client]Named Pipes Provider: Could not open a connection to SQL Server [53].
    [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.

    Reply
  • Hello Pinal Sir,

    I am developing one application that required to field a record as select from one combo and fill that record in to another combo that record is fetch from two different tables. it is working fine when records is less but when records are in large amount then it is giving an exception of timeout expired.

    I tried a set timeout property in connection string but it is not not beneficial to me.

    If u have any other solution then please reply me.

    Ankt Gusnai
    Junior .Net Devloper

    Reply
  • Hello pinal sir,

    I have Installed SQL Server 2008 Express R2.

    Now i want my colleges to connect with my SQL Server Express.
    while installing i have checked both Windows and SQL Server Authentication.

    i am login with both the way. Windows and SQL Server ( userid and password ).
    but my colleges not able to connet it.
    we are on same network.

    I have enabled TCP/IP. but still my colleges not able to connet my sql server express 2008 R2 database.

    what should i have to do.
    pls send me link or help to workaronds this problem.

    thank you.

    Reply

Leave a Reply