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

nenkie76

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.

meastland75

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

nenkie76

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

meastland75

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.

nenkie76

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