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

David Bailey 1 Reputation point
2022-09-30T21:12:17.647+00:00

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?

246567-image.png

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,887 questions
0 comments No comments
{count} votes

2 answers

Sort by: Most helpful
  1. YufeiShao-msft 7,061 Reputation points
    2022-10-03T06:58:12.083+00:00

    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.


  2. David Bailey 1 Reputation point
    2022-10-07T16:07:22.337+00:00

    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.

    248498-image.png

    0 comments No comments