Universal user settings ("run as different user" scenario)
I use two AD user accounts on a daily basis - a normal account and a "server admin" account (for server OS local admin and SQL instance sysadmin permissions). Hence, I run SSMS as either one or the other user. SQL Prompt settings (same goes for other Redgate tools) are saved per user, which makes it quite tedious, since after every setting change I have to export from that user and import to the other user.
Can you it an option for settings to be user independant (universal)?
Blaž Dakskobler
shared this idea
-
Eric Isaacs commented
I can attest to the fact that the above scenario is a problem with the latest version of SQL Prompt. Open in Excel still opens in Excel, but the user it's opened as doesn't have the license to Excel so the file cannot be saved. It effectively blocks the feature if you're not running SSMS (and SQL Prompt) as your Microsoft Office licensed user. If you attempt to login as your office licensed user, Excel fails to login. The feature effectively does not work if you're logged into Excel as another user. I have another licenses for Red-Gate SQL Prompt at another different employer and I know this feature is an awesome feature but if you're a user with a different login to SSMS than Office, the feature doesn't work. Allowing that office user to be configured once would be ideal over having to login each time the feature is used. Thanks.