Upgrade from Personal to Standard?


    Sponsored Links


  • 1. adding a hard drive for performance.
    I'm running a museum application on SQL2000 under Win2003Server on a server with one disk drive. We have a relatively small db with a limited number of users. Nevertheless I am campaigning to add a second disk drive to this system in order to improve performance. My question is "what files/programs should I move to the second drive in order to get the best performance??" I've read the the books that say move logging, but what about paging for the OS?? Also I've not seen any information on "how to move logging". Must I completely rebuild the server? Is there a KB article on adding a second drive? Thanks in advance for any help.
  • 2. Client Tools on Windows Server 2003 Web Edition
    Is there no way to install the SQL Server client tools on Web Edition? I understand the full DBMS is not supported on that platform, but can't I run just Query Manager?
  • 3. MSDE - [Shared Memory]Invalid connection. H E L P ! ! !
    I am running XP Pro on a laptop. I have installed MSDE to the desktop and the little icon in the system tray will start and stop just fine. I JUST CAN NOT LOGIN TO MSDE. TARGETDIR="C:\Program Files\Microsoft SQL Server\" DATADIR="C:\Program Files\Microsoft SQL Server\SQLData" INSTANCENAME="MSSQL1" SAPWD="fubar" Computer name = CNU4250M5M SQL Server Network Utility (SVRNETCN.EXE)identifies instance on the server as CNU4250M5M\MSSQL1 Named Pipes Default set to \\.\pipe\MSSQL$MSSQL1\sql\query TCP/IP set to 850 SQL Server Client Network Utility (CLICONFG.EXE) says Named Pipes=\\CNU4350M5M\pipe\MSSQL$MSSQL1\sql\query TCP/IP=850 Server Alias:MSSQL1 Server name:MSSQL1 Pipe name:MSSQL1,850 At DOS prompt C:\> osql -U sa <Enter> Password: <I have tried nothing and "fubar"> <Enter> [Shared Memory]Invalid connection. [Shared Memory]ConnectionOpen (Invalid Instance()). What do I do now???????????????????????????
  • 4. classic webtv dial up port local PC accessability
    I am ing a classic web tv mozilla 4.0 and enjoy the compatitbility it has with other house hold entertainment devices. I am using MSN Messenger as my subscription with .NET Passport. I am tiring of the fact I have no local drive to store things on but do not want to give up the networking funtionabiity or pay the cost that my tv already provides for me. The intrigation between a Lunix based server via dial up has not worked out with the new tower I came across even though the sony name brand is prominant on both my PC and WebTV. How are the Codec's threaded if at all? I cannot believe with all the remote technology available today that HTML and or Side serving dedicated services cannot transcend the simple ringtone to ASCII code translation as impossible or even unlikely to our Technitions today. Alphabetical mapping from ringtone 0-9 on a phone pad is plenty of variations and more than enough to map a working W3W Compatible code for ASCII. (Is'nt it???) Am I just a mad scientist or is there Microsoft copatibility out there I cannot access Thank you for any response to this comment. I should hope for something less and Un-network my entire home and just settle for seperate units but I really like what I got and just want to build(affordablly)onto it DKinTheHouse
  • 5. Return all rows - "Provider Cannot be found. It may not be properly installed"
    Simple soution that worked for me: Reinstall any MDACs you come across, I reinstalled 2.6, 2.7 and 2.8 in my quest to fix this problem, but that was probably overkill. Unregister and re-register "C:\Program Files\Common Files\System\Ole DB\msdasql.dll" using regsvr32.exe Andrew Arace

Upgrade from Personal to Standard?

Postby RGF2ZQ » Fri, 09 Sep 2005 19:55:04 GMT

Sorry if this is a stupid question but I'm afraid I have no experience of SQL 
Server at all. 

We have a system recently installed here which is running on SQL Server 2000 
Personal Edition. We need to upgrade this to 2000 Standard Edition.

Can anyone tell me how I do this and how I keep all our existing data? I can 
find plenty on upgrading from 6.5 and 7 but not from Personal. Would 
appreciate any help as I'm sure you can understand I'm kind of nervous about 
trying this just in case something horrible happens! :-O

As I say I know nothing at all about SQL Server - currently working my way 
through a big thick book!

Thanks for any advice


Re: Upgrade from Personal to Standard?

Postby Hari Prasad » Fri, 09 Sep 2005 21:38:08 GMT


You can directly do a edition upgrade by inserting the Standard edition CD.


SQL Server MVP

Re: Upgrade from Personal to Standard?

Postby RGF2ZQ » Fri, 09 Sep 2005 21:58:08 GMT

Many thanks. That seems straightforward enough then. I'll give it a go. Think 
I'll read the section on backing up first though! ;o)



Similar Threads:

1.upgrade sql personal to standard

I have someone that stage my server with sql personal.  Can I upgrade to 
standard without uninstalling my software with the sql table.  If not can I 
backup my database then restore when standard would be installed.


2.Upgrading from Personal to Standard edition

We need to upgrade from Personal Edition to Standard 
edition of SQL Server 2000.  Can anyone tell me whats 
involved with this.  Can we just upgrade with no 
problems.  Will we lose our databases and configurations.

Will we need to re- install service pack3 after upgrade?


3.Behind the Curtain: Upgrade from 2000 Personal to 2000 Standard

4.Upgrade SQL 2000 Personal to SQL 2000 Standard edition

I having problem with upgrading from SQL 2000 Personal to SQL 2000 Standard 
edition. When I try to upgrade the existing installation the following two 
options are masked and doesn't allow me to choose the option to upgrade.

- upgrade your existing installation.

- upgrade your existing installation to a clustered installation. 

I tried to stop the SQL server service and reboot the server. But still I am 
not able to upgrade. Could any one pour some idea on this as to what might 
happening and why it is not allowing me to upgrade?


5.Unable to Upgrade SQL 2000 Personal Edition to Standard Edition


I'm trying to update SQL 200 Personal Edition to Standard Edition following 
the instructions on a W2k Server with SP4 and the option to Upgrade the 
existing instance is disabled in the setup.... ??. Any suggestions ?.

I don't want to make a reinstall because it will takes a long time due to 
the jobs, logins and mantenience plans.

NOTE: W2k is installed in spanish and SQL Personal Edition is installed in 

6. Unable to Upgrade SQL 2000 Personal Edition to Standard Editio

7. Upgrade from Personal Edition to Standard Edition

8. Upgrade from SQL 2K personal to standard editon.



Who is online

Users browsing this forum: No registered users and 91 guest