Last post Sep 09, 2009 09:43 PM by Dan_Hebert
Sep 02, 2009 09:54 PM|Dan_Hebert|LINK
I think I may be totally hosed but figured I might as well ask anyway. I have been working on a website for almost 2 years now. In preparation of finally being able to take it public, I switched to a new web provider that will be able to handle the traffic.
The web host is running Sql Server 2008 I migrated all of my Sql Server 2005 data over to it. Only to find out my vs 2005 cannot access it. The patch available from microsoft only supports pro and team version and will not install.
Has microsoft dropped support for standard, or is this an oversight? Since the patch was released in Nov 2008, are we to assume that sql server 2008 will never be supported in this version. Does anyone know of any way to get this working?
Sep 03, 2009 10:23 AM|integrasol|LINK
Check this out,
Sep 03, 2009 06:05 PM|Dan_Hebert|LINK
I'm sorry I guess I failed to mention that is the patch I have been trying to run. It fails with the message
"The upgrade patch cannot be installed by the windows installer service because the program to be upgraded may be missing. or the upgrade patch may update a different version of the program. Verify that the program to be upgraded exists on your computer
and that you have the correct upgrade patch.
It gives this error because I am running standard. Not Pro or Team version.
Sep 03, 2009 11:51 PM|integrasol|LINK
Have you installed VS 2005 SP1, before trying the patch? Just checking one final thing... ;-)
Sep 05, 2009 02:48 PM|Dan_Hebert|LINK
Yes, I have. I even tried unstalling sp1, then patching (did not work). So I re-installed SP1, still did not work.
Unfortunately after I stumbled into the mess I found the system requirements
Which very clearly does not support VS 2005 standard. I guess what I was looking for is does anyone know why it does not support standard, or has microsoft dropped support for standard. If that is the case then one should never purchase the standard version
again, and/or microsoft should stop selling the version all together if they will not support it.
Sep 06, 2009 02:39 PM|slavik118|LINK
have you tried to install .net framework 3.5 before running the patch?
p.s. why do you want to work on your website directly on hosting server? It is very dicey.
anyway, you can continue working on you website on your pc and then upload changes using ftp, sql server or database publishing wizard.
Sep 09, 2009 09:43 PM|Dan_Hebert|LINK
Yes I have .net framework 3.5 installed, and still it will not install. The problem with the patch is that it checks the version of Visual Studio. Since I have standard installed it will not proceed.
I work on my website locally in visual studio. The database is on the host. I compile and publish to a local folder then ftp that folder to the server. I have the sql server connect string in my web.config. Therefor I cannot do any debug or testing locally,
because it is unable to connect to the database. I want to develop against the hosted sql server instance so that I can avoid synchronization issues. And a local instance of sql server 2008 would not help anyway. The only way that would do anything is
If I had sql server 2005 local and 2008 on the server which would cause another set of headaches.
I am switching my site to VS 2008 and leveraging the power of linq and dynamic data. Because I am expecting high traffic and anything less at this point would be a hack and would sacrifice performance. Which would in turn kill the future of my site.