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 · 1 comment · May be fixed by #9582
Open

Set-DBALogin -whatif inaccurate server information #9580

Sirwill1968 opened this issue Jan 30, 2025 · 1 comment · May be fixed by #9582

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
@niphlod niphlod linked a pull request Feb 10, 2025 that will close this issue
10 tasks
@niphlod niphlod removed the triage required New issue that has not been reviewed by maintainers label Feb 10, 2025
@niphlod
Copy link
Contributor

niphlod commented Feb 17, 2025

hopefully, a fix is available at #9582

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Development

Successfully merging a pull request may close this issue.

2 participants