SQL Server newbie here - I'm trying to access the localdbMSSQLLocalDB server on my computer through PowerShell with the SQLCMD utility. I'm using PowerShell v5, .NET v5.0, and The server name is (localdb)MSSQLLocalDB
when I connect to it in Microsoft SQL Server Management Studio 2014.
PS C:> sqlcmd -S localdbMSSQLLocalDB
and PS C:> sqlcmd -S .localdbMSSQLLocalDB
result in this error:
Sqlcmd: Error: Microsoft ODBC Driver 11 for SQL Server : SQL Server
Network Interfaces: Error Locating Server/Instance Specified
[xFFFFFFFF].
I queried the server name in Management Studio with SELECT @@ServerName
and used that after the -S
in the above command and got the same error.
PS C:> sqlcmd -S localdb
gives this error:
Sqlcmd: Error: Microsoft ODBC Driver 11 for SQL Server : Named Pipes
Provider: Could not open a connection to SQL Server [53]
Other notes: I'm able to connect to the server and work with a database named testdb01 in a C# console app using System.Data.SqlClient
with this connection string:
"Data Source=(localdb)\mssqllocaldb;Initial Catalog=testdb01;Integrated Security=SSPI;"
Any ideas on where to start or how to approach this?
See Question&Answers more detail:
os 与恶龙缠斗过久,自身亦成为恶龙;凝视深渊过久,深渊将回以凝视…