We have got the wrong version of SQL Server 2005 due to not having SSIS. We have loads of DTS packages running and I have tried to import them and its shows no SSIS service installed.
Is the route to upgrade straight forward? We have a couple of databases running on 2005 upgraded from 2000 but most still are active on 2000.
Cheers
Scott
Hi, all. I see two conflicting notes about whether one can install the SQL Server 2005 Trial/Evaluation and then upgrade to Workgroup or Standard editions, without uninstalling the Evaluation edition.
http://msdn2.microsoft.com/en-us/library/ms143393.aspx seems to say YES, you can upgrade to Workgroup/Standard from the Evaluation edition.
http://www.microsoft.com/sql/howtobuy/faq.mspx says NO, you can only upgrade to Enterprise edition from the Evaluation edition. For Workgroup and Standard, you must uninstall the Trial first.
Which is the correct answer?
Thanks,
Stephen
I'd like to upgrade from my current SQL Server version: 09.00.3042 (Workgroup edition that comes with SBS upgrade) to the standard edition that I've just purchased. I've attempted to run setup.exe SKUUPGRADE=1 from the command prompt and it just tells me that there's nothing new to install.
I don't really want to uninstall the current installation just to do something that shouldn't be complicated to do, upgrading software versions should not be a difficult process.
Does anybody have any experience with this?
Can we upgrade from Express 2005 to Standard/Workgroup 2005??If possible with what complexities can it be done??
View 1 Replies View RelatedI would like to ask regarding sa performance difference between the two version of SQL 2005. Which is better the SQL 2005 workgroup or the standard edition..?
Darren Bernabe Blanco
I am putting up a website this month, its pretty complex in terms of the data being stored. We expect to have 1000 users in our first month and grow exponentially from there. In addition, users will be uploading content to the site (mostly jepgs and PDFs).
We currently have a dedicated server and need to decide whether to go with Microsoft SQL Server Workgroup or Standard. Any advice on this?
If we went with workgroup, what is the threshold for the number of users before we would have to switch to standard? Also...are there any huge limitations that would make our site fail if we went with workgroup?
thanks,
sb
I am using SQL Server 2005 Express Edition. I am planning on upgrading to either Workgroup or Standard edition. While working with Express Edition I did find out that this version does not support backup to a network drive.
My question is:
Is it possible to backup directly to a network drive using a Workgroup/ Standard edition of SQL Server rather than backing up to a local drive and then 'copy and paste' to a network drive like the Express Edition.My other question is :
Given a database limit of 50GB, which one of the editions, Workgroup or Standard, will be appropriate for use.Thank you for your time and patience.
Regards
Berly Sam
I will be installing a new, SBS2003 R2 server that comes with SQL 2005 Workgroup Edition. We currently have a SQL 2000 Standard server. Can I installed SQL2000 Standard on SBS2003 R2? The reason for this is that we're not ready to migrate to SQL2005 and we need to continue running SQL2000.
Thanks.
Has anyone had problems like this.
I recently got SQL Server 2005 Workgroup edition. I did the normal
'read everything I could' to make sure I was getting the correct version for my business.
After having to wait 4 weeks to upgrade, as we were waiting for our accounting system to be upgraded to come inline with SQL 2005, I came across the problem where DTS is not really compatible to the degree I needed with this edition.
I have since gone back to the reseller and they say we can't exchange it for Standard edition as 4 weeks has passed.
The only thing we can do is pay out (1 month later) another £6,000 to get the version we need, totaling £11,000
Being that we are a small business, paying out another £6,000 isn't an option.
Does anyone have any good advise on this?
Many thanks
Scott
Hello,
I am currently hosting my ecommerce site on a dedicated server with dual AMD processors and 2 gigs of ram. I have on average 20 people on the site at one time.
on this server i have sql express, from which i understand, only utilizes one of the processors and 1gig of ram. I have the choice to pay an extra 150 a month to have my host put sql workgroup on my system.
My question is, will i notice any kind of real performace boost by upgrading. Or at the level that i am at, there wont be much difference?
Any help would be very useful.
Thanks
I have installed SBS 2003 Premium with Exchange 2003 SP1 and now I want to install SQL server 2005 workgroup edition.
Heres what I noticed during setup, following the steps of the Server 2005 Workgroup Edition instructions, starting with Upgrading the Sharepoint instance of WMSDE.
Preparing the http://companyweb website:
Step 4. I should make a backup of the data directory within program filesMicrosoft SQL ServerMSSQL$SHAREPOINT directory. However there is no data-directory there, so nothing to backup there. This is probably the reason for all the rest of the issues, however what does it mean, why is there no such directory present? I checked before doing the sql install that by going to http://companyweb I did indeed land on the sharepoint internal website.
Rest goes all normal, until :
Attaching the databasefiles to the new SHAREPOINT instance of SQL server 2005.
Step 4.: go to MSSQL$SHAREPOINTdata. Not only is there no such subdirectory now, the whole MSSQL$SHAREPOINT directory has in fact now disappeared. So steps 4 till 6 cannot be performed now.
Then further to
Enable full text search in Windows Sharepoint services
Step 2. Remark: I get the error message as described there, however the solution would be to start the SQL server (Shareoint service. However that service is up and running
Furthermore when I go to http://companyweb now, I also get the errormessage indicating no connection can be established with the configuration database.
When I check for services, I find that the whole MSSQL$SHAREPOINT service has disappeared from the list of services.
I have clients that have the MSDE version installed and we need to upgrade there program to the MSSQL 2005. Is there an easy way to convert the data? Should or Could I uninstall MSDE and than install MSSQL2005 WorkGrp? Will there data be affected? Any tips would be appreciated.Thanks!
View 1 Replies View RelatedHello,I have been searching and reading a lots of information on the microsoft website about the different version of SQL server, but still can not make my decision.In term of performance, is there a real big difference between the workgroup and the standard version? The workgroup is limited to 3 GB of RAM while the standard is unlimited, would that really change the performance if my server has 16Gb or RAM?The price difference is pretty substantial so if could only have to buy the workgroup , it would be better.One more question, regarding the type of licence, my server has 2 processors, could I avoid buying 2 licences and get the Server plus CAL instead. I am using this server to host 4 web-application running on SQL server. Each database is about 15 MB.Thanks in adavance for your advises.Arno
View 3 Replies View RelatedGood day all, I apologize if this is somewhere and I didnt search enough. I currently have a nice internal application that provides company wide visibility into some key data. Im now being asked to create some reports from an Oracle 9i platform in SQL 2005 Reports Server. However the ORACLE data extension is not allowed in the express edition so Im stuck for a moment. I would like to do an inplace upgrade of my existing MS SQL server from 2005 express to 2005 standard. However, I am a little concerned it might break some things. Has anyone achieved this with great results, a mixed bag, or totally blown up their server? I would like to know the good, bad and then down right ugly details of this if there are any. I am currently running a windows 2003 server with MS SQL 2005 Express (Advanced edition to get the Report Server in there). Is it at all possible to do an inplace upgrade from Express to Standard edition and not lose any connectivity permissions, reports server and so on? Would there be 2 seperate installations one for SQL Server and another for the Report server?
Thanks in advance for all your replies, Ive used this forum on many occasions and learned alot along the way. I hope someone here can help.
I have SQL Server 2005 Express that was installed with SharePoint Server 2007. I'm trying to upgrade it to SQL Server 2005 Standard edition and it gives this "Edition Change Check (Warning)" message:
"To change an existing instance of Microsoft SQL Server 2005 to a different edition of SQL Server 2005, you must run SQL Server 2005 Setup from the command prompt and include the SKUUPGRADE=1 parameter."
I tried "setup skuupgrade=1" from the command prompt, but it's giving me the same message.
Can someone tell me how to correctly make the upgrade?
Sam
Hi All,
A client of mine was using SQL Express and soon realised this doesn't meet his needs performance or database size wise. He also realised that SQL Server 2005 Workgroup came free with his R2 version of SBS.
So in essence, I have been trying to find the Microsoft recommended way to upgrade from Express to Workgroup. I have not been able to find a step-by-step guide and to add to my confusion, when I run the work-group installer it tells me to run the installer with a switch which I have gone ahead and done but when selecting components it has all of them defaulted to blanked out.
Surely the process for an in-place upgrade should not be so technical as I am finding it ? To my mind, the natural progression would be to upgrade express to a better capable version of 2005 and should be as easy as pie.
Anyway, I am basically looking for a step-by-step guide on how to upgrade to get it done right the first time as opposed to upgrading and than realised some remenants of Express are still larking about causing trouble.
Regards,
QS
Hi,
right now I'm using SQL2000 Std Edition. Our new application requires an OLAP Svcs to be installed. As I found in SQLBooksOnline HTTP access to OLAP cubes is available only in OLAPSvsc Enterprise Edition. Do I have to upgrade SQL Std Edition as well or it is possible to run OLAP Enterprise on top of SQL2000 Standard? Does anyone of you know about step-by-step guide how to move SQL2K Std to SQL Ent?
Thanks in advance for help
Regards
Karel
Hi,
What is the best way to upgrade a SQL SERVER 2005 EXPRESS to the STANDARD version?
I'm installing SQL 2005 on a cluster. Currently we do not need the features of enterprise edition, but we may need them in the future. Can you upgrade Standard edition to Enterprise edition (on a cluster)?
View 3 Replies View RelatedHello
I've uninstalled SQLExpress(with adv. features, RS worked fine) and then installed Standard edition.
After reinstallation and deploying reports I failed in viewing report through web browser.
Here are errors:
- when I try to view report
Reporting Services Error
An internal error occurred on the report server. See the error log for more details. (rsInternalError) Get Online Help
Error executing child request for /ReportServer/Pages/ReportViewer.aspx.
Exception of type 'System.Web.HttpUnhandledException' was thrown.
Value does not fall within the expected range.
- when I try to navigate to Get Online Help
Error executing child request for /ReportServer/Pages/ReportViewer.aspx.
Exception of type 'System.Web.HttpUnhandledException' was thrown.
Value does not fall within the expected range.
- when I try to navigate to http://localhost/reports
The website cannot display the page
Thank you for any help!
As I found on http://msdn2.microsoft.com/en-us/library/ms143393.aspx its only possible on 32 Bit subsystems and not on native 64 bit - is this true?
In addition is it a complete installations which remains the current configuration? (i guess this because we have to apply all service packs again)?
and at least - is a license upgarde possible or do we have to buy a complete new licence?
Thanks HANNES
First of all I am planning to install sql 2005 standard and sql standard sp2
on vista ultimate professional using vs 2008 pro
I have some questions about installing sql 2005 what is the best way to install sql 2005 on
vista My article I got this from ms 403393 (upgrading sql standard 2005 to sql standard 2005sp2)
1 sql standard .(shortcut right click from cd/dvd not possible) I have heard command prompt start menu, click cmd
type run D: cd/dvd exe
From a wizard (sql sp2)
2. sql standard sp2
a. upgrade using a wizard
b. open a command prompt (not sure if right click is best option)
install dvd media example dqlserver2005sp2-kb921896-exe SKUUPGRADE=1(is run as administrator option on media)
do I type run or what do I type ?
c. go to system configuration page(where is this) you should see a single warnining you need to install
sp2, the edition should say success if it does not please reapply
d. on the registration page please enter your registeration number
e. on the comments to install please enter database services, reporting services
workstation components, books online and development tools( I wish to install
all components)
f. on the instance page click default instance(default install)
g. finish rest of wizard
h. apply sql sp2
I also have of seperate question of upgrading sql from vista using a Configuring local admin account
account (configuring administration from a wizard-will this notify
me by default) I do not want my administrative priviledges elevated.
I will be using default configurations for my installations.........
I often wish there would a nice picture examples of doing this
Please help
How can I upgrade Sql Express SP1 to SQL Server 2005 Standard ?
Hi
I want to Upgrade my express instance "Officeservers" to standard. I have installed Sql Server 2005 standard, but
the MOSS 2007 installs default Officeservers to express. The reason to upgrade is to use the maintenance plans to backup the instance. I have a report server on a different instance (standard).
Do I upgrade with SKUUPGRADE=1 and this is all ?
Do I need to run sp2 after this and does this affect my report server ?
Thanks for your help.
regards
Ivar
Hi Guys,
Having some problems Upgrading from SQL Express 2005 SP2 to SQL 2005 Standard. I'm getting the following:
Name: Microsoft SQL Server 2005 Express Edition
Reason: Your upgrade is blocked. For more information about upgrade support, see the "Version and Edition Upgrades" and "Hardware and Software Requirements" topics in SQL Server 2005 Setup Help or SQL Server 2005 Books Online.
Build version check:
Your upgrade is blocked because the existing component is a later version than the version you are trying to upgrade to. To modify an existing SQL Server component, go to Add or Remove Programs in Control Panel, select the component you would like to modify, and then click Change/Remove.
Pretty sure that I have to have SQL 2005 Std w/SP2 but I don't have a CD with it on. Is there a way that I can create one so that I can upgrade the SQL Instance In-Place.
Thanks in advance
Michael
The upgrade works fine if the instance starts on SP2. But the instance has the hotpatch applied and is running build 3200. When I try the upgrade against the 3200 version it errors out with the following message:
TITLE: Microsoft SQL Server 2005 Setup
------------------------------
SQL Server Setup has encountered the following problem: [Microsoft][SQL Native Client][SQL Server]The certificate cannot be dropped because one or more entities are either signed or encrypted using it.. To continue, correct the problem, and then run SQL Server Setup again.
My question is:
if I upgrade from standard to enterprise on Version: 9.00.3042 it upgrade perfectly well but if I try to upgrade from Version: 9.00.3200 version, it gives the error message.
let me know if anyone can solve the issue at cqldba@gmail.com
Hi All
I'm after some advice, I am looking for the best way to do this:
I have a SQL 2000 Clustered Virtual Instance which is of course Enterprise Edition as it is clustered. I need to upgrade to 2005, but dont need the 2005 Enterprise features, Standard will do, as this supports clustering.
The restrictions are that you cant upgrade 200Ent to 2005Std.
As this is a fairly complex environment, it has a default instance running on node 1 and a named instance running on node 2
I dont particularly want to uninstall both 2000 instances, and then install new 2005 instances
So is it possible to upgrade to 2005 ent, and then downgrade to standard. I have seen a suggestion without any details, that there is an undocumented sp, sp_update_resume, that might do this. Does anyone know about this
Or does anybody have any other suggestions. (the names of the instances have to be the same, as the existing instances)
Thanks in advance
Tom
Hi,
I am hiring a server at a hosting company. This server contains a dozen websites that i made and they all have their own database.
Well, i received a message from my hosting company that they go to remove the SQL 2000 Standard and replace it by SQL 2005 Express.
What do I have to think about that? Can this give database connection problems?
Thanks for your answers.
Hello,
I recently upgraded my MSDE server to SQL Server 2000 database. After the upgrade, I see, every minute,in the logfile that the database is starting whilst in Enterprise manager the database is up and running. I would be grateful if you could bail me out of this anomaly.
Hope to hear from you soon.
Regards,
Albert.
Hi,
Has anyone tried an in-place upgrade from SQL Server 2005 Developer to Standard Edition?
It apears to be a valid upgrade path according to this:
http://msdn2.microsoft.com/en-us/library/ms143393.aspx
Is it just a case of changing the registered licensing info? (I presume all the functionality for Standard exists in the Developer Edition) Or is it a reinstall job?
I want to use a dev license for development on the server, then once its finished, just leave it in place on the box and upgrade the licensing to standard edition. (The client doesn't yet have a Standard License, but does have a Dev License - and wants me to start right away!)
If its going to boil down to having to do a full re-installation then I should get a Standard license from the start, if its just a minor license key change, then I can use a Dev license straight away!
Pls. help. Thank you!
I tried to upgrade an Express edition 2005 to Standard Edition 2005. I did remember to use the command prompt setup parameter to allow the upgrade but still the option to upgrade is disabled. Can upgrade from express to standard?
Randy,
I did run upgrade advisior to check the existed sql 2005 standard edition to upgrade to enterprise editon. I got the following error message:
SQL Server version: 09.00.1399 is not supported by this release of Upgrade Advisor
Is it means the upgrade advisor can only work on from 7.0, 2000 to 2005? If I need check from standard to enterjprise in 2005, what kind of tool I can use?
Just bought the SQL server 2005 standard edition software to replace the express edition that I have been running for the last 6 months.
The setup works fine until I ask it to install the management studio.
At this stage it seems to think that I have a newer version already installed and tells me that it won't upgrade it.
I then wend through the add/remove sotware function in control panel and removed everything to do with SQL server and tried again. The same thing happened.
Any ideas what I should try next ??
James