Analyze SQL Erroring Out

peet
peet
in General

I get this error when I try to analyze SQL:

I have ssms installed. How can I fix this?

· Share on FacebookShare on Twitter

Comments

  • JoeAlbahari
    JoeAlbahari

    Which version of LINQPad are you running, and which version of SSMS is installed?

    Is it a trusted connection or username/password combination? Can you provide a screenshot of your connection dialog?

    · Share on FacebookShare on Twitter
  • peet
    peet
    edited February 2020

    Linquad 5.4, ssms 18

    It's one of the connections from my saved connections in the left menu. Uses a username & pw.

    · Share on FacebookShare on Twitter
  • JoeAlbahari
    JoeAlbahari

    I've identified the problem: it's described here.

    "Command line option -P removed – Due to security concerns, the option to specify clear-text passwords on the command line was removed."

    I'll add a fix into the next LINQPad build such that it doesn't send the password.

    · Share on FacebookShare on Twitter
  • Zulaxia
    Zulaxia
    edited August 17

    Apologies for the five year necro, but I'm getting similar in LP9 beta. I'm assuming it's because I'm using a DBContext from a dll but it would still be really helpful to at least launch ssms with the script copied as a bare minimum if possible. Or perhaps pull .Database.GetDbConnection().DataSource from the context of the connection?

    Also SSMS21 isn't even found. I had to reinstall SSMS20 just to get the error OP reported.

    · Share on FacebookShare on Twitter

Categories