Hi,
I'm trying to upgrade MSDE with SP4.
I used the following in command prompt.
setup /upgradesp sqlrun INSTANCENAME= MSDE1 SECURITYMODE=SQL
UPGRADEUSER=sa UPGRADEPWD=12345678 /L*v C:MSDELog.log
i got the message "Please go the control panel to install and configure system components."
What does it mean?
How to upgrade it?
Thank U!
I'm confused. Will SQL200 run on NT4.0, SP6a or do I need to upgrade to Microsoft Server 2000 first??? My MSDE is dying...
View 1 Replies View RelatedI am trying to upgrade my MSDE 2000 (SP3)to SP4, but it is giving an error of "invalid instance".
Here is what is on the machine (before running any commands):
I do not see any SQL Server installation on my machine under Start-All Programs. But, I have a directory for SQL Server under:
C:Program FilesMicrosoft SQL ServerMSSQL
The sqlserver.exe is in C:Program FilesMicrosoft SQL ServerMSSQLBinn and version = 2000.80.760.0
To upgrade MSDE 2000 (SP3) to MSDE SP4, I downloaded this file from Microsoft's website: SQL2000.MSDE-KB884525-SP4-x86-ENU.EXE
I ran the above .exe and extracted the files on my hard drive. Now, I have the C:SQL2KSP4MSDE directory and the Setup.exe is in the MSDE directory.
I looked in the services and stopped the following service:
MSSQLSERVER
Now, I ran this command:
setup SAPWD="ourpassword" SECURITYMODE=SQL
/L*v C:MSDELog.log
This came with the error - Invalid Instance
I tried running:
setup /upgradesp sqlrun /L*v C:MSDELog.log
This command ran and did not show any error. I then rebooted the machine, checked that the MSSQLSERVER service is running and checked the version of sqlserver.exe but it was still the same (2000.80.760.0). It should have been 8.00.2039
I am not sure what am I missing. All I want to do is update the MSDE Service Pack on our company machines to SP4.
Please help !
Himy first post in the data access forums, I really hope, someone can enlighten me here...I have a windows server 2003 running with 15 MSDE instances. No I would like to upgrade to SQL Server 2000 without crashing the existing instances... My perfect scenario woudl be- install sql server as new instance- move existing databases via detach / attach to the new instanceWill that work?
View 2 Replies View RelatedHaving some trouble running the SP4 upgrade on a MSDE 2k named instance.Its working for one instance but give me error for the second instance.
- MSDE 2k sp3 currently installed
- Windows XP Pro
- Non-null SA pw
- Executing setup.exe /UpgradeSP SQLRUN
The install runs for a bit and then disappears. Here's what the very
bottom of the log reads:
=== Logging stopped: 08/05/15 11:44:29 ===
MSI (c) (64:F8) [11:44:29:698]: Note: 1: 1729
MSI (c) (64:F8) [11:44:29:698]: Product: Microsoft SQL Server Desktop Engine -- Configuration failed.
MSI (c) (64:F8) [11:44:29:713]: Grabbed execution mutex.
MSI (c) (64:F8) [11:44:29:713]: Cleaning up uninstalled install packages, if any exist
MSI (c) (64:F8) [11:44:29:713]: MainEngineThread is returning 1603
=== Verbose logging stopped: 08/05/15 11:44:29 ===
the only other error I can see is this:
Action start 11:44:29: RestoreSetupParams.2D02443E_7002_4C0B_ABC9_EAB2C06 4397B.
MSI (s) (A8:B4) [11:44:29:651]: Invoking remote custom action. DLL: C:WINDOWSInstallerMSI19E.tmp, Entrypoint: RestoreSetupParams
SOFTWAREMicrosoftMicrosoft SQL Server Setup.{FE7E950B-220A-4182-B5CA-19397244DCFD}
Entering Function MyMsiEvaluateCondition
MsiEvaluateCondition for SQLMSDEInstalled returned TRUE
End Function MyMsiEvaluateCondition
Error reading setup parameters
Action ended 11:44:29: RestoreSetupParams.2D02443E_7002_4C0B_ABC9_EAB2C06 4397B. Return value 3.
Action ended 11:44:29: INSTALL. Return value 3.
SYNTAX Used is : setup.exe /upgradesp sqlrun INSTANCENAME= SECURITYMODE=SQL UPGRADEUSER=sa UPGRADEPWD=MyPwd BLANKSAPWD=1 /L*v D:MSDE.log
Please note that I am using BLANKSAPWD=1 because BUILTINAdministrators right is not present, the above syntax is working for one named instance but is failing in second named instance.:eek:
I'll post the full log if that helps. Any ideas?
Thanks,
Onkar
Does anyone know of a resource that describes the steps to upgrade an instance of MSDE(2000) to SQL 2005 Standard?
We found something on a MS site that indirectly indicated you could upgrade the MSDE to SQL Express and then upgrade Express to the full version of 2005, but that method created quite a bit of problems(System databases), which we were not able to resolve short of uninstalling MSDE and the apps and installing SQL 2005 and re-installing the apps; but I have to believe there is a better way.
Thanks! Bob McEuen
has anybody tried to do that yet? any experiences? how-tos?
View 3 Replies View RelatedI am creating an install for our product and as part of the changes I
am making, I want to upgrade a user's DB engine, if they are still
using MSDE 1.0, to SQL Express 2005.
The upgrade path we have chosen is the following.....
MSDE 1.0 --> MSDE 1.0 sp4 --> SQL Express 2005
I believe this should work, yes? Anywho, I am trying to run a
"passive" install of SQL Express and I am using the following parameter
list:
/qb
UPGRADE=SQL_Engine INSTANCENAME=MSSQLSERVER ADDLOCAL=ALL
DISABLENETWORKPROTOCOLS=0 SECURITYMODE=SQL SQLAUTOSTART=1
SQLBROWSERAUTOSTART=1 SQLACCOUNT="NT AUTHORITYSYSTEM"
SQLBROWSERACCOUNT="NT AUTHORITYSYSTEM"
When SQL Express is installing, everything installs properly except the
backward compatibility component....any idea why this is happening?
I'm certain that some of the above parameters (in red) are wrong because if I install all the engines (above in blue) manually then it all works.
Thanks
I am having issues trying to do an in place upgrade of msde 2000 to sql express 2005. When I try to upgrade it bombs when it reaches "Running action to shutdown instance(Run As Normal User)" with the following error:
Service 'computername' could not be stopped. Verify that you have sufficient privileges to stop system services. The error code is (16386).
I've tried an upgrade on a clean test machine, and it goes through without any problems. I am logged into an account with local admin permissions. If any one has any ideas, they would be appreciated.
Hello,
at the moment I have the following problem:
We have installed a version of the MSDE 2000 Sp3 with our software since 2005. Now we install SQL Server Express 2005 in order to use the latest version and to be compatible with Vista.
We have never had any problems with the MSDE, so it was no problem that we installed the german version (by mistake) because there never was any output at installation time.
When we now upgrade the existing MSDE installing the new version of our software, there are often problems and there are error messages, unfortunately in german, which cannot be read by most of our international users.
The problem is, that there seems to be no possibility to upgrade the existing (german) MSDE with the english version of SQL Server Express 2005.
My question is, if it is possible to upgrade the german MSDE to the english SQL Server 2005 to enable our international users to read the error messages at installation time in english?
Thanks in advance.
Best regards,
Peter
Hello,
I'm not sure if it's the setup I did wrong, but I can't seem to get my
text datatype in my database to store more than 900 characters.
I'm trying to setup a news database for my website, which will populate
the information into a datagrid. To test, I manually added a news
item in the database through the visual studio 2003 gui. I
immediately noticed a problem as the I was getting an error after a
long news item saying:
"The value you entered is not consistent with the data type or length of the column, or over grid buffer limit."
I couldn't find anthing to set the buffer limit and the datatype is
"text" filled with simple text in the column. As a further test,
I
simply entered 12334567890123... up to 900 characters and still
recevied the error.
I would appreciate someone leading me in the right direction on this one.
Thanks a lot.
I am trying to change the computer name of a machine running MSDE but I get an error when SQL Server starts. With regular SQL when I change the name of a computer I re-run setup and setup fixes this problem. MSDE can only be installed from unattended mode so I can’t rerun setup and fix the problem.
My question is "How do I change the name of a computer running MSDE with out reinstalling MSDE"
We currently have the problem, that all our machines are produced with the
same name and afterwards the name is changed. So we have the problem that
the checksum key for the MSDE isn't valid anymore. As MSDE can only be installed
from unattended mode so I can’t rerun setup and fix the problem. Does anyone
know a solution for this problem ?? A program recalculating the cheksum ??
regards,
Manfred
I'm not sure if this is the correct forum for this this question but I'll give it a shot.
The only db development that I have ever done is in MS Access. I have a project at work that is being accomplished in VB and I need a db engine to use as the back end. Visual studio came with a copy of MSDE. Is this tool worth using or should I invest in mySQL? Are there any advantages to using MSDE over mySQL?
Hi,
I have to upgrade the sql server from 6.5 to 7.0 for the first time. I have decided to go with two machine upgrade using named pipes.
The question is: Can we still use 6.5 machine and database as production version until we test out the application on 7.0?
We are planning to relpeat the upgrade once the testing is done on 7.0 server once the testing is done.
We're going to be upgrading our Server from 6.5 to 7.0. In addition we're getting a new SQL Server Box.
Which of the following is better: a) Install SQL 6.5 on the new box, restore the DB from old box to the new box, then install 7.0 on the new box and use the upgrade wizard to upsize the DB. (We'll have room to leave the 6.5 devices on the box after upgrading.) or b) Install SQL 7.0 on the new box and upsize the db across the network (100megabit network cards).
Thanks,
Kevin M. Tupper
EZLinks Golf, Inc.
http://www.ezlinksgolf.com
I'm following a white paper and have run chkupg65 and am stuck at resolving keyword conflicts. I see many TechNet references about fixing them...but none about how. A little help? Below are the conflicts:
Keyword conflicts
Column name: SyncModification.ACTION[SQL-92 keyword]
Column name: Jobs.EXPIREDATE[SQL-92 keyword]
Column name: SqlStoreTable.SIZE[SQL-92 keyword]
Column name: JobDetails.TIME[SQL-92 keyword]
Column name: SchedulerSafeDelete.TIME[SQL-92 keyword]
Column name: SMSEvent.TIME[SQL-92 keyword]
Column name: SyncModification.TIME[SQL-92 keyword]
Column name: vJobDetails.TIME[SQL-92 keyword]
Column name: vSMSEvent.TIME[SQL-92 keyword]
Column name: Sites.TIMESTAMP[SQL-92 keyword]
Column name: QueryExpressions.VALUE[SQL-92 keyword]
Does anyone know of a good book or resource on what's the best way to upgrade 6.5 to 2k? Or generally how would you do that considering you need to do on more then 50 servers?
View 1 Replies View RelatedSo I'm using Visual Studio's one click deployment to install/update software for users. SQL Express 2005 is the default, and I need to get all current and new users to update to SQL Express 2005 SP2. Ontop of that, I need to change the sa password for all current users (I should be able to manually set it for the new guys).
The problem I'm having is that instead of just updating the current SQL Express engine installed, it creates a new instance of the SQL Express engine when installing SQL Express SP2.
Is there anyway to just update SQL Express to SP2? Is there an easy way to change the sa password when doing so?
I have an application which installs MySQL 3.23. It's hard-coded. Irealize there are newer versions, so I am thinking, what's easiest:1) install the application with its default 3.23 and then run a scriptto convert 3.23 to 4.1 or later,or2) modify the application to install a newer version of MySQL from thestart.
View 2 Replies View RelatedI'm in the process of upgrading a gazillion apps from using .MDB files to using SQLCE 3.5. (Or, at least planning the upgrade). Is there an easy way to save existing .MDB files as .SDFs? Also, we have an occasional app that's web based (eg. certification exam, where we have 10 people take it online at the same time, in one day, and the database keeps the score, questions, etc.); is it a good idea to move that kind of app to SQLCE from MDB?
View 3 Replies View Related
Hey,
I have a SQL Server 2005 Express Edition installed, and I want to upgrade to SP2.
Is there a way to configure (using the setup ini file maybe?) the installer to install only the SP2?
Thanks ahead
--sternr
When I run SP3 & SP4 for SQL Server it runs okay. I get no errors after the installation & both installations call for a reboot which I do with no problems.
But yet when I get back into my machine, go to the Query Analyzer & run "Select @@version" and execute it, it's still showing v8.00.194 (Original release). It should be showing 8.00.2039.
Any ideas or suggestions?
Thanks!
We are upgrading our servers from 6.5 to 7.0 SQL servers. I used the same configurations on both 6.5 server and 7.0 server like ANSI and the others. But SQL7.0 server turns out to have different data on some tables. Here is the example on one table. Why?
6.5 database
WT_PAY_PERIOD_DATE WT_RDC_HOURS WT_RDC_EXPENSE WT_MS_SUB_HOURS
------------------ ------------ -------------- ---------------
Apr 20 2002 12:00AM 0.00 0.00 0.00
WT_MS_APPR_IND WT_NEW_EMPL_FLAG WT_ASSOC_OTH_EXPENSE WT_ASSOC_TOT_EXP
-------------- ---------------- -------------------- ----------------
N 3.76 135.21
WT_MS_TOT_EXP WT_MS_MILE_LIM
------------- --------------
135.21 0
7.0 database
WT_PAY_PERIOD_DATE WT_RDC_HOURS WT_RDC_EXPENSE WT_MS_SUB_HOURS
----------------------- ------------ -------------- ---------------
2002-04-20 00:00:00.000 23.50 135.2050 23.50
WT_MS_APPR_IND WT_NEW_EMPL_FLAG WT_ASSOC_OTH_EXPENSE WT_ASSOC_TOT_EXP
-------------- ---------------- -------------------- ----------------
Y X 3.7600 135.2050
WT_MS_TOT_EXP WT_MS_MILE_LIM
------------- --------------
135.2050 373
------------ 135.21 135.21 0
7.0 databases
WT_PAY_PERIOD_DATE WT_RDC_HOURS WT_RDC_EXPENSE WT_MS_SUB_HOURS WT_MS_APPR_IND WT_NEW_EMPL_FLAG
------------------------------------- -------------------------- --------------------------------- -------------------------------- ----------------------------- --------------------------------
2002-04-20 00:00:00.000 23.50 135.2050 23.50 Y X
WT_ASSOC_OTH_EXPENSE WT_ASSOC_TOT_EXP WT_MS_TOT_EXP WT_MS_MILE_LIM
------------------------------------------- ----------------------------------- -------------------------- ---------------------------
3.7600 135.2050 135.2050 373
************************************************** ************************************************** ************************************************** **********************
I have checked the datatypes that are transferred from SQL6.5. They are the same types as SQL6.5. Plus the configurations are the same on both 6.5 and 7.0. The question is that why the values are different? What the way is to fix it?
Hi,
Well there's always a first for everything!! I have a SQL 7.0 server on sP1
and ran upgrade to sp3 and recieved error 'error in upgrade script' retry or cancel. When I retried the upgrade ended. I tried to run the upgrade again and it tries continue where it ended before, but the upgrade ends unsucessfully. I even tried extracted the sp3 exe to a diffrent folder and ran the sp3 upgrade with same results.
I started the MSSQL service ok but not able to use Query Analyzer, DTS, EM.
Get the following message:ISQL.EXE - Entry Point not found. The procedure entry point?DeleteRow@CDataCTLStorage@@UAEJJPAPAG@Z could not be located in the dynamic link library SQLGUI.dll
I get similar msgs when trying to open DTS, Enterprise manager from the server. The user databases and appear to be ok. I am able to get to Query Analyzer, etc. from my worksation fine.
Has anyone encountered this before? Is there a fix for it or do I need to rebuild the server from SP1 and restore the databases, etc.??
Thanks Much,
Steve Bajada
Senior DBA
Has anyone attempted an upgrade from sql7 to 2000? is it a difficult process? what happens to the users. Is there a good site i can go to to get this info ?
Thanks in advance
Does anyone know how to upgrade a sql driver. Or where to get the driver dll from. The client machine is running 3.70.06.23 and needs 3.70.08.20 to connect to the sql server!
View 1 Replies View RelatedOne of my students' company is doing an upgrade from SQL 6.5 to SQL 7.0
and everything converts fine except one veiw. Does anyone know what
would cause this to happen? If they run the script in SQL 7.0 it works
fine. Any thoughts?
CREATE VIEW dbo.vewRptWooActiveList
AS
SELECT vewRptWooActiveListSub1.wotUserValue1,
vewRptWooActiveListSub1.wooNum,
vewRptWooActiveListSub1.wooCreatedWhen,
vewRptWooActiveListSub1.wooDispatchedWhen,
vewRptWooActiveListSub2.MaxOfwslInsertedWhen AS wooLastStatusWhen,
vewRptWooActiveListSub1.wosUserValue1,
vewRptWooActiveListSub1.sitName,
vewRptWooActiveListSub1.empFullName_Cp,
vewRptWooActiveListSub1.Company,
vewRptWooActiveListSub1.Region,
vewRptWooActiveListSub1.ServiceCenter,
vewRptWooActiveListSub1.Zone
FROM vewRptWooActiveListSub1 INNER JOIN
vewRptWooActiveListSub2 ON
vewRptWooActiveListSub1.wooID = vewRptWooActiveListSub2.wsl_WooIDFk
Thanks
Dawn Gill
I have a couple of 6.5 installations with different codepages/sort orders, when I come to upgrade these databases, is it possible to change the code pages/sort order during the upgrade of my existing databases so that I have the same sort order/codepages across all my sites?
The databases don't actually have any extended characters in.
Thanks
Dan
All the documentation I have read talks about upgrading from SQL Server 6.x. I presume I can use the upgrade wizard to upgrade my 6.0 system directly to 7.0 without having to upgrade to 6.5 first.
Any thoughts, comments or help would be much appreciated.
Hi all :
Does the upgrade wizard in 7.0 help me upgrade ALL the database objects in SQL 6.5 (including stored procedures, triggers) to 7.0? Has anyone encountered any problems?
Rnathan
Anyone know of any issues I should be aware of when upgrading from sql 7.0 to 2000? Is it a problematic proccess?
liz
Have you ever faced a problem like this. I am running MS SQL Server 6.5 on Windows NT 4.0 computer whose name is with dashes (hou-is). Now, I try to update to version 7.0 and it gives me error message: @@nameserver from export 6.5 is not valid. Use sp_addserver and sp_netname.
How you can change a sql server name to non-dash name in order to complete the upgrade sql server?
I know this is a challenging tech question.
I appreciate your tech expertise.
Vinh Nguyen from Houston, TX.