Restore DB and create a new SQL login

Welcome Forums DSC (Desired State Configuration) Restore DB and create a new SQL login

This topic contains 2 replies, has 3 voices, and was last updated by

 
Participant
2 years, 3 months ago.

  • Author
    Posts
  • #48534
    MK

    Participant
    Points: 1
    Rank: Member

    Hi,

    I used xSqlServerInstall (from model xsqlps) and xSQLServerLogin (from model xSQLServer) resources to install an sql server and to create an new sql login but there is no property for assigning a password. Do I have to build my own resource for that? Also wanted to know which resource to use to restore a database from a .bak file?

    Thanks in advance
    Mindaugas

  • #48544

    Keymaster
    Points: 1,638
    Helping HandTeam Member
    Rank: Community Hero

    You'd need to, use. But, in an ideal world (from Microsoft's perspective), you're using Windows logins, not SQL Server logins, so you don't need to set passwords.

  • #48806

    Participant
    Points: -19
    Rank: Member

    Haven't tried it myself as I lack the environment to (rebuilding my entire home net from scratch), but xSQLServerLogin has a
    parameter $LoginCredential of type System.Management.Automation.PSCredential which means in your configuration command you can
    set a -LoginCredential and supply it with something like this:

    $secpasswd = ConvertTo-SecureString “SQLLoginPassword” -AsPlainText -Force
    $mycreds = New-Object System.Management.Automation.PSCredential (“username”, $secpasswd)

    where username is actually the SQLServerlogin name, thus you use -LoginCredential $mycreds

    do note that the Test section of the DSC resource doesn't implement validation of the password so you cant use the password as
    a point of decision if a configuration change has happened.

The topic ‘Restore DB and create a new SQL login’ is closed to new replies.