Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I'm connected to database. I use db by Management Studio 2012 Express. Can I check connection string by click something in Management Studio?

share|improve this question

migrated from Jul 8 '12 at 1:09

This question came from our site for professional and enthusiast programmers.

up vote 7 down vote accepted

Within SSMS, I'm not sure there's an easy way to do that. But a simple query will return you the information (without the password of a connection string, obviously):

    'data source=' + @@servername +
    ';initial catalog=' + db_name() +
    case type_desc
        when 'WINDOWS_LOGIN' 
            then ';trusted_connection=true'
            ';user id=' + suser_name()
from sys.server_principals
where name = suser_name()

Note, db_name() will return the current database name if there is no parameter specified, so that is dependent on your current scope.

share|improve this answer
just for info: in SSMS 2010, the view sys.server_principals doesn't exist yet. But we can use the table syslogin (if I recall correctly) – Hoàng Long Oct 1 '15 at 5:54

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.