Need to create a new instance of a SQL db with a unique port

This topic contains 0 replies, has 1 voice, and was last updated by  Forums Archives 5 years, 10 months ago.

  • Author
    Posts
  • #6364

    by jgavin65 at 2012-10-11 06:47:47

    I need to create a new instance of a SQL db with a unique port and service account specific permissions. I suspect this has already been done before but having a time finding one.

    I'm relatively new to PS and it's a great tool to have in my toolbox!

    Many thanks in advance!

    JoeG
    MCITP, MCTS

    by Klaas at 2012-10-11 09:10:30

    a command line install works in Powershell as in cmd.exe:
    http://msdn.microsoft.com/en-us/library/ms144259.aspx

    I use a .ps1 script file where the command is constructed by concatenating all parts and a .txt config file with the needed parameters, from MAK & Yan Pan's book 'Administering SQl Server 2008 with Windows Powershell"(Wrox 2009). It's a Powershell V 1 script with SQl 2008, though.

You must be logged in to reply to this topic.