Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Sql Inventory Script: Fill method fails Expand / Collapse
Author
Message
Posted Tuesday, March 19, 2013 9:52 AM
Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Saturday, October 18, 2014 8:52 AM
Points: 599, Visits: 1,711
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=http://colleenmorrow.com/2012/05/31/building-a-sql-server-inventory-part-2/]




Post #1432751
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse