There is a new Management Studio Express CTP download available at http://www.microsoft.com/downloads/details.aspx?FamilyId=82AFBD59-57A4-455E-A2D6-1D4C98D40F6E&displaylang=en.
This update fixes the defect where installing the full Books Online documentation prevented Management Studio Express from starting. With the update, Management Studio Express and Books Online no longer interfere with each other.
To update Management Studio Express CTP:
1) Uninstall Management Studio Express CTP from your machine.
2) Clear your browser's download cache. If you are using Internet Explorer 6, you can do this by starting Internet Explorer, clicking the Tools | Options menu item, and then clicking the "Delete Files..." button in the "Temporary Internet Files" section.
3) Download and run SQLServer2005_SSMSEE.msi (or SQLServer2005_SSMSEE_x64.msi) from the URL listed above
I installed the Management Studio Express and the SQL Books Online. Once the SQL Books Online was installed the Management Studio Express would not start. When I remove the SQL Books Online, the Management Studio Express works just fine.
Could you please check to ensure that the current build of both the Management Studio Express and the Books Online are both the latest builds and let us know when the correct version(s) is available?
Many thanks,
Flavelle|||
I've verified that after installing Management Studio Express CTP from the download site (dated November 11, 2005) and Books Online on a clean machine, Management Studio Express does start.
Only if some version of SQL Server 2005 Management Studio is installed will Management Studio Express not start, and in that event a message box explaining that Management Studio Express cannot run is displayed.
Make sure sqlwb.exe (the full Management Studio's executable) is not installed in your ...\Microsoft SQL Server\90\Tools\binn\vsshell\common7\ide directory. This is what the side-by-side check is looking for.
It is also possible that your web browser has a cached copy of SQLServer2005_SSMSEE.msi from a previous download which it was using. Clearing the browser's download cache might help. If you are using Internet Explorer 6, you can do this by opening IE, clicking on Tools | Options in the menu bar, then clicking the "Delete Files..." button in the "Temporary Internet Files" section. Please let us know if this fixes (or doesn't fix) the problem.
|||HI,My installation went like this
1) My machine was not a clean install. I have June CTP on it initially. *However*, I used the clean up tool that was provided in the download area to remove any versions of the betas that already existed.
2) installed the sql server express
3) installed the above link for the Management studio
Then I tried a some old sql server script in the management studio to see compatability.
Then I woke up today and said well lets loads books and samples.
Now my Management studio will not load.
What I have done:
1) uninstalled Management Studio
2) installed Management Studio
Did not work
3) did as steven suggested
a)delete files
b)checked the ide directory - NO FILE WAS FOUND
Still did not work
4) Did what the above user stated.
*removed online books
Worked
Any other suggestions? be nice to have books online.
many thanks,
Angela|||Steven:
I verified that sqlwb.exe is not installed - not only in the directory that you suggested, but also anywhere on my machine.
Cleared all temporary files and redownloaded both the Management Studio Express CTP and the SQL Books Online and re-installed both from the new downloads.
With SQL Books Online installed, the Management Studio Express does not work at all. I am not sure what message box you are referring to - I get nothing. Checking Task Manager shows no change in the number of open processes.
The only thing that I can think of is that I did have Visual Studio 2005 Beta 2 installed on my machine, but that was removed long before I started this exercise.
Uninstalled SQL Books online and the Management Studio Express works fine. If I reinstall SQL Books Online, then Management Studio Express does not start - and I do not get any message.
Like Angela said, it would be very nice to be able to run both. Even better would be to have Help integrated with Management Studio Express from SQL Books Online, but at this point, I would happily settle for being able to run both at the same time.
Problem still exists - any more thoughts would be much appreciated.
Thanks,
Flavelle|||I installed
1. Win XP Profi
2. Net Framework 2
3. Net Framework SDK
4. Management Express CTP
(Management Studio Express CTP works ok.)
5. SQL Books Online
(Management Studio Express does not start. No error, no messagebox, no any window.)
I uninstalled SQL Books Online and it works
I have version 2005.90.1399.0 .
Jirka
|||
I uninstalled SQL Books Online and it works too
ssmsee.exe version 9.00.1399.06|||
This is the information from About that is on the SSME that I installed from the link:
Microsoft SQL Server Management Studio Express 9.00.1399.00
Microsoft Data Access Components (MDAC) 2000.085.1117.00 (xpsp_sp2_rtm.040803-2158)
Microsoft MSXML 2.6 3.0 4.0 5.0 6.0
Microsoft Internet Explorer 6.0.2900.2180
Microsoft .NET Framework 2.0.50727.42
Operating System 5.1.2600
The SQL Books online is version 9.00.1399.06
Hope this helps somebody, because this is becoming a Royal Pain. I am coming from an MS Access world and things are sure different in SQL Server.
Regards,
Flavelle|||Well,
I miss spoke. UNinstalling the books did get the Management Studio to come back and run.
*HOwever*, I cna no longer program in the management studio with the query analyzer portion of it. Things that were working before are no longer working...
I ma in the process of using that exe that removes betas to remove the current version of express from my computer.
I will install it yet again *just* the sqlExpress and the management studio. ANd see if that works again. Hopefully, it will..
Is there somewhere online that I can access the books lonline until this problem gets fixed?
I let you know what happened.
Many thanks!
Angela|||Well,
My whole installation is hosed unfortuantely, I am now going to try and REstore to a particular point to get my system back to the way it was.
Otherwise, I will have to spend an entire day rebuilding my system.
Just not good.
The SMSE does not work at all with the query analyzer portion. I can't even create a stored procedure or insert a row into the table.
Hopefully restoring before I put the books on will do the trick.
Let you know :(
Angela|||
When you downloaded the updated Management Studio Express, did you see it take some time to download it again, or did it start immediately? (If it starts immediately, you're running a cached copy of the Windows installer package for SSMSE.)
If you rename the "HKEY_LOCAL_MACHINE\Software\Microsoft\Microsoft SQL Server\90\Tools\Shell" registry key to "HKEY_LOCAL_MACHINE\Software\Microsoft\Microsoft SQL Server\90\Tools\ShellX" using regedit, SSMSE should start. This should not affect the stand-alone Books Online at all.
After you rename the registry key and then start Management Studio Express, does the splash Screen say "SQL Server Management Studio Express Edition" or just "Management Studio Express"? The November 11 download says "Management Studio Express."
|||Flavelle, thanks for the version information. That will help investigate this further.Keep in mind that the Management Studio Express Community Technology Preview is a pre-release product and it isn't "fully baked" - basically it's a daily build from early November. It hasn't had the full stabilization and defect fixing treatment that the full version of SQL Server has gone through. It will be fully stabilized and defects will be fixed before it is released in the first half of 2006.
We made MSE available early to gather feedback from our Express users. Aside from just helping us find defects, we're hoping to gather feedback on how people feel about our MSE design decisions. I'm particularly interested to know how much our decision not to allow MSE to run on the same machine on which people have installed the full Management Studio impacts Express users and whether our decision not to have integrated help in MSE is a big deal to people. (We have user feedback that seems to say people who would use Express tools won't have the full tools on the same machine and that keeping the download size under 30 MB is was really important and people would be willing to give up integrated help if it reduced the download size from 120 MB to 30, which it does.)
I realize this has been pretty frustrating for early adopters, and I apologize for that. I hope there is some consolation in knowing that your feedback now is helping to improve the product when it finally ships in 2006.|||Steven:
Thanks for the information. I would like to remind you of something you said when the thread started:
This update fixes the defect where installing the full Books Online documentation prevented Management Studio Express from starting. With the update, Management Studio Express and Books Online no longer interfere with each other.
On the basis of what is in this thread, I would suggest that might not be the case. Mine is a relatively clean installation - I don't have Visual Studio installed yet, although it is ordered - just waiting for delivery:-)
When I receive Visual Studio, I do plan on installing it. In my case, I do not have a full SQL Server (haven't figured out how to set it up yet - that's a different story). I am a small developer, working on an application. My paying job is a Requirements Engineer and I have been working in development, requirements, and business analysis for more than 20 years. Since I have a little down time, I am going to learn SQL Server. It may kill me, but I will learn it! The SQL Express product is exactly what I need for my application. There are not a lot of managment tools for SQL Express, but the SSME seems to be good enough for my purposes.
It would be nice if it had integrated help, or if it could be hooked into SQL Books Online, and I would be quite happy to have a 120 MB file size. I also have a high-speed internet connection, so the large download is less of an issue for me than it might be for some of your other target users, so I can live without the integrated help.
What is proving very frustrating is that I cannot run both SSME and SQL Books Online. I would be perfectly happy if I could, but I cannot - and that is something that probably shouldn't wait until 2006 to fix, particularly given your statement at the start of the thread.
I am not ranting, just providing what I hope is useful feedback. If there is any more information that I can provide you, please feel free to ask - this is important to me, and I do appreciate your time and support in resolving this issue. In the meantime, please fix the problem as soon as you possibly can, because I am already going through a painful learning curve. I made the interesting discovery about how to replace the MS Access IIF() function, and I am still hoping that someone can tell me how to implement a unique constraint on a field that conforms to ANSI (allows many Null values, but only one instance of each non-Null value).
thanks,
Flavelle|||Steven:
In answer to your specific questions:
1. I downloaded from the site and saved to my local hard drive - if you would like, I will be happy to send the specific files for both SSME and BOL that I received so that you can verify that I am working with the right ones. My e-mail address is fballem@.ballemco.com. If you send me an e-mail, then I will zip and send one or both files to you, whichever would be most helpful to you.
2. I tried renaming the registry entry after installing BOL. When I started BOL, I got an error - sent the report to Microsoft using the standard method. If there is any information that I can provide you that will allow you to find this error, then please let me know. The error occurred at about 5:00 p.m. EST. I renamed the registry entry back to Shell and then uninstalled BOL. SSME works fine.
3. The splash screen is very fast, so I can't read it.
Are you having fun yet?
Regards,
Flavelle|||
Flavelle,
No problem - I appreciate your feedback.
I suspect that your web browser cache or a web proxy cache is interfering with you downloading the November 11 update and you are reinstalling the November 7 release again. You can tell which version you have by checking the creation date of the ssmsee.exe file in ...\Program Files\Microsoft SQL Server\90\Tools\Binn\VSShell\Common7\IDE. If the creation date is November 10, 2005, then you have the update. If the creation date is November 3, then you have the first release.
If you have the first release, you can use regedit to rename the "HKEY_LOCAL_MACHINE\Software\Microsoft\Microsoft SQL Server\90\Tools\Shell" key to "HKEY_LOCAL_MACHINE\Software\Microsoft\Microsoft SQL Server\90\Tools\ShellX". This will let the November 7 version of MSE run with Books Online. If MSE still can't start, then we have an unrelated problem I need to investigate further.
The only differences between the November 11 update and the November 7 release are that the November 11 release is supposed to fix the problem with starting MSE when Books Online is installed (without renaming or removing the registry key), the problem of the error message explaining why it isn't starting not appearing, and that the splash screen says "Management Studio Express" rather than "SQL Server Management Studio Express Edition" for the product name.
No comments:
Post a Comment