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
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 (http://blog.SQLAuthority.com)