PowerShell / SQL Server / Cannot find type Microsoft.SqlServer.Management.Smo.Server

Get-Module -ListAvailable -Name SQLPS

7 Responses to “ “PowerShell / SQL Server / Cannot find type Microsoft.SqlServer.Management.Smo.Server”

1. Samuel says:

   January 14, 2020 at 5:42 am

   Hi,

   I need to deploy a similar script along with the rest of the stuff on client machines. And I can’t request them to install the components on all machines. Can you possibly modify it to use SQLServer module instead of SQLPS so that one may see how this is implemented. Thanks

   Reply
2. Ken Sturgeon says:

   February 6, 2020 at 1:59 pm

   Are reboots required when installing the above mentioned components (SQLSysClrTypes, SharedManagementObjects, and PowerShellTools)?

   I tried to install SharedManagementObjects and it indicated that I first needed to install SQLSysClrTypes. I have done so but I still get the same message (missing SQLSysClrTypes) when I try to install SharedManagementObjects. I fear I may have to restart the server before it will recognize that the SQLSysClrTypes are already installed.

   Reply
   • Barac says:

     February 6, 2020 at 2:42 pm

     Hi Ken,
     I am not sure where do you trying to install the SQLPS module. The SQLPS module is already included with the SQL Server installation but is no longer being updated. The most up-to-date PowerShell module is the SqlServer module.
     In case if you want to run PS script from a computer that does not have an installation of SQL, you need to install these packages manually. No reboot needed.
     More info about SQLPS and SqlServer module you can find on the following link
     https://docs.microsoft.com/en-us/sql/powershell/download-sql-server-ps-module?view=sql-server-ver15

     Reply
3. DjE says:

   February 6, 2020 at 3:43 pm

   Hi Barac,

   It looks like my SQL modules were loaded to a different directory, C:\Program Files\WindowsPowerShell\Modules. PowerShell does not seem to look in this direction. What seems to be the default directory is C:\windows\system32\WindowsPowerShell\v1.0\modules. Is there a way to update the search paths for PowerShell? I am running Version 5.1.14393.3383 Thank you for any help you may provide.

   Reply
   • Barac says:

     February 6, 2020 at 7:48 pm

     Hi DjE,
     Starting in PowerShell 5.0, with the addition of the PowerShellGet module, and the PowerShell Gallery of community and Microsoft-created resources, the Install-Module command installs modules and DSC resources to C:\Program Files\WindowsPowerShell\Modules by default
     Source:
     https://docs.microsoft.com/en-us/powershell/module/microsoft.powershell.core/about/about_modules?view=powershell-7
     There you can find more information about PS modules and how to change default module locations as well …
     Cheers,

     Reply
4. Ken Sturgeon says:

   February 6, 2020 at 3:59 pm

   Barac, thank you for your response. I failed to mention that I’m trying to copy a database from one SQL Server instance to a second SQL Server instance on a different physical machine. I’m performing the task from a server that does not have SQL Server installed.

   I discovered that my problem was that I had inadvertently downloaded the x86 versions of the msi’s rather than the x64 versions. I’ve since successfully installed them and executed my scripts without rebooting the server.

   Thanks again for taking the time to respond.

   Reply
   • Barac says:

     February 6, 2020 at 7:49 pm

     No worries Ken,
     I am glad you solved the problem.
     Cheers,

     Reply

About Me

My name is Zoran, currently living in Auckland, New Zealand. I am a data specialist with more than 15 years of hands-on experience in database administration and optimisation. I am also, Certified Microsoft Trainer (MCT) and Microsoft Certified Solutions Expert (MCSE) with a Master‘s degree in Information Technology. Sharing knowledge and contributing to the SQL Server community is my passion. I am also an organiser of the Auckland SQL User Meetup Group. As well I am active blogger and speaker at different SQL events such as SQL Saturdays, Meetups etc.

read more