Post reply

Opening .sql files result in connect to database engine prompt

  • February 24, 2014 at 9:19 am

    #304515

    Hey all,

    When opening .sql files, I get a connect to database engine prompt every single time. Never had this problem before and not sure when it started or what I did to make it happen; however anyone know how to stop this from prompting vs. just using my current active connection?

    Thanks

  • February 24, 2014 at 11:19 am

    #1691672

    Does it happen even after connecting to the SQL Server in the object explorer ?

    --

    SQL Buddy

  • February 24, 2014 at 11:26 am

    #1691673

    It sure does.

  • February 25, 2014 at 2:27 am

    #1691789

    Adam Bean (2/24/2014)

    Hey all,

    When opening .sql files, I get a connect to database engine prompt every single time. Never had this problem before and not sure when it started or what I did to make it happen; however anyone know how to stop this from prompting vs. just using my current active connection?

    Thanks

    A file type association has been created to open SSMS when opening a .sql file

    If you want to stop this do one of the following

    • right click the .sql file and select "Open with". Select "Choose default program" and select a program other than SSMS (e.g. Wordpad). Ensure the checkbox "Always use the selected program to open this kind of file" is selected and click "OK"
    • go into Control panel > Programs > Default programs > Set associations. Select .sql filetype and change the default program used to open the file

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

  • February 25, 2014 at 5:53 am

    #1691830

    Perry Whittle (2/25/2014)

    Adam Bean (2/24/2014)

    Hey all,

    When opening .sql files, I get a connect to database engine prompt every single time. Never had this problem before and not sure when it started or what I did to make it happen; however anyone know how to stop this from prompting vs. just using my current active connection?

    Thanks

    A file type association has been created to open SSMS when opening a .sql file

    If you want to stop this do one of the following

    • right click the .sql file and select "Open with". Select "Choose default program" and select a program other than SSMS (e.g. Wordpad). Ensure the checkbox "Always use the selected program to open this kind of file" is selected and click "OK"
    • go into Control panel > Programs > Default programs > Set associations. Select .sql filetype and change the default program used to open the file

    Hi Perry,

    The association is already there, as the files to open within SSMS; however it's that it's asking for a login yet again, even though I have an active connection. I tried this anyway; however no change.

    Thanks

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply