Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in
Home       Members    Calendar    Who's On

Add to briefcase

Sql Inventory Script: Fill method fails Expand / Collapse
Posted Tuesday, March 19, 2013 9:52 AM
Say Hey Kid

Say Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey Kid

Group: General Forum Members
Last Login: Thursday, August 18, 2016 9:39 AM
Points: 702, Visits: 2,068
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



Post #1432751
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse