从SQL表通过PowerShell的查询

我已经在本地机器上创build了一个简单表格的SQL Server数据库。 我尝试从这个表中查询一些信息。 这是我的代码：

$connection= New-Object system.data.sqlclient.sqlconnection $Connection.ConnectionString = ` "server=.;database=sharespace;trusted_connection=True" $connection.open() #########query drop paths########################################## $SqlCmd = New-Object System.Data.SqlClient.SqlCommand $SqlQuery = "select Droppath from sharespace" $SqlCmd.CommandText = $SqlQuery $SqlAdapter = New-Object System.Data.SqlClient.SqlDataAdapter $SqlAdapter.SelectCommand = $SqlCmd $SqlCmd.Connection = $SqlConnection $DataSet = New-Object System.Data.DataSet $SqlAdapter.Fill($DataSet) $SqlConnection.Close() $DataSet.Tables[0] 

这失败了以下错误：

 Exception calling "Fill" with "1" argument(s): "A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: SQL Network Interfaces, error: 25 - Connection string is not valid)" At D:\query.ps1:31 char:17 + $SqlAdapter.Fill <<<< ($DataSet) + CategoryInfo : NotSpecified: (:) [], MethodInvocationException + FullyQualifiedErrorId : DotNetMethodException 

我得到了“######## query drop paths #########”上面的成功，我想我已经连接到本地数据库，但为什么其余部分失败？

任何人都可以帮我吗？ 请…

• 奇怪的LDAPsearch结果行为
• MS SQL Server查询超时
• 我对权威DNS服务器的实际定义感到困惑
• ldap查询活动目录：所有用户分配了其组或成员的用户
• AD查询来查看用户最近login了哪些PC

 ######connect to windows authentication local database################################ $connection= new-object system.data.sqlclient.sqlconnection #Set new object to connect to sql database $Connection.ConnectionString ="server=.;database=sharespace;trusted_connection=True" # Connectiongstring setting for local machine database with window authentication Write-host "connection information:" $connection #List connection information Write-host "connect to database successful." $connection.open() #Connecting successful #########query drop paths############################################################ $SqlCmd = New-Object System.Data.SqlClient.SqlCommand #setting object to use sql commands $SqlQuery = "select Droppath from sharespace" #setting query "get drop paths" $SqlCmd.CommandText = $SqlQuery # get query $SqlAdapter = New-Object System.Data.SqlClient.SqlDataAdapter # $SqlAdapter.SelectCommand = $SqlCmd # $SqlCmd.Connection = $connection $DataSet = New-Object System.Data.DataSet $SqlAdapter.Fill($DataSet) $connection.Close() $DataSet.Tables[0]