BUG: SQL Prompt is not properly working in SSMS that runs under different domain account

If you will use SSMS under different account and start SSMS via:

@echo off
runas /user:domainA\user /netonly "c:\Program Files (x86)\Microsoft SQL Server Management Studio 18\Common7\IDE\Ssms.exe"

and you are actually working on your PC in domainB, your SQL Prompt will lag like:

- not properly refreshing meta data of the table, or DB object will not appear at all in suggestions;

- doesn't highlight syntax;

- refresh suggestion doesn't work;

- cross DB queries are not highlighted/suggested;

The are two way to make it working:

1) Execute User [Database]; GO; in each window or each execution block;

2) Then run refresh suggestion.

This bug is valid for all edition during last 3 years. I'm just tired of this.

yevheniy.martynenko April 17, 2020 11:22

4 comments

Agree...would be nice to see this fixed.

meastland75 August 04, 2021 14:37

0
Any fix or should we escalate via sales department, so you start moving?

nenkie76 August 18, 2021 11:47

0
nenkie76 - I was able to get this to work by logging on to the same machine using the account identified in the runas command and configuring the SQL Prompt environment. After that, SQL Prompt worked as expected with ssms via runas.

meastland75 August 18, 2021 14:46

0
Good that you have access to that domain via RDP and extra license, but we don't.

nenkie76 September 03, 2021 06:17

0

Please sign in to leave a comment.

How can we help you today?