is there a code to get connection string in SSMS

Ken Lok Chan answered on January 10, 2023 Popularity 8/10 Helpfulness 5/10

answer is there a code to get connection string in SSMS

is there a code to get connection string in SSMS

Comment

select
    'data source=' + @@servername +
    ';initial catalog=' + db_name() +
    case type_desc
        when 'WINDOWS_LOGIN' 
            then ';trusted_connection=true'
        else
            ';user id=' + suser_name() + ';password=<<YourPassword>>'
    end
    as ConnectionString
from sys.server_principals
where name = suser_name()

Popularity 8/10 Helpfulness 5/10 Language sql

Source: stackoverflow.com

Tags: connection-string get sql ssms

Link to this answer
Share Copy Link

Contributed on Jan 10 2023

Ken Lok Chan

0 Answers Avg Quality 2/10

is there a code to get connection string in SSMS

Contents

More Related Answers

is there a code to get connection string in SSMS

Grepper

Documentation

Social

Legal

Contact

Oops, You will need to install Grepper and log-in to perform this action.