May 14, 2012 at 1:26 pm
Basic issue: after loading sqlps module network share is not accessible...
Bug is already logged but not yet acknowledged by MS...
http://connect.microsoft.com/SQLServer/feedback/details/737324/sqlps-unc-path-issue#tabs
can someone run below 3 command and confirm if they see the same in their env, third command should fail...
Get-ChildItem "\\servername\c$\" | Select-Object -first 1
Import-Module 'sqlps' -DisableNameChecking
Get-ChildItem "\\servername\c$" | Select-Object -first 1
Prakash Heda
Lead DBA Team - www.sqlfeatures.com
Video sessions on Performance Tuning and SQL 2012 HA
May 14, 2012 at 5:38 pm
found fix if location is set to PS SQLSERVER:\> UC is not accesible thus changed it to c:\:
Get-ChildItem "\\server1\c$\" | Select-Object -first 1
Import-Module 'sqlps' -DisableNameChecking
set-location "c:\" -PassThru
Get-ChildItem "\\server1\c$" | Select-Object -first 1
Prakash Heda
Lead DBA Team - www.sqlfeatures.com
Video sessions on Performance Tuning and SQL 2012 HA
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply