InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comSun, 26 May 2013 01:40:42 GMT20http://www.sqlservercentral.com/Forums/Topic1381875-1292-1.aspxThanks Richard. Yes I have enabled TCP/IP for remote connections. And I can ping the hosting machine from the remote machine.Mon, 04 Feb 2013 06:38:12 GMTandy.gardnerhttp://www.sqlservercentral.com/Forums/Topic1381875-1292-1.aspx@andy.gardnerWhen you say "remote connections are enabled" are you referring to the TCP/IP protocol in Configuration Manager? If not, check it - it is disabled by default for SQL Express.Have you also checked that you can ping and telnet from the remote machine?P.S.Just noticed you have added your question to an old thread - For future reference you will often get a quicker response if you start a new one.Mon, 04 Feb 2013 06:14:05 GMTRichard Fryarhttp://www.sqlservercentral.com/Forums/Topic1381875-1292-1.aspxI am having the same problem. I've installed SQL Server 2012 on a Windows 8 machine. SQL Browser is enabled. Remote connections are enabled. Firewall has rules for SQL Server ports etc.My SQL Server is called DELL-D830\SQLEXPRESSMy Server is on 192.168.200.149.If I do sqlcmd on the machine local to the SQL Server, no problem, everything works fine.If I do sqlcmd from a remote machine using commandsqlcmd -S DELL-D830\SQLEXPRESS -U andy -P andyorsqlcmd -S 192.168.200.149\SQLEXPRESS -U andy -P andyHave also triedsqlcmd -H 192.168.200.149 -S .\SQLEXPRESS -U andy -P andyWith all commands I try I get the same error messages as reported at the start of this thread.Any ideas what I've missed or are there any known problems with MSSS on Windows 8?cheersAndyFri, 01 Feb 2013 09:06:16 GMTandy.gardnerhttp://www.sqlservercentral.com/Forums/Topic1381875-1292-1.aspxWell you are a genius... very simple.. and rather annoying on my part.... thank you! Wed, 07 Nov 2012 03:54:59 GMTn00bDBAhttp://www.sqlservercentral.com/Forums/Topic1381875-1292-1.aspxTry [b]sqlcmd -S .\Offline -U sa -P 123abc456[/b]in windows environment, mostly you use backslash \ not slash /Wed, 07 Nov 2012 03:39:19 GMTe4d4http://www.sqlservercentral.com/Forums/Topic1381875-1292-1.aspxHi all, I cant connect to a sql express instance via sqlcmd and was hoping for some ideas! Command line: [b]sqlcmd -S ./Offline -U sa -P 123abc456[i][/i][/b]So far:SQL Browser is enabledTCP/IP is enabledRemote connections is enabledfirewall is turned off. I can connect from the SQLCMD from the server with SQL Express on to another instance. I can connect from SSMS on a client machine to the SQL Express instanceIm getting the following error: Error: Microsoft SQL Server Native Client 11.0 : Named pipes Provider: Could not open a connection to SQL ServerError: Microsoft SQL Server Native Client 11.0 : Login timeout expired.Error: Microsoft SQL Server Native Client 11.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 BOL.Hope someone can help!Wed, 07 Nov 2012 03:33:15 GMTn00bDBA