question

Beb3x avatar image
Beb3x asked

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

sqlserverauthentication
10 |1200

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

1 Answer

·
anthony.green avatar image
anthony.green answered

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 comments
10 |1200

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

Beb3x avatar image Beb3x commented ·

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 Likes 0 ·
Kev Riley avatar image Kev Riley ♦♦ Beb3x commented ·

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 Likes 0 ·
Beb3x avatar image Beb3x Kev Riley ♦♦ commented ·

It works , thank you.

save me months.

0 Likes 0 ·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

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