I am on the console of a server with a SQL Server 2008 installation.
I CAN successfully connect to the instance with this command: c:\> sqlcmd -E -S localhost\DW
I can NOT successfully connect with this one: c:\> sqlcmd -E -S localhost\DW,1433
- Remote Server connections are enabled under server properties, connections
- Under SQL Server configuration manager, "Protocols for DW" has TCP/IP enabled, TCP Dynamic Ports empty, TCP Port set to 1433.
- My firewall is shutdown
- I've restarted the SQL Server instance after config manager changes.
I receive this message:
HResult 0x274D, Level 16, State 1
TCP Provider: No connection could be made because the target machine actively refused it.
Sqlcmd: Error: Microsoft SQL Server Native Client 10.0 : A network-related or instance-specific error has occurred while establishing a connection to SQL Server. Server is not found or not accessible. Check if instance name is correct and if SQL Server
is configured to allow remote connections. For more information see SQL Server Books Online..Sqlcmd: Error: Microsoft SQL Server N
View Complete Post