SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Open .PRC with connection


Open .PRC with connection

Author
Message
schleep
schleep
SSCertifiable
SSCertifiable (6.7K reputation)SSCertifiable (6.7K reputation)SSCertifiable (6.7K reputation)SSCertifiable (6.7K reputation)SSCertifiable (6.7K reputation)SSCertifiable (6.7K reputation)SSCertifiable (6.7K reputation)SSCertifiable (6.7K reputation)

Group: General Forum Members
Points: 6697 Visits: 1490
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



Sue_H
Sue_H
SSC-Dedicated
SSC-Dedicated (33K reputation)SSC-Dedicated (33K reputation)SSC-Dedicated (33K reputation)SSC-Dedicated (33K reputation)SSC-Dedicated (33K reputation)SSC-Dedicated (33K reputation)SSC-Dedicated (33K reputation)SSC-Dedicated (33K reputation)

Group: General Forum Members
Points: 33572 Visits: 9558
schleep - Monday, October 23, 2017 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


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



Sue_H
Sue_H
SSC-Dedicated
SSC-Dedicated (33K reputation)SSC-Dedicated (33K reputation)SSC-Dedicated (33K reputation)SSC-Dedicated (33K reputation)SSC-Dedicated (33K reputation)SSC-Dedicated (33K reputation)SSC-Dedicated (33K reputation)SSC-Dedicated (33K reputation)

Group: General Forum Members
Points: 33572 Visits: 9558
Sue_H - Monday, October 23, 2017 8:08 AM
schleep - Monday, October 23, 2017 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


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



schleep
schleep
SSCertifiable
SSCertifiable (6.7K reputation)SSCertifiable (6.7K reputation)SSCertifiable (6.7K reputation)SSCertifiable (6.7K reputation)SSCertifiable (6.7K reputation)SSCertifiable (6.7K reputation)SSCertifiable (6.7K reputation)SSCertifiable (6.7K reputation)

Group: General Forum Members
Points: 6697 Visits: 1490
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.



Sue_H
Sue_H
SSC-Dedicated
SSC-Dedicated (33K reputation)SSC-Dedicated (33K reputation)SSC-Dedicated (33K reputation)SSC-Dedicated (33K reputation)SSC-Dedicated (33K reputation)SSC-Dedicated (33K reputation)SSC-Dedicated (33K reputation)SSC-Dedicated (33K reputation)

Group: General Forum Members
Points: 33572 Visits: 9558
schleep - Monday, October 23, 2017 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.


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



schleep
schleep
SSCertifiable
SSCertifiable (6.7K reputation)SSCertifiable (6.7K reputation)SSCertifiable (6.7K reputation)SSCertifiable (6.7K reputation)SSCertifiable (6.7K reputation)SSCertifiable (6.7K reputation)SSCertifiable (6.7K reputation)SSCertifiable (6.7K reputation)

Group: General Forum Members
Points: 6697 Visits: 1490
Still opens in SQL 17 disconnected. Which would be fine if there was some way to connect to something.

Thanks Sue.



Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum








































































































































































SQLServerCentral


Search