-1

I am trying to download the 'SqlServer' module, I recently upgraded Powershell from 4.0 to 5.0. I have set the execution policy to RemoteSigned. This is on a Windows 2012 R2 Server. I am getting this error.

Import-Module : The specified module 'SqlServer' was not loaded because no valid module file was found in any module directory.

I want to download the SqlServer module.

marc_s
  • 732,580
  • 175
  • 1,330
  • 1,459
vfrank66
  • 1,318
  • 19
  • 28
  • Hi, have you tried this ? http://guidestomicrosoft.com/2015/01/13/install-sql-server-powershell-module-sqlps/ – sodawillow Oct 30 '16 at 22:28

1 Answers1

0

I cannot use comment right now so I'll just write it down here. Nowadays SQLServer module is shipped with SSMS releases and SQLPS module is shipped with SQL Server itself. I would suggest you download latest SSMS and it should work fine. Note that there's an earlier version of SQLServer module available in SQL Server 2016 Feature Pack.

Hello
  • 632
  • 7
  • 14
  • That would make sense. I have SSMS 2016 downloaded my personal Win10 laptop and Import-Module SqlServer succeeded fine. But on the servers we do not have SSMS 2016. – vfrank66 Oct 31 '16 at 15:13
  • Then download it via the feature pack, it's not the latest one but it'll work. – Hello Oct 31 '16 at 16:00