Home Dashboard Directory Help
Search

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


Status: 

Closed
 as Fixed Help for as Fixed


2
0
Sign in
to vote
Type: Bug
ID: 411125
Opened: 2/4/2009 9:30:50 AM
Access Restriction: Public
Primary Feedback Item: 390966
0
Workaround(s)
view
1
User(s) can reproduce this bug

Description

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.
Details
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.

Thanks,
- 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:

http://support.microsoft.com/kb/961638
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.

Thanks,
-Karthik
Sign in to post a workaround.