POwershell install

This topic contains 5 replies, has 4 voices, and was last updated by Profile photo of adree21 adree21 4 months, 3 weeks ago.

  • Author
    Posts
  • #60787
    Profile photo of adree21
    adree21
    Participant

    Hi i'm new to this but is there a way to install powershell without installing sql management studio and if so can you give me the steps please. Needed Urgently.

  • #60789
    Profile photo of Max Kozlov
    Max Kozlov
    Participant

    search for "Download Windows Management Framework"

  • #60792
    Profile photo of Daniel Krebs
    Daniel Krebs
    Moderator

    I'm assuming you mean the PowerShell module for SQL Server. If yes, you'll need to download and install a few components from the feature pack. Documentation here:

    https://msdn.microsoft.com/en-us/library/hh245198.aspx

    Otherwise the PowerShell engine should already be installed if you're using a somewhat recent Windows client or server operating system.

  • #60820
    Profile photo of Aaron Hardy
    Aaron Hardy
    Participant

    If you are looking to remotely manage a SQL server from a system that does not have the SQL Server modules (or any other kind of module), you can try using Implicit Remoting. Don Jones has a write-up here.

    If you're new to PowerShell, I recommend getting started with these books to increase your skill and get more comfortable with it:

    Learn PowerShell in a Month of Lunches
    Learn PowerShell Toolmaking in a Month of Lunches
    PowerShell In Depth
    The Pester Book (agile publishing)

  • #61002
    Profile photo of adree21
    adree21
    Participant

    ok thanks guys for your prompt response but to no avail. Is there a way i can just get the sqlps.exe file and if so where?

  • #61009
    Profile photo of adree21
    adree21
    Participant

    SO i found a way to install sqlps module...no my problem is its in my program files folder. Now my boss is only said that when i go in cmd and type sqlps /? a bunch of codes should come up and if not then its not installed properly. Can anyone help me make sense and get it working please?

You must be logged in to reply to this topic.