SQL Server Management Studio (SSMS) 2008 and 2005 Compatibility Issue - by .NETPhreak

Status : 

  Fixed<br /><br />
		This item has been fixed in the current or upcoming version of this product.<br /><br />
		A more detailed explanation for the resolution of this particular item may have been provided in the comments section.

Sign in
to vote
ID 411125 Comments
Status Closed Workarounds
Type Bug Repros 1
Opened 2/4/2009 9:30:50 AM
Access Restriction Public
Primary Feedback Item 390966


Here is the configuration of my machine:

Windows XP SP2
SQL Server 2005 Developer SP3
SQL Server 2008 Developer
Visual Studio 2005 SP1
Visual Studio 2008 SP1

I have already looked at this: https://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx?FeedbackID=298975
and this: https://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx?FeedbackID=361706

I also discuss the issue here: http://social.msdn.microsoft.com/Forums/en-US/sqltools/thread/01bc4e07-0de5-466e-9a29-8d3d4bc0de8f

Here is a breakdown of the issue:
When creating a new solution from within SSMS 2008, the project gets created (I specify a new solution name in order to create a "parent" solution node which will contain multiple children project nodes), but nothing shows up in the Solution Explorer. The Solution Explorer stays blank once I click "OK" on the "Create New Project" dialog box. When I browse to the directory where the solution and the project is to be created, there is no solution file, but the project file exists. It seems SSMS 2008 loses track of what's going on.

Then, when I double click the project file, it opens up in SSMS 2005!? I guess I was expecting it to open in SSMS 2008.

In any case, I have tried repairing the tools as suggested here, even though I do not receive the error messages discussed on the same Webpage: http://www.sqlcoffee.com/Troubleshooting010.htm

Hopefully, this will get addressed - it's a big issue for creating new solutions that are supposed to be deployed in SQL Server 2008 and that need to be synchronized in Source Safe.
Sign in to post a comment.
Posted by Microsoft on 3/24/2010 at 5:24 AM
Hi Dhaval Patel,

We are considering this issue in our next release. We have multiple issues reported to us for this problem. I reproduced this issue by installing SQL Server 2005 and SQL Server 2008 in the install order that you have mentioned. After uninstalling and installing SQL Server 2008, the issue is resolved. However the projects of SQL Server 2005 stop working after reinstallation.

After more investigation, I am marking this issue as duplicate of http://connect.microsoft.com/SQLServer/feedback/details/390966/class-not-registered-error-when-opening-project-in-ssms . Fixing the issue that we are tracking will fix your issue as well.

Thanks for reporting the issue to us and letting us know the detailed steps to reproduce the issue.

- Vikrant Arora
Posted by .NETPhreak on 2/13/2009 at 3:00 PM
I had installed SP3 following my installation of SQL Server 2008. I wonder if that screwed things up. Here is my initial installation order:
1) SQL Server 2005 Developer
2) SS 2005 SP1
3) SS 2005 SP2
4) SS 2008
5) SS 2005 SP3

I uninstalled SS 2008 and reinstalled it. It works! I can see the solution as well as the children nodes of the solution. I am not going to try and reproduce the issue because it takes a long time to install on XP.
Posted by Microsoft on 2/13/2009 at 8:07 AM
If you have both SSMS 2005 and SSMS 2008 installed on the same system, please refer to the KB Article:

Posted by Microsoft on 2/13/2009 at 8:05 AM
Dear Dhaval Patel,

Thank you for reporting this issue via connect. Can you check if after creating the project, you get a Project menu and a Close Solution menu item under File menu. Please note that you can open the Solution Explorer by pressing Ctrl+Alt+L at any time.

We suspect your SSMS installation might be corrupt as this problem is not reproducible with SSMS 2008.