SQLCMD failure

I am trying to attach an ms sql database. And I am trying to use sqlcmd utillity. But anytime I try this, I got:

Code:

---

SQLCMD

Sqlcmd: Error: Microsoft SQL Server Native Client 11.0 : Named Pipes Provider: Could not open a connection to SQL Server [2]. .
Sqlcmd: Error: Microsoft SQL Server Native Client 11.0 : Login timeout expired.
Sqlcmd: 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 SQL Server Books Online..

---

of course, I have tried to find the server name and instance, with:

Code:

---

SQLCMD.EXE -L

---

and the answer was:

Code:

---

Servers:
    ;UID:Login ID=?;PWD:Password=?;Trusted_Connection:Use Integrated Security=?;*APP:AppName=?;*WSID:WorkStation ID=?;

---

How can I find the server name and the instance name then ?

Could something from
https://stackoverflow.com/questions/...-to-the-server
https://social.msdn.microsoft.com/Fo...=sqlgetstarted
help you?

Are the named pipes protocol enabled on sql server? They aren't by default. Search google for "sql configuration manager"

Quote:

---

Originally Posted by Arjay

Are the named pipes protocol enabled on sql server? They aren't by default. Search google for "sql configuration manager"

---

Yes, they are enabled.

Quote:

---

Originally Posted by mesajflaviu

Yes, they are enabled.

---

Are you able to connect with SSMS?

Btw, I've used SQLCMD within PowerShell for years, but recently ran into a issue where it just would not connect to a specific server. Never could figure out the issue.

Rather than calling SQLCMD with PowerShell, I changed the code to use the SqlServer PowerShell module.

In the ending is solved. Thank you all of you !

Quote:

---

Originally Posted by mesajflaviu

In the ending is solved. Thank you all of you !

---

Could you share your solution?

I succeeded with following commands:

Code:

---

SQLCMD.EXE -S DESKTOP-YYYYYY\SQLEXPRESS

CREATE DATABASE mydataabse  ON (FILENAME = 'C:\Program Files (x86)\Microsoft SQL Server\MSSQL11.SQLEXPRESS\MSSQL\DATA\mydatabase.mdf'),  (FILENAME = 'C:\Program Files (x86)\Microsoft SQL Server\MSSQL11.SQLEXPRESS\MSSQL\DATA\mydatabase_Log.ldf')    FOR ATTACH;

GO

---

after I enabled Name Pipes from Sql Server Configuration Manager.

Thank you for your support.