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

While Working with SQLCMD in SQL Server 2005 I encountered following error.
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.

Reference : Pinal Dave (http://blog.SQLAuthority.com)

4 thoughts on “SQL SERVER – Fix: HResult 0x274D, Level 16, State 1 Error: Microsoft SQL Native Client : Login timeout expired.

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

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

    Like

  2. 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.

    Like

  3. 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

    Like

  4. 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.

    Like

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s