October 23, 2017 at 6:58 am
Using V17.3 and 2008R2
When I double-click on an .sql file, SSMS v17 launches with a new connection window.
When I double-click on a .prc, the file is opened disconnected, and I can't even see a way to connect to a SQL Server.
How can I a) connect to a server, and or b) always get the connection window?
TIA
October 23, 2017 at 8:08 am
schleep - Monday, October 23, 2017 6:58 AMUsing V17.3 and 2008R2When I double-click on an .sql file, SSMS v17 launches with a new connection window.
When I double-click on a .prc, the file is opened disconnected, and I can't even see a way to connect to a SQL Server.
How can I a) connect to a server, and or b) always get the connection window?TIA
Did you set or check prc files to have the same association as sql files?
Control panel, Default Programs, Set Default programs. It could be they are set to different versions of SSMS.
Sue
October 23, 2017 at 8:17 am
Sue_H - Monday, October 23, 2017 8:08 AMschleep - Monday, October 23, 2017 6:58 AMUsing V17.3 and 2008R2When I double-click on an .sql file, SSMS v17 launches with a new connection window.
When I double-click on a .prc, the file is opened disconnected, and I can't even see a way to connect to a SQL Server.
How can I a) connect to a server, and or b) always get the connection window?TIA
Did you set or check prc files to have the same association as sql files?
Control panel, Default Programs, Set Default programs. It could be they are set to different versions of SSMS.Sue
Should be associate file types instead of set defaults
Keep getting errors whenever I answer a post. Can sometimes preview posts but usually not.
Sue
October 23, 2017 at 8:19 am
So I go into Control Panel, Default Programs, Set Associations, navigate to .prc. It's currently set to 2008.
I get the choice of V17 and 2008 versions of SSMS under Recommended Programs. I click on the V17 icon... and the list re-loads and it's still pointing to 2008.
October 23, 2017 at 12:08 pm
schleep - Monday, October 23, 2017 8:19 AMSo I go into Control Panel, Default Programs, Set Associations, navigate to .prc. It's currently set to 2008.I get the choice of V17 and 2008 versions of SSMS under Recommended Programs. I click on the V17 icon... and the list re-loads and it's still pointing to 2008.
It sounds like it's just pointing to the 2008 version. Check this link and see if it helps - has some solutions for the same issue:
Opening .sql files in SSMS 2012 as default program and with existing instance
I use FileTypesMan from NirSoft as I can view a lot more of where things are pointing - especially for multiple apps like SSMS:
FileTypesMan
Sue
October 24, 2017 at 5:48 am
Still opens in SQL 17 disconnected. Which would be fine if there was some way to connect to something.
Thanks Sue.
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply