registered server Multiple - authentification

Question

question

Beb3x asked May 9, '23

registered server Multiple - authentification

I really find a hard time explaining this and i've search everywhere for an answer,

im working with SQL Server Management Studio with multiple registered server (over 150+)

and i have to register every time with a specific user and password ,

and i've find a way to set i as default:
Go to properties of desired registered server and then
SQL SERVER AUTHENTIFICATION :

LOGIN : ETC 12345

PASSWORD : ETC 12345

but i've not found anything for industrial scale , like to set this for many registered server at a time, does it exist? how can i do it.

Sorry for any inconvenience in my writing as english is not my primary language and i've not spoken / written in it for some time

sqlserver authentication

10 |1200

Attachments: Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Answer 1 · 2023-05-09T08:15:33Z

anthony.green answered May 9, '23

You could attempt to hack the RegSrvr XML file if you're confident enough, you would want to replace the "RegisteredServers:ConnectionStringWithEncryptedPassword" value with that of what the new values should be, but that is the only way by directly editing the XML file en-mass

3

10 |1200

Attachments: Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Beb3x commented · May 09 at 09:37 AM

indeed, good idea , but it seems that the password is encrypted , and is kinda hard to simulate the unique encryption from sql server ,

in the long run i will try to reverse engineer it in the meanwhile,

but will take sometime ,

thank you,

0 ·

Kev Riley ♦♦ Beb3x commented · May 09 at 09:45 AM

If you reuse a password across servers, then you can save one config via the UI and then copy that encrypted value in the XML file.

0 ·

Beb3x Kev Riley ♦♦ commented · May 09 at 11:36 AM

It works , thank you.

save me months.

0 ·

question