locked
ReadOnly Intent on SSMS

    Question

  • I have found several example of connection strings for Read-Only connection to availability group for everything but SSMS.  Is there a way in ssms you can specify a read only connection? For sqlcmd I have seen -k Readonly but need a solution for SSMS.  Thanks

    Tuesday, February 28, 2012 2:46 PM

All replies

  • Press the Options button and on the third tab  "Additional Connection Parameters" you can specify additional connection-string properties.


    Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se
    Wednesday, February 29, 2012 6:54 AM
  • I see this option is there however everything I have tried for a read only connection doesnt work.

    Example things tried.  READ_ONLY, Read-intent only, Read-intent

    If this is the correct place to put it can you tell me what should be put here to successfully get a read only connection?

    Wednesday, February 29, 2012 6:16 PM
  • I found the answer to this.  You need to provide ;ApplicationIntent=ReadOnly 

    Thanks

    Thursday, March 01, 2012 12:36 PM