SSMS project, how to rename connection names or not persist them (security issue)

Question

We are finding that the connection name in SSMS projects are named with the creator's user name (when using Windows Auth) as part of the name. We would like a way where we can rename the connection name to something else or not have it persist at all.

The part in orange is what we need to be able to be renamed or removed. How do I go about this?

Answer 1

Hi @David Bailey ,

Please check out this doc:
Rename Solutions and Project Items

It mentions that projects and connections cannot be renamed

-------------

If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Answer 2

This is not currently possible and there isn't any documentation as to not persist a connection or have it named something else. The properties window has no name field for items or projects, only the solution.