Applying Service Pack 3a
Feb 20, 2004
Hi,
I am trying to install the eval version of Reporting Services. One of the requirements for installing this is to have SQL Server 2000 with service pack 3a. I've downloaded the service pack and followed the instructions documented by Microsoft (applying SQL2KSP3.exe, then SQL2KASP3.exe).
It appears that the application of the service packs did nothing. No errors where returned after the executable was run. But, after having applied these service packs, the version has not changed. I have restarted the service, and the server with no success. The version that is returned is
'Microsoft SQL Server 2000 - 8.00.194'.
I am running MSSQL server Developer Edition, running on Windows 2000 Professional (service pack 4).
Any suggestions. I have even uninstalled the SQL server and re-applied the service packs, so I really am having trouble trying to figure out what to do next.
Thanks,
Jim
View 3 Replies
ADVERTISEMENT
May 26, 1999
When I try to run SQL Server 6.5 Service Pack 5a, I consistently receive the error message
"Setup initialization could not be successfully completed.
cfgchar.exe could not be executed. Please check the relevant
out file."
I am currently at Service Pack 3.
1) I have insured that the PATH environment variable does not contain quotes.
2) I have no other applications running at the same time as the service pack is running.
The contents of the cfgchar.out file appear as follows:
C:MSSQLcharsets - created
C:MSSQLcharsetscp1250 - created
C:MSSQLcharsetscp1250DICTION.250 - copied
C:MSSQLcharsetscp1250NOCASE.250 - copied
C:MSSQLcharsetscp1250CSYDIC.250 - copied
C:MSSQLcharsetscp1250CSYNC.250 - copied
C:MSSQLcharsetscp1250HUNDIC.250 - copied
C:MSSQLcharsetscp1250HUNNC.250 - copied
C:MSSQLcharsetscp1250PLKDIC.250 - copied
C:MSSQLcharsetscp1250PLKNC.250 - copied
C:MSSQLcharsetscp1250ROMDIC.250 - copied
C:MSSQLcharsetscp1250ROMNC.250 - copied
C:MSSQLcharsetscp1250SHLDIC.250 - copied
C:MSSQLcharsetscp1250SHLNC.250 - copied
C:MSSQLcharsetscp1250SKYDIC.250 - copied
C:MSSQLcharsetscp1250SKYNC.250 - copied
C:MSSQLcharsetscp1250SLVDIC.250 - copied
C:MSSQLcharsetscp1250SLVNC.250 - copied
C:MSSQLcharsetscp1251 - created
C:MSSQLcharsetscp1251DICTION.251 - copied
C:MSSQLcharsetscp1251NOCASE.251 - copied
C:MSSQLcharsetscp1251UKRDIC.251 - copied
C:MSSQLcharsetscp1251UKRNC.251 - copied
C:MSSQLcharsetscp1253 - created
C:MSSQLcharsetscp1253DICTION.253 - copied
C:MSSQLcharsetscp1253NOCASE.253 - copied
C:MSSQLcharsetscp1253GRALTDCT.253 - copied
C:MSSQLcharsetscp1253GRMXTDCT.253 - copied
C:MSSQLcharsetscp1253GRNOACCE.253 - copied
C:MSSQLcharsetscp1254 - created
C:MSSQLcharsetscp1254DICTION.254 - copied
C:MSSQLcharsetscp1254NOCASE.254 - copied
C:MSSQLcharsetscp1255 - created
C:MSSQLcharsetscp1255DICTION.255 - copied
C:MSSQLcharsetscp1255NOCASE.255 - copied
C:MSSQLcharsetscp1257 - created
C:MSSQLcharsetscp1257DICTION.257 - copied
C:MSSQLcharsetscp1257NOCASE.257 - copied
C:MSSQLcharsetscp1257ETIDIC.257 - copied
C:MSSQLcharsetscp1257ETINC.257 - copied
C:MSSQLcharsetscp1257LTHDIC.257 - copied
C:MSSQLcharsetscp1257LTHNC.257 - copied
C:MSSQLcharsetscp1257LVIDIC.257 - copied
C:MSSQLcharsetscp1257LVINC.257 - copied
isql failed - Exit Code: 1
Any ideas?
Peter Townsend
Litens Automotive Group
View 1 Replies
View Related
Jul 12, 2007
Hi all,
I have some doubt about :
What is the basic difference between Patches,SP,Hot fixes in SQL Server ?
and
What are the steps we have to Follow before applying Service Pack ,Patches,Hot fixes?
Thanks
View 7 Replies
View Related
Jun 6, 2006
I have SQL 2005 Express installed. When I try to apply service pack 1 to this by going through the upgrade process, I get an error ' THe installer has encountered an unexpected error. The error code is 2259. Table(s) update failed'
Any ideas? Help!
Ranjit Charles
View 4 Replies
View Related
Jun 1, 2015
I have a question about Service Packs and Cumulative Updates for SQL 2008 R2.
Do you need to apply them in the order that they are released? Or can you just apply the latest Service Pack and Cumulative Update?
View 3 Replies
View Related
Mar 16, 2007
yestarday there is an article released about the service pack for the service pack 2 for sqlserver wo downloaded before mar 5 , 2007.
but to my development server i didn't download sp2 yet. Ifs it safe to download the sp2 for sqlserver 2005 enterprise edition now??
thanks,
View 14 Replies
View Related
Sep 27, 2007
Are there any guidelines or best practices for deploying or testing Service Packs? What types of tests should be performed prior to upgrading or do I just trust Microsoft?
View 4 Replies
View Related
Aug 8, 2006
How do SQL 2000 service packs play a role in upgrading? That is, can SQL 2000 Standard with no Service Packs(SP) be upgraded to SQL 2005 Standard, or does SQL 2000 Standard have to have a certain service pack(SP).
What about re-applying SQL 2005 service packs when upgrading Express SP1 to Workgroup, etc.?
View 4 Replies
View Related
Feb 11, 2002
Hi, sorry but I donīt speak english, my problem:
I install Service Pack 3 to Sql Server 7, but the Store Procedure are missing now, please help me.
View 1 Replies
View Related
Mar 6, 2002
Any one know what is the lasted service pack for SQL server 6.5
Thank you very much.
Judy
View 1 Replies
View Related
Mar 6, 2002
Any one here knows what is the lastest service pack for SQL server 6.5?
Thank you very much.
Judy
View 1 Replies
View Related
Apr 23, 2001
Does Anyone know if there is a way to verify the SQL Service Pack Version on 7.0 on Windows 2000 Advanced server?
I'm getting this results for select @@version
Microsoft SQL Server 7.00 - 7.00.623 (Intel X86)
Nov 27 1998 22:20:07
Copyright (c) 1988-1998 Microsoft Corporation
Enterprise Edition on Windows NT 5.0 (Build 2195: Service Pack 1)
Thanks
Rea
View 2 Replies
View Related
Jun 18, 2001
I installed Service Pack 5 on SQL 7.0 successfully, but when I go back to run @@version, it gives me Service Pack 2 which is the old pack. Does anyone know why and had an experience with this?? Thanks wonderful people!!!
View 4 Replies
View Related
Aug 9, 2001
Has anyone out loaded sp1 that can tell me if there are any issues that I need to be aware of?
View 1 Replies
View Related
Jan 2, 2001
I have a cluster server, with SP3 coming out I wanted to upgrade the SP2 I have right now, when I start SP3 installation it starts and quickly exits from the program. DO I need to uncluster the server before applying SP3? or there is a way arround it?
View 1 Replies
View Related
Jul 31, 2000
has anyone had this experience before after we installed service pack 2 our jobs are taking about 10hrs, some run it says it's succesfull but it didn't update the tables.
View 2 Replies
View Related
Dec 18, 2000
Hello,
I'm installing SQL Server 7.0 on my server, which service pack is good to intall? SP4, I've heard has many bugs? Pls. guide me.
Thanks.
Sejal
View 1 Replies
View Related
Apr 10, 2000
How do I determine which SP has been applied to a server.
@@version returns 'Microsoft SQL Server 6.50 - 6.50.416'
Thanks.
View 1 Replies
View Related
Mar 30, 2000
Anyone know where I can download the lastest service pack
for 6.5??
View 1 Replies
View Related
Oct 19, 1999
Hi,
I have installed service pack-1 on SQL SERVER 7.0
Standard Edition. After the pack is installed @@version is
still showing 7.00.623 instead of 7.00.699
HELP !!!
Thanks
View 2 Replies
View Related
Feb 28, 2001
I'm currently using Base SQL 7.00.623, do I need to apply SP1 before putting SP2 or can go directly to SP2.
View 1 Replies
View Related
Oct 8, 2002
Does anyone else have any concern about this Watson technology creeping in to SQL Server in SP3? I don't like it in Explorer and I'm sure not going to like it in SQL Server!
BTW, Forrest article about the new security patches at http://www.databasejournal.com/news/article.php/1475241 is in error, I think, when it refers to SP4.
View 2 Replies
View Related
Mar 31, 2003
Is the sql server 2000 service pack 3 worth applying to production database server or should I still wait. i do have sql 2000 service pack 2 on the server ?
Thanks
View 5 Replies
View Related
Feb 3, 2004
What's the latest and safest service pack for SQL 2000?
View 1 Replies
View Related
May 12, 2004
I am binding bunch of SQL object change t/sql code into one service pack and then distribute to around 1500 databases.
gradually, I feel I need to put the table/proc/trigger/field/datatype/data size.... all the changes into a kind of database so that could let me or other developers quickly pull out all the change info against a particular object, say table customer. It may have changed 15 times already, from enlarge customerName data size from 30 to 50, add a unique constraint to force the customerName uniquenss, add an index on companyPhone field, modify a delete trigger when an customer becomes inactive to append to a historyCustomer table before delete it....
Of course, the db should also include servicePack release date, each object release reason, approved by.....
At first, it sounds simple and not a big deal, but when I draw something and found the relationship between table--field--datatype--size--constraint is not so simple. Is there something even 'raw' available there already, so I might take a short cut and move on?
thanks
-D
View 8 Replies
View Related
Jun 16, 2004
How would i find out whhich service pack applied to a sql server 2000?
Thanks in advance!!!
View 6 Replies
View Related
Aug 11, 1999
Has anyone found any problems when going from SQL Server 6.5 SP3 to SP5a?
TIA
View 3 Replies
View Related
May 17, 2005
Hi Guys,
Just wanted to ask before I apply my servers with the latest service pack.
Has anyone encountered any problems after applying SP4 or any comments?
Thanks & Regards
View 11 Replies
View Related
Jan 12, 1999
Is there a way to check what version of SQL 6.5 is
currently in use? I installed SP5 but want to verify
whether it is recognized as the current version. Also,
what is the release # for SP5?
Thanks.
Sam
View 2 Replies
View Related
Jan 14, 1999
Is NT Service Pack 4 a requirement to install SQL SP5?
Thanks,
Brina
View 1 Replies
View Related
Mar 24, 1999
Hi everybody,
I just installed service pack 5.0a on a server.While I was installing it,
when it came to the screen "updating system catalogs" it froze up and I had to reboot the machine.I could not get past this screen on successive attempts.
When I do Select @@version it gives me the correct version though.
is there a way to uninstall the sql service pack,or is there another way of finding out whether the service pack was correctly installed.
Thank You
Deepa
View 1 Replies
View Related
Mar 19, 1999
How do i find out in SQL SERVER 6.5 the service pack it is currently running.
View 1 Replies
View Related
May 12, 1999
Hi All,
Feeling a little dense but I don't seem to be able to find out which sp's have been installed for
SQL Server. Seems like it should show up under help. Can anyone tell me how to find out?
Thanks
View 1 Replies
View Related