Comments (5)
@nebffa If you have the same login name to the same instance that will not work. Is your scenario that you want to use the same login name to different instances?
I have two of them in a row, but with different login names, and that works.
xSQLServerLogin SQLConfigureLoginPrimary
{
Name = $SqlServiceCredentialNode1.UserName
LoginType = 'WindowsUser'
SQLServer = $Node.NodeName
SQLInstanceName = $Node.SqlInstanceName
PsDscRunAsCredential = $SqlAdministratorCredential
DependsOn = '[Service]SQLServerServiceStarted'
}
xSQLServerLogin SQLConfigureLoginSecondary
{
Name = $SqlServiceCredentialNode2.UserName
LoginType = 'WindowsUser'
SQLServer = $Node.NodeName
SQLInstanceName = $Node.SqlInstanceName
PsDscRunAsCredential = $SqlAdministratorCredential
DependsOn = '[Service]SQLServerServiceStarted'
}
from sqlserverdsc.
@nebffa Ah, my bad... It was clear stated in the subject that it was to different instances.
from sqlserverdsc.
This will be fixed when PR #106 is merged
from sqlserverdsc.
This was resolved in PR #106
from sqlserverdsc.
@mbreakey3 Can you close this issue? It wasn't auto-closed with the PR apparently.
from sqlserverdsc.
Related Issues (20)
- SqlServerDsc: Use dbatools as a preferred module
- SqlRs: Replace `Invoke-SqlCmd` with `Invoke-SqlDscQuery`
- `Invoke-SqlDscQuery`: `InstanceName` always set to default value in should process messages
- SqlQuery: New resource proposal HOT 5
- SqlServerDsc: Release assets on a GitHub release HOT 2
- SqlScriptQuery: Get-Module for SQLPS throws error HOT 6
- SqlConfiguration - 'blocked process threshold' option support HOT 3
- SqlServerDsc: Using AMO client library for `Microsoft.AnalysisServices.Server` HOT 1
- Error while running the DSC_SqlSetup Module HOT 1
- SqlProtocolTcpIp: Auto-detect the TCP/IP address group name by IP address HOT 6
- SqlSecureConnection: Unable to specify certificate by using friendly name HOT 5
- SqlWindowsFirewall: Duplicate Browser Firewall Rule for AS feature creates Error in subsequent Test-TargetResource runs HOT 3
- SqlServerDsc: GitHub Action Code Analysis should run on built module HOT 1
- SqlSetup: Seems to evaluate the `SourcePath` too early for Puppet HOT 6
- Problem using dsc_sqlscript as a resource in puppet HOT 3
- SqlDatabasePermission: Problem using dsc_sqldatabasepermission in Puppet HOT 4
- SqlLogin: Attempting to disable and already disabled login throws an error
- SqlPermission: Undefined DSC resource 'SqlPermission' HOT 8
- Table of Contents broken HOT 3
- Install-SqlDscServer with -PrepareImage errors when InstanceName is specified HOT 1
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from sqlserverdsc.