When I try to open the SQL Server Configuration Manager, I get the error "MMC could not create the snap-in. The snap-in may not have been installed correctly." Everything must be really messed up and I still have not a clue what's going on. I've checked
all Web references and couldn't find any resolution.
I installed SQL 2008 Express CTP today on top of SQL 2005 Express. You can find the steps at http://techsassy.blogspot.com
It is working fine for me.
What is your situation now and what are you trying to do? Are you trying to install SQL 2005 or 2008 or both?
I have a filter that won't let me get to any blogspot.com pages so I was wondering if you can please paste the text here from your blogspot post.
What is "CTP"? I've seen that term bantered about but never defined.
My intention always has been to install 2008; and you've obviously had much more success with this task than I have. The only reason I tried to revert back to 2005 was out of desperation since 2005 was operational before. I'm trying pure 2008 now, but just
so you know, I had the same problem with 2005 installed. Nothing is working. One person suggested that in addition to uninstalling, I should delete all the SQL Server folders. I did this which enabled me to go farther in the next installation process; but
once installed, I still get the same error messages when I try to use the application under VWD 2008. And when I try to use the Configuration Manager, I receive an error message that MMC wasn't properly installed. I've looked at and followed the many recommendations
on these posts, but still no joy.
What is "CTP"? I've seen that term bantered about but never defined.
CTP means Community Technology Preview. So CTP versions are just preview versions for the Developer Community to get a feel of what is coming.
muybn
I have a filter that won't let me get to any blogspot.com pages so I was wondering if you can please paste the text here from your blogspot post.
Here is the post.
I currently have SQL Server 2005 Express Edition installed on my system. I also have the Visual Web Developer 2008 Express Beta 1 installed, but while installing it I did not choose for SQL Server 2008 Express to be installed. So now I am going to try and
install it separately. This post is about what I am doing on my system and the steps here may not work in your case. But still I am putting it up as a reference.
Go to the Microsoft Express editions site and
click on download SQL Server 2008 CTP. Also back up your existing databases. One thing I have learnt in the industry is that it is never too expensive to keep backups. Always keep a backup, at least for those things that you feel are critical.
After you have downloaded the setup, when you execute it, the first screen you get is the EULA.
Read the License at least once. Most of us don't read and select the I accept terms checkbox and click next. By reading I do not mean understand each and every thing, but just skim through it once to see if it contains anything that might interest you. e.g
The above License says that it is valid till July 25, 2008, which is not very far and that the software will stop working after 180 days since installation. These are things which caught my eye.
When you proceed you get the following screen.
I clicked on Install and then get the following screen.
I see the option of Upgrade SQL Server 2005 to 2008 which says I should run the Update Advisor first. I can't find the Update Advisor so I just select the option to see what happens. It opens a new windows where it checks my system. In the options on the
left side of the Wizard I can see Select instance, meaning I would have to select my SQL Server 2005 Instance which I want to upgrade. Since I came across
this post in ASP.NET forums, I am not sure that is what I want to do. Plus there is nothing wrong in having both the versions of SQL Server running as different Instances. At
work, I have seen people with both SQL 2000 and 2005 on their systems. So I cancel the Wizard and then in the window above I select New Installation.
I get the System Configuration Check again which is Successful. But now on the left side in the steps, I DO NOT see Select Instance. So my guess is that this is going to install a new Instance of SQL Server 2008 and not do anything to SQL Server 2005 already
alive and kicking. I click on Next.
I select all the options and click on Next. (Actually I had already clicked on Next and moved to the Next Step when I realized that I had not taken the screen shot of the step. So I moved to previous one to take the screen shot. But notice that in the steps
on the left, the Next Step is already checked. A BUG!)
Instead of Default Instance, I select Named Instance and Give it a new name SQL2008CTP. I can see 2 existing Instances towards the bottom, one of which is SQL 2005 instance.
Next it is asking for the User Name and Password (Credentials) to configure the service. Provide the appropriate details. You are then shown the screen below for database engine configuration.
I chose the mixed mode authentication. I am no DB guy and I do this because one of my first mentors told me that always choose Mixed Mode.
I then get a screen above for sending data to MSFT. I click on Next.
I then get the summary of the Installation order.I click Install to begin the installation.
Above is a screen shot I took while the installation was in progress. Though the progress bar did not reach 100% the next button was enabled and the progress bar remained that way for quite some time so I just pressed next to go the following screen.
I then go to services.msc and check if the service has been installed.
As you can see, now there are three instances of SQL Server running. So SQL2008CTP seems to be running fine along with SQLEXPRESS which is SQL Server 2005 Express. I now go to SQL Server Management Studio Express but I cant find the 2008 CTP instance I
just installed. So I think I should restart my computer once. It is always better to restart in my experience.
I restarted and checked but still I don't see the 2008 CTP instance in Management Studio Express, probably because the Management Studio Express is and older version and may not recognize newer versions of SQL Server. So now I open VWD 2008 Express Beta
1 and go to Database Explorer and try to add a new connection.
As expected I can see the 2008 CTP instance I installed. I provide the sa login and password and select tempdb database and test the connection and Voila!
So things seem to be working fine. Phew!
Hope this was helpful! Please comment if you have any queries.
Open the SQL Server Surface Area Configuration, click the link "Surface Area Configuration for Services and Connections.
Click to expand the SQLEXPRESS. Mark "Remote Connections" and set this to use both TCP/IP and named pipes.
In both DB Engine and browser, you can set the startup type to "automatic"
So, I'm concluding that MS has so many of the 2008 Express versions out there that some work better than others. At any rate, Shashi Singh (sassyboy) recommended CTP and I've had a bit more success after installing that but in the end, I still get the "SQL
Server does not allow remote connections" error. I finally got my Configuration Manager working after the CTP installation; it didn't have the exact same items per the above, but I enabled Named Pipes and TCP/IP wherever I found them.
Another strange thing I found was that while installing the CTP version, it didn't go through the SQL Server screens that Shashi Singh showed; however, when I ran the separate SQL Server exe file, it did use the screens.
Would deleting the named instance then re-creating it be a good method? Is it even possible to do this? What are some other diagnostics I can do? SQL Server Express shows in the Services menu. I hope someone can help me soon. I'm tempted to revert everything
back to VWD 2005 which was working, but I can't since a class I'm taking requires ASP.Net 3.5 and VS 2008.
So, I'm concluding that MS has so many of the 2008 Express versions out there that some work better than others. At any rate, Shashi Singh (sassyboy) recommended CTP and I've had a bit more success after installing that but in the end, I still get the "SQL
Server does not allow remote connections" error.
Hi Muybn,
For me right now there is only one version of SQL Server 2008 available and that is the CTP. If you check out the Express Products page, it still shows SQL Server 2005 Express. (http://www.microsoft.com/express/product/) The CTP is the preview
of Future version which I guess will be released soon. But I think you can use CTP for the time being.
Check out the following links to see if they are helpful. I dont think that again reinstalling is a very good idea. You have done it so many times but still it doesnt work.
tskaar
Member
4 Points
6 Posts
Re: how to upgrade SQL Express 2005 to 2008
Jul 17, 2008 08:25 PM|LINK
Did you check in the Surface Area Configuration?
Open the SQL Server Surface Area Configuration, click the link "Surface Area Configuration for Services and Connections.
Click to expand the SQLEXPRESS. Mark "Remote Connections" and set this to use both TCP/IP and named pipes.
In both DB Engine and browser, you can set the startup type to "automatic"
muybn
Participant
852 Points
1277 Posts
Re: how to upgrade SQL Express 2005 to 2008
Jul 18, 2008 04:58 PM|LINK
When I try to open the SQL Server Configuration Manager, I get the error "MMC could not create the snap-in. The snap-in may not have been installed correctly." Everything must be really messed up and I still have not a clue what's going on. I've checked all Web references and couldn't find any resolution.
tskaar
Member
4 Points
6 Posts
Re: how to upgrade SQL Express 2005 to 2008
Jul 18, 2008 07:59 PM|LINK
Looks like a Vista security issue. If you have Vista, take look at
http://support.microsoft.com/kb/930056/en-us
sassyboy
Member
728 Points
322 Posts
Re: how to upgrade SQL Express 2005 to 2008
Jul 20, 2008 07:15 AM|LINK
I installed SQL 2008 Express CTP today on top of SQL 2005 Express. You can find the steps at http://techsassy.blogspot.com
It is working fine for me.
What is your situation now and what are you trying to do? Are you trying to install SQL 2005 or 2008 or both?
S@ss (Shashi Shekhar Singh)
My Blog
Please mark a post as ANSWER if that post helped resolve your query.
muybn
Participant
852 Points
1277 Posts
Re: how to upgrade SQL Express 2005 to 2008
Jul 21, 2008 04:08 AM|LINK
muybn
Participant
852 Points
1277 Posts
Re: how to upgrade SQL Express 2005 to 2008
Jul 21, 2008 02:34 PM|LINK
What is "CTP"? I've seen that term bantered about but never defined.
My intention always has been to install 2008; and you've obviously had much more success with this task than I have. The only reason I tried to revert back to 2005 was out of desperation since 2005 was operational before. I'm trying pure 2008 now, but just so you know, I had the same problem with 2005 installed. Nothing is working. One person suggested that in addition to uninstalling, I should delete all the SQL Server folders. I did this which enabled me to go farther in the next installation process; but once installed, I still get the same error messages when I try to use the application under VWD 2008. And when I try to use the Configuration Manager, I receive an error message that MMC wasn't properly installed. I've looked at and followed the many recommendations on these posts, but still no joy.
sassyboy
Member
728 Points
322 Posts
Re: how to upgrade SQL Express 2005 to 2008
Jul 21, 2008 05:21 PM|LINK
CTP means Community Technology Preview. So CTP versions are just preview versions for the Developer Community to get a feel of what is coming.
Here is the post.
I currently have SQL Server 2005 Express Edition installed on my system. I also have the Visual Web Developer 2008 Express Beta 1 installed, but while installing it I did not choose for SQL Server 2008 Express to be installed. So now I am going to try and install it separately. This post is about what I am doing on my system and the steps here may not work in your case. But still I am putting it up as a reference.
Go to the Microsoft Express editions site and click on download SQL Server 2008 CTP. Also back up your existing databases. One thing I have learnt in the industry is that it is never too expensive to keep backups. Always keep a backup, at least for those things that you feel are critical.
After you have downloaded the setup, when you execute it, the first screen you get is the EULA.
Read the License at least once. Most of us don't read and select the I accept terms checkbox and click next. By reading I do not mean understand each and every thing, but just skim through it once to see if it contains anything that might interest you. e.g The above License says that it is valid till July 25, 2008, which is not very far and that the software will stop working after 180 days since installation. These are things which caught my eye.
When you proceed you get the following screen.
I clicked on Install and then get the following screen.
I see the option of Upgrade SQL Server 2005 to 2008 which says I should run the Update Advisor first. I can't find the Update Advisor so I just select the option to see what happens. It opens a new windows where it checks my system. In the options on the left side of the Wizard I can see Select instance, meaning I would have to select my SQL Server 2005 Instance which I want to upgrade. Since I came across this post in ASP.NET forums, I am not sure that is what I want to do. Plus there is nothing wrong in having both the versions of SQL Server running as different Instances. At work, I have seen people with both SQL 2000 and 2005 on their systems. So I cancel the Wizard and then in the window above I select New Installation.
I get the System Configuration Check again which is Successful. But now on the left side in the steps, I DO NOT see Select Instance. So my guess is that this is going to install a new Instance of SQL Server 2008 and not do anything to SQL Server 2005 already alive and kicking. I click on Next.
I select all the options and click on Next. (Actually I had already clicked on Next and moved to the Next Step when I realized that I had not taken the screen shot of the step. So I moved to previous one to take the screen shot. But notice that in the steps on the left, the Next Step is already checked. A BUG!)
Instead of Default Instance, I select Named Instance and Give it a new name SQL2008CTP. I can see 2 existing Instances towards the bottom, one of which is SQL 2005 instance.
Next it is asking for the User Name and Password (Credentials) to configure the service. Provide the appropriate details. You are then shown the screen below for database engine configuration.
I chose the mixed mode authentication. I am no DB guy and I do this because one of my first mentors told me that always choose Mixed Mode.
I then get a screen above for sending data to MSFT. I click on Next.
I then get the summary of the Installation order.I click Install to begin the installation.
Above is a screen shot I took while the installation was in progress. Though the progress bar did not reach 100% the next button was enabled and the progress bar remained that way for quite some time so I just pressed next to go the following screen.
I then go to services.msc and check if the service has been installed.
As you can see, now there are three instances of SQL Server running. So SQL2008CTP seems to be running fine along with SQLEXPRESS which is SQL Server 2005 Express. I now go to SQL Server Management Studio Express but I cant find the 2008 CTP instance I just installed. So I think I should restart my computer once. It is always better to restart in my experience.
I restarted and checked but still I don't see the 2008 CTP instance in Management Studio Express, probably because the Management Studio Express is and older version and may not recognize newer versions of SQL Server. So now I open VWD 2008 Express Beta 1 and go to Database Explorer and try to add a new connection.
As expected I can see the 2008 CTP instance I installed. I provide the sa login and password and select tempdb database and test the connection and Voila!
So things seem to be working fine. Phew!
Hope this was helpful! Please comment if you have any queries.
S@ss (Shashi Shekhar Singh)
My Blog
Please mark a post as ANSWER if that post helped resolve your query.
sassyboy
Member
728 Points
322 Posts
Re: how to upgrade SQL Express 2005 to 2008
Jul 21, 2008 05:23 PM|LINK
And yeah, even i agree that if nothing seems to be working, it is best to delete the whole Microsoft SQL Server Folder and start over again.
S@ss (Shashi Shekhar Singh)
My Blog
Please mark a post as ANSWER if that post helped resolve your query.
muybn
Participant
852 Points
1277 Posts
Re: how to upgrade SQL Express 2005 to 2008
Jul 22, 2008 05:21 PM|LINK
Another strange thing I found was that while installing the CTP version, it didn't go through the SQL Server screens that Shashi Singh showed; however, when I ran the separate SQL Server exe file, it did use the screens.
Would deleting the named instance then re-creating it be a good method? Is it even possible to do this? What are some other diagnostics I can do? SQL Server Express shows in the Services menu. I hope someone can help me soon. I'm tempted to revert everything back to VWD 2005 which was working, but I can't since a class I'm taking requires ASP.Net 3.5 and VS 2008.
sassyboy
Member
728 Points
322 Posts
Re: how to upgrade SQL Express 2005 to 2008
Jul 23, 2008 06:06 AM|LINK
Hi Muybn,
For me right now there is only one version of SQL Server 2008 available and that is the CTP. If you check out the Express Products page, it still shows SQL Server 2005 Express. (http://www.microsoft.com/express/product/) The CTP is the preview of Future version which I guess will be released soon. But I think you can use CTP for the time being.
Check out the following links to see if they are helpful. I dont think that again reinstalling is a very good idea. You have done it so many times but still it doesnt work.
http://www.velocityreviews.com/forums/t364833-sql-server-does-not-allow-remote-connections.html
http://support.microsoft.com/default.aspx?scid=kb;EN-US;914277
http://www.datamasker.com/SSE2005_NetworkCfg.htm
Hope this helps!
S@ss (Shashi Shekhar Singh)
My Blog
Please mark a post as ANSWER if that post helped resolve your query.