Like an idiot, I downloaded and upgraded my 2005 SQL Server Express to the 2008 version, without first checking the newsgroups to look for problems I might encounter. Well, I now have a SQL Server Express 2008 database, but no Management Studio.
I'vr run the SQL Server Installation Center, and have been through about every option combination I can think of, but cannot find an option to install the SSMS. I've checked the news groups, but even the couple of posts that I've seen have not provided specific instructions.
Would really appreciate some help here, as I was hoping to work on my database this weekend.
I have yet to see a standalone installer for Management Studio Express 2008, like the one we have for the 2005 version. So in the meantime, you'll need to get a version of Express that includes the tools. I haven't tried this out to see if you can install Management Studio Express without installing another instance. You could try that or you could just remove the instance you installed while waiting for the new edition to download.
Fye" <dale....@nospam.com> wrote: > Like an idiot, I downloaded and upgraded my 2005 SQL Server Express to the > 2008 version, without first checking the newsgroups to look for problems I > might encounter. Well, I now have a SQL Server Express 2008 database, but > no Management Studio.
> I'vr run the SQL Server Installation Center, and have been through about > every option combination I can think of, but cannot find an option to > install the SSMS. I've checked the news groups, but even the couple of > posts that I've seen have not provided specific instructions.
> Would really appreciate some help here, as I was hoping to work on my > database this weekend.
Express with Advanced Services is the one I used. I'm sure that somewhere in the Installation Center, there is a way to activate/install the SSMS, but I cannot find it.
I cannot afford to uninstall SQL Server 2008, since I did the upgraded from 2005, and my 2005 database is no longer available.
>I have yet to see a standalone installer for Management Studio Express >2008, > like the one we have for the 2005 version. So in the meantime, you'll > need > to get a version of Express that includes the tools. I haven't tried this > out to see if you can install Management Studio Express without installing > another instance. You could try that or you could just remove the > instance > you installed while waiting for the new edition to download.
> On 9/6/08 12:52 PM, in article erwuTGEEJHA....@TK2MSFTNGP03.phx.gbl, "Dale > Fye" <dale....@nospam.com> wrote:
>> Like an idiot, I downloaded and upgraded my 2005 SQL Server Express to >> the >> 2008 version, without first checking the newsgroups to look for problems >> I >> might encounter. Well, I now have a SQL Server Express 2008 database, >> but >> no Management Studio.
>> I'vr run the SQL Server Installation Center, and have been through about >> every option combination I can think of, but cannot find an option to >> install the SSMS. I've checked the news groups, but even the couple of >> posts that I've seen have not provided specific instructions.
>> Would really appreciate some help here, as I was hoping to work on my >> database this weekend.
You can't backup your databases and then restore them? Which part can you not "afford"? Anyway, the installation center should have an option called "add features to an existing instance" or something along those lines. I am on a Mac so can't verify right now, but it might be coupled with "create a new instance"...
> Express with Advanced Services is the one I used. I'm sure that somewhere > in the Installation Center, there is a way to activate/install the SSMS, but > I cannot find it.
> I cannot afford to uninstall SQL Server 2008, since I did the upgraded from > 2005, and my 2005 database is no longer available.
> Express with Advanced Services is the one I used. I'm sure that > somewhere in the Installation Center, there is a way to > activate/install the SSMS, but I cannot find it.
it is possible, via SQLExpressWT or SQLExpressWAS, to install just the SSMSBasic tool.. If you installed the basic package of SQLExpress 2008 (but you did not, as you used SQLExpressWAS), you have to upgrade the installed instance (basic) to the one With Advanced Service before trying to install the SSMSBasic tool... but, using the reported packages, you can install, if you like, just the tool on a clean machine not hosting SQLExpress as well.. you are just required to install Windows Installer 4.5 upgrade, Net FWK 3.5sp1 and PowerShell thought... please have a look at my own "experiences" installing SQLExpress 2008 at http://www.asql.biz/Articoli/SQLX08/Art1_1.aspx -- Andrea Montanari (Microsoft MVP - SQL Server) http://www.asql.bizhttp://www.hotelsole.com DbaMgr2k ver 0.21.1 - DbaMgr ver 0.65.1 and further SQL Tools --------- remove DMO to reply
SQL Server 2008 Express Edition with Tools and Advanced Services have SQL Server Management Studio Basic (SSMSB) with them and this feature is called "Management Tools - Basic" and you can check this feature to be installed during SQL Server 2008 Express Edition installation. It's in the Feature Selection window as the other features.
However, if you did not check it during an installation, you can simply install it by running the SQL Server 2008 Express Edition (x) Setup. So this means that you don't have to install another instance of SQL Server 2008 Express Edition to install SSMSB.
During this installation process, in the Installation Type window you should simply select "Add features to an existing instance of SQL Server 2008" and then select the existing SQL Server 2008 instance name -which you have already installed- in the dropdown box. Then keep going. You'll come to the Feature Selection window. Here, if SSMSB is not installed then you'll see that the checkbox (Management Tools - Basic) with it is enabled and unchecked. Then check this feature and keep installing.
> Like an idiot, I downloaded and upgraded my 2005 SQL Server Express to the > 2008 version, without first checking the newsgroups to look for problems I > might encounter. Well, I now have a SQL Server Express 2008 database, but > no Management Studio.
> I'vr run the SQL Server Installation Center, and have been through about > every option combination I can think of, but cannot find an option to > install the SSMS. I've checked the news groups, but even the couple of > posts that I've seen have not provided specific instructions.
> Would really appreciate some help here, as I was hoping to work on my > database this weekend.
> SQL Server 2008 Express Edition with Tools and Advanced Services have SQL > Server Management Studio Basic (SSMSB) with them and this feature is > called "Management Tools - Basic" and you can check this feature to be > installed during SQL Server 2008 Express Edition installation. It's in the > Feature Selection window as the other features.
> However, if you did not check it during an installation, you can simply > install it by running the SQL Server 2008 Express Edition (x) Setup. So > this means that you don't have to install another instance of SQL Server > 2008 Express Edition to install SSMSB.
> During this installation process, in the Installation Type window you > should simply select "Add features to an existing instance of SQL Server > 2008" and then select the existing SQL Server 2008 instance name -which > you have already installed- in the dropdown box. Then keep going. You'll > come to the Feature Selection window. Here, if SSMSB is not installed then > you'll see that the checkbox (Management Tools - Basic) with it is enabled > and unchecked. Then check this feature and keep installing.
> P.S. > I've tested it for you, it simply works.
> -- > Ekrem Önsoy
> "Dale Fye" <dale....@nospam.com> wrote in message > news:erwuTGEEJHA.680@TK2MSFTNGP03.phx.gbl... >> Like an idiot, I downloaded and upgraded my 2005 SQL Server Express to >> the 2008 version, without first checking the newsgroups to look for >> problems I might encounter. Well, I now have a SQL Server Express 2008 >> database, but no Management Studio.
>> I'vr run the SQL Server Installation Center, and have been through about >> every option combination I can think of, but cannot find an option to >> install the SSMS. I've checked the news groups, but even the couple of >> posts that I've seen have not provided specific instructions.
>> Would really appreciate some help here, as I was hoping to work on my >> database this weekend.
I downloaded the Visual Studio Express 2008 Bundle and installed it. This included SQL (which installed just fine), but I do not see the management tools. I then downloaded the SQL express advanced in hopes of fixing the issue, but it will not extract the files in Win32. Do these tools even run in Win32? I am using Windows XP Media Center.
I don't know what "Visual Studio Express 2008 Bundle" is, but I assume you installed the "Visual Studio Express 2008" and you expected to see a GUI to manage your SQL Server databases and then you downloaded and installed SQL Server Management Studio Express and it did not run. This is what I understand from your post.
If so, ensure that the SSMSE Setup was downloaded correctly. It may be corrupted or timed out while being downloaded. Its file size must be 38.4MB.
-- Ekrem Önsoy
"Marc" <M...@discussions.microsoft.com> wrote in message
>I downloaded the Visual Studio Express 2008 Bundle and installed it. This > included SQL (which installed just fine), but I do not see the management > tools. I then downloaded the SQL express advanced in hopes of fixing the > issue, but it will not extract the files in Win32. Do these tools even run > in > Win32? I am using Windows XP Media Center.
Thank you for the response. Yes your assumption is correct, I do have the Visual Studio Express 2008 correctly installed. The problem is that I cannot find anywhere the specific download for SSMSE. All I have found are downloads for SQL Express 2008 with Tools or SQL Express 2008 Advanced. From what I have read in the forums, both of these should fix the issue, but with them I encountered another error in running the executable for those downloads. The extraction fails because it says application "is not a Win32 Application". Where do I find the 38.4MB SSMSE download, and will it give me the same Win32 error?
"Ekrem Önsoy" wrote: > I don't know what "Visual Studio Express 2008 Bundle" is, but I assume you > installed the "Visual Studio Express 2008" and you expected to see a GUI to > manage your SQL Server databases and then you downloaded and installed SQL > Server Management Studio Express and it did not run. This is what I > understand from your post.
> If so, ensure that the SSMSE Setup was downloaded correctly. It may be > corrupted or timed out while being downloaded. Its file size must be 38.4MB.
> -- > Ekrem Önsoy
> "Marc" <M...@discussions.microsoft.com> wrote in message > news:42614E77-A24B-4268-ABA4-F228D4435C46@microsoft.com... > >I downloaded the Visual Studio Express 2008 Bundle and installed it. This > > included SQL (which installed just fine), but I do not see the management > > tools. I then downloaded the SQL express advanced in hopes of fixing the > > issue, but it will not extract the files in Win32. Do these tools even run > > in > > Win32? I am using Windows XP Media Center.
I found this article in a thred concerning these issues, but unfortunately I had to dig for a total of about 4 hours to find this simple solution. As a measure of goodwill to those encountering these same issues, here is the fix:
"Marc" wrote: > Thank you for the response. Yes your assumption is correct, I do have the > Visual Studio Express 2008 correctly installed. The problem is that I cannot > find anywhere the specific download for SSMSE. All I have found are downloads > for SQL Express 2008 with Tools or SQL Express 2008 Advanced. From what I > have read in the forums, both of these should fix the issue, but with them I > encountered another error in running the executable for those downloads. The > extraction fails because it says application "is not a Win32 Application". > Where do I find the 38.4MB SSMSE download, and will it give me the same Win32 > error?
> "Ekrem Önsoy" wrote:
> > I don't know what "Visual Studio Express 2008 Bundle" is, but I assume you > > installed the "Visual Studio Express 2008" and you expected to see a GUI to > > manage your SQL Server databases and then you downloaded and installed SQL > > Server Management Studio Express and it did not run. This is what I > > understand from your post.
> > If so, ensure that the SSMSE Setup was downloaded correctly. It may be > > corrupted or timed out while being downloaded. Its file size must be 38.4MB.
> > -- > > Ekrem Önsoy
> > "Marc" <M...@discussions.microsoft.com> wrote in message > > news:42614E77-A24B-4268-ABA4-F228D4435C46@microsoft.com... > > >I downloaded the Visual Studio Express 2008 Bundle and installed it. This > > > included SQL (which installed just fine), but I do not see the management > > > tools. I then downloaded the SQL express advanced in hopes of fixing the > > > issue, but it will not extract the files in Win32. Do these tools even run > > > in > > > Win32? I am using Windows XP Media Center.
> Thank you for the response. Yes your assumption is correct, I do have the > Visual Studio Express 2008 correctly installed. The problem is that I > cannot > find anywhere the specific download for SSMSE. All I have found are > downloads > for SQL Express 2008 with Tools or SQL Express 2008 Advanced. From what I > have read in the forums, both of these should fix the issue, but with them > I > encountered another error in running the executable for those downloads. > The > extraction fails because it says application "is not a Win32 Application". > Where do I find the 38.4MB SSMSE download, and will it give me the same > Win32 > error?
> "Ekrem Önsoy" wrote:
>> I don't know what "Visual Studio Express 2008 Bundle" is, but I assume >> you >> installed the "Visual Studio Express 2008" and you expected to see a GUI >> to >> manage your SQL Server databases and then you downloaded and installed >> SQL >> Server Management Studio Express and it did not run. This is what I >> understand from your post.
>> If so, ensure that the SSMSE Setup was downloaded correctly. It may be >> corrupted or timed out while being downloaded. Its file size must be >> 38.4MB.
>> -- >> Ekrem Önsoy
>> "Marc" <M...@discussions.microsoft.com> wrote in message >> news:42614E77-A24B-4268-ABA4-F228D4435C46@microsoft.com... >> >I downloaded the Visual Studio Express 2008 Bundle and installed it. >> >This >> > included SQL (which installed just fine), but I do not see the >> > management >> > tools. I then downloaded the SQL express advanced in hopes of fixing >> > the >> > issue, but it will not extract the files in Win32. Do these tools even >> > run >> > in >> > Win32? I am using Windows XP Media Center.
You already very well know about the existing problems of SSMS 2008. I can't use it against my SQL Server databases which are hosted on hosting companies. And most of them are 2000 and 2005 instances. So, SSMS 2008 is useless for me for now and I personally don't care if they release SSMSE 2008 or not...
I can use it fine, you just need to strip Object Explorer Details to the bare minimum (do this while highlighting the databases node for a server you CAN connect to). And tell your host to shut off that stupid Auto-Close feature, anyway.
On 10/10/08 4:03 AM, in article 0BB50CDD-A813-41AB-BD03-0B70F52E3...@microsoft.com, "Ekrem Önsoy"
<ek...@compecta.com> wrote: > You already very well know about the existing problems of SSMS 2008. I can't > use it against my SQL Server databases which are hosted on hosting > companies. And most of them are 2000 and 2005 instances. So, SSMS 2008 is > useless for me for now and I personally don't care if they release SSMSE > 2008 or not...
>I can use it fine, you just need to strip Object Explorer Details to the > bare minimum (do this while highlighting the databases node for a server > you > CAN connect to). And tell your host to shut off that stupid Auto-Close > feature, anyway.
> On 10/10/08 4:03 AM, in article > 0BB50CDD-A813-41AB-BD03-0B70F52E3...@microsoft.com, "Ekrem Önsoy" > <ek...@compecta.com> wrote:
>> You already very well know about the existing problems of SSMS 2008. I >> can't >> use it against my SQL Server databases which are hosted on hosting >> companies. And most of them are 2000 and 2005 instances. So, SSMS 2008 is >> useless for me for now and I personally don't care if they release SSMSE >> 2008 or not...
