Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Set-DBALogin -whatif inaccurate server information #9580

Open
Sirwill1968 opened this issue Jan 30, 2025 · 0 comments
Open

Set-DBALogin -whatif inaccurate server information #9580

Sirwill1968 opened this issue Jan 30, 2025 · 0 comments
Labels
bugs life triage required New issue that has not been reviewed by maintainers

Comments

@Sirwill1968
Copy link

Sirwill1968 commented Jan 30, 2025

Verified issue does not already exist?

I have searched and found no existing issue

What error did you receive?

No error but the output when for multiple servers, for -whatif shows the last server processed for all servers. I ran with -verbose and saw it did do the check and process for all 3 servers.
Example

Set-DbaLogin -SqlInstance rs-tr-sql-01,rs-tr-sql-02,st-tr-sql-01 -Disable -Login callurl,clientroutercentralhl7 -WhatIf 
What if: Performing the operation "Setting Changes to Login on st-tr-sql-01" on target "[callurl]".
What if: Performing the operation "Setting Changes to Login on st-tr-sql-01" on target "[ClientRouterCentralHL7]".
What if: Performing the operation "Setting Changes to Login on st-tr-sql-01" on target "[callurl]".
What if: Performing the operation "Setting Changes to Login on st-tr-sql-01" on target "[ClientRouterCentralHL7]".
What if: Performing the operation "Setting Changes to Login on st-tr-sql-01" on target "[callurl]".
What if: Performing the operation "Setting Changes to Login on st-tr-sql-01" on target "[ClientRouterCentralHL7]".

Steps to Reproduce

# provide your command(s) executed pertaining to dbatools
# please include variable values (redacted or fake if needed) for reference

Set-DbaLogin -SqlInstance rs-tr-sql-01,rs-tr-sql-02,st-tr-sql-01 -Disable -Login callurl,clientroutercentralhl7 -WhatIf

Please confirm that you are running the most recent version of dbatools

2.1.27

Other details or mentions

No response

What PowerShell host was used when producing this error

Windows PowerShell ISE (powershell_ise.exe)

PowerShell Host Version

Name Value


PSVersion 5.1.14393.7513
PSEdition Desktop
PSCompatibleVersions {1.0, 2.0, 3.0, 4.0...}
BuildVersion 10.0.14393.7513
CLRVersion 4.0.30319.42000
WSManStackVersion 3.0
PSRemotingProtocolVersion 2.3
SerializationVersion 1.1.0.1

SQL Server Edition and Build number

Microsoft SQL Server 2019 (RTM-CU26) (KB5035123) - 15.0.4365.2 (X64) Mar 29 2024 23:02:47 Copyright (C) 2019 Microsoft Corporation Enterprise Edition: Core-based Licensing (64-bit) on Windows Server 2019 Standard 10.0 (Build 17763: ) (Hypervisor)

.NET Framework Version

.NET Framework 4.8.4770.0

@Sirwill1968 Sirwill1968 added bugs life triage required New issue that has not been reviewed by maintainers labels Jan 30, 2025
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
bugs life triage required New issue that has not been reviewed by maintainers
Projects
None yet
Development

No branches or pull requests

1 participant