I found a sql server inventory script that seems to be available on several sites. It actually seems to generate all of the reports but fails on the SqlDataAdapter fill method whether named pipes is turned on or not. If I remote desktop to the server and run it I don't get this error.
fill : Exception calling "Fill" with "1" argument(s): "A network-related or instance-spec
ng a connection to SQL Server. The server was not found or was not accessible. Verify tha
hat SQL Server is configured to allow remote connections. (provider: Named Pipes Provider
ction to SQL Server)"
At C:\powershell\GetServerInfo3.ps1:27 char:9
+ $da.fill <<<< ($ds) | Out-Null
+ CategoryInfo : NotSpecified: (:) [], MethodInvocationException
+ FullyQualifiedErrorId : DotNetMethodException
[/url]
[/url]