Working with differenc Windows accounts

dmuelhaupt

When I'm working with my normal user account SQL Prompt is availabe in Query Analyzer and SQL Server Management Studio.

On the other hand, when I login with my developer accout it's available in SQL Server Management Studio but not in the Query Analyzer.

How can this be solved?

Brian Donahue

Thanks for your question.

If you have a SQL Prompt icon in your system tray, you can right-click that and select Start SQL Prompt when you start Query Analyzer.

If SQL Prompt is not present in your system tray, go to %programfiles%\red gate\sql prompt 3 and double-click Redgate.SQLPrompt.TrayApp.exe and perform the step above.

dmuelhaupt

Thanks for your reply.

That's not the problem, the icon is available. It works, when I start the QA in the normal way but it doesn't when I call QA with another user account using "run as...".

Brian Donahue

I think this may be a known issue... originally it was identified with Management Studio. Prompt just doesn't seem to work with RunAs.

dmuelhaupt

FYI: Managament Studio works with RunAs