SQL Server 2000 Service Pack 3a Question
May 26, 2004
There are three separate downloads for this:
1) Sql2ksp3.exe. Updates for database components.
2) Sql2kasp3.exe. Updates for Analysis Services components.
3) Sql2kdesksp3.exe. Updates for Microsoft SQL Server 2000 Desktop Engine (MSDE 2000).
Number 2 makes perfect sense. Analysis Services is separate from the rest of the database.
What is the difference between 1 & 3? What is the Desktop Engine, how do I know if I'm using it, and how do I know if it has already been patched?
View 2 Replies
ADVERTISEMENT
Feb 21, 2004
Hi,
I am trying to install the service pack 3 for sql server 2000 but cannot do it. I keep getting stuck at the screen where it asks u for the windows authentication or the sa password.
I select the sa password option and enter the password but it gives me an error saying that it was unable to connect.
Can someone tell me what to do.
Kind Regards,
Yoshi
View 1 Replies
View Related
Dec 19, 2004
Hi all,
I have msde version 8.00.534 that is sp2 I think. When I attempt to upgrade to sp3a I get: “The instance name specified is invalid� . I am working with win XP home edition that include IIS.
Have some suggestions? Thanks
View 1 Replies
View Related
Dec 19, 2004
Hi all,
I have msde version 8.00.534 that is sp2 I think. When I attempt to upgrade to sp3a I get: “The instance name specified is invalid� . I am working with win XP home edition that include IIS.
Have some suggestions? Thanks
View 1 Replies
View Related
Apr 22, 2002
Hi all,
I want to setup the SP2,so I like to know before if the SP2 is valid and proved and with SP2 I have any problem on administring the server.
Thanks in advance
Jalal
View 1 Replies
View Related
Oct 12, 2006
How to find out the SP available for sql server 2000 with win xp
View 8 Replies
View Related
Jul 20, 2007
I'm trying to install Service Pack 4 to our default instance of SQL Server 2000 with SP3a, on a Windows 2003 Server, which also has a named instance of SQL Server 2005 on it and a named instance of SQL Server 2000 with SP4.
The installation appears to be running just fine, but MUCH too quickly. The last window appears stating something along the lines of 'Updating Active X components'. I'm expecting the scripts to run to update my system stored procedures, etc., but that never occurs. The installer just quits.
No errors in the Windows logs, nor in SQL, and no C:WindowsSQLSP.log file.
I tried the installation again, but this time used a different copy of the service pack 4 installer, with the same results, and again no SQLSP.log file.
Since I was going to remove the named instance of SQL Server 2000 anyway, I verified that my SP4 installer was good by uninstalling the named instance of SQL Server (the one with SP4 already), reinstalling a named instance of SQL Server 2000, and reapplying SP4 to this named instance. Everything went flawlessly.
I then tried reapplying SP4 to the default instance of SQL Server 2000, and this time a SQLSP.log file was finally generated. In the error log, the last entries are:
19:10:03 C:PROGRA~1COMMON~1MICROS~1SQLDEB~1SQLDBR~1.EXE sqldbreg2.exe -RegServer
19:10:04 An error occurred while setting the registry value for: SoftwareMicrosoftMSSQLServerMSSQLServer
19:10:04 Could not restore AuditLevel registry key
19:10:04 Action CleanUpInstall:
19:10:04 Installation Failed.
I confirmed that the service accounts that are running SQL Server both have local administrative access to the server (which may or may not matter), and that they are both sysadmin, so I don't think it's a permissions issue to the registry. I've also verified that the account I was using to run the SP installation also has local admin access on that box.
So, I compared my HKLMSoftwareMicrosoftMSSQLServerMSSQLServer registry entry from our production server to the one on the test server, I see that our test server's entry is completely empty. On production there are numerous subkeys, such as CurrentVersion and RPCNetLib.
I'm planning on copying the registry entries from production to test. Should this be sufficient, or are there other things I should look out for?
View 10 Replies
View Related
Jul 23, 2005
I have an installation of SQL Server 2000. Both MBSA and @@versionshow this to be the gold release. When I install Service Pack 3a, itshows no error. But after restart of the server, it's still unpatched,by both MBSA and @@version.Any idea what may be going on here?
View 3 Replies
View Related
Aug 24, 2007
I have been asked to provide a SQL Server 2000 Service Pack 4 validation procedure... I have been unable to locate any reference to how this can be validated in either the program itself or in the registry... Any help is appreciated...
View 3 Replies
View Related
Aug 25, 2006
Hi,
I am trying to install Service Pack 4 to set up the SQL Server 2000 but I am having problem. When I clicked the setup.bat, the screen just "froze" with the message " validating user. Please wait..."
What seem to be the problem? Please help!!!
Thanks and regards,
View 3 Replies
View Related
Apr 7, 2008
We had a disaster last week (SAN Corruption) and it hit a bunch of my sql serves.
I have been able to recover all but one. The one I am having a problem with is a NAMED Instance that I obviously don't know the original SP level on. When I try to restore MSDB it won't let me because of a version conflict
Is there any way to tell what the SP Level is either from a system DB .mdf or LDF file or from a backup file without restoreing?
Right now I'm installing SQL Server to a test server and I'm going to try and restore the system dbs at each patch level.. seems like there must be a better way!!
View 5 Replies
View Related
Jan 29, 2004
I'm trying to upgrade my SQL Server 2000 Developer's Edition to sp3a, I'm following the instructions.
I receive the following message:
Invalid product code was found. Check if product is installed.
I have installed this from CD I have with me. I followed instruction on http://support.microsoft.com/?kbid=311762
but I don't see product ID/code !!!!!
I have installed default instance (MSSQLSERVER) on my machine. How do I do Update to Service Pack 3a.
I can Install "Database Components "
Downloadable file name: SQL2KSP3.exe SP3a
but I can't install "SQL Server 2000 Desktop Engine(MSDE) "
Downloadable file name: SQL2kdesksp3.exe SP3a.
Any help?
Thank you.
View 1 Replies
View Related
Nov 29, 2005
Hi,
i tried to install SQL Server 2000 Developer and MSDE the whole day on my Windows XP SP2.
MDAC is the latest, that come with WinXP SP2 (2.81). The installation fails at the end after 100% complete.
It says:
Translated: "the setup programm starts the server and installs the configuration you chose..."
("das setup-programm startet den server und installiert die von ihnen gewählte konfiguration...")
then it takes some time and the failure appears, saying:
"the setup programm could not configure the server. you can find more
information in the server-failure-log files and in
"C:windowssqlstp.log."
sqlstp.log last couple of lines:
22:42:10 C:WINDOWSTEMPSqlSetupBinscm.exe -Silent 1 -Action 4 -Service MSSQLSERVER
22:42:10 Process Exit Code: (0)
22:42:10 StatsGenerate returned: 2
22:42:10 StatsGenerate (0x80000000,0x1,0xf000000,0x200,1031,303,0x0,0x1,0,0,0
22:42:10 StatsGenerate -1,toebens)
22:42:10 Installation Failed.
I already read several knowledge base articles on this... removed keys in the registry...and so on...nothing worked :(
this **** makes me angry. please help me.
thanks
View 5 Replies
View Related
Aug 9, 2001
I'm getting ready to load SP1 for sql 2000...are there any iusses I should know about before I load it?
View 1 Replies
View Related
Aug 9, 2001
I'm getting ready to load SP1 for sql 2000...are there any iusses I should know about before I load it?
View 1 Replies
View Related
Mar 3, 2008
We have some "old" servers that are still running SQL 2000 (for various reasons). They have been updated to service pack 4.
In the SQL admin tool, the version number is reported as 8.00.2040. In Windows (Add/Remove Programs list), the version is reported as 8.00.2039. Altiris also sees the version as 2039 since it is reading the Add/Remove list.
???????????????????
View 5 Replies
View Related
Feb 19, 2007
We are having trouble installing SQL2000 service pack 4 on our server. The package runs through and looks like it installs files to c:, but the install never asks us for any of the questions regarding the install of service pack 4. One issue we were thinking about was that MSDE was installed on the server also. We have a 2003 server with SQL 2000 sp3 (8.00.760)
View 6 Replies
View Related
Dec 6, 1999
I'm working in a manufacturing company which run with a sql server 7 but we 'd like to know whether this is relialable because all our manufacture databse is on that
Thanks per advance.
Marc
View 1 Replies
View Related
Jul 6, 1999
Has anyone installed service pack 1 for SQL Server 7 yet? If so where there any problems or gotchas with the installation?
Thanks.
Mike
View 1 Replies
View Related
Dec 28, 1998
Happy Holidays Everyone,
Does anyone know when SQL Server 6.5 Service Pack 5 came out and of any reviews on it?? Would like to make sure there are no major issues or bugs before installing company-wide. Thanks in Advance, Bill.
View 1 Replies
View Related
Apr 23, 1999
If I update my SQL Server 6.5 server with sp5a, do I need to also update the clients?
My clients only have the 'SQL Client Configuration Utility' installed.
Thanks!
Toni
View 1 Replies
View Related
May 18, 2004
The last SP applied to SQL Server is the one given weh :
select @@version
is launched
(or it is related to OS SP).
Thanks
View 5 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
Feb 16, 2002
Hello,
My production server has MS SQL Server 7.0 with service pack 2. I want to install the latest service pack but all my seniors who are working on Unix and sybase sql server
doesn't want to install SP 4 they think with this service pack there has been no problems, we don't want to install new
SP and create problems. CAn anyone guide me that what bugs are fixed and wht are good reasons for installing
latest SP over the old one, and Is there any draw backs about new SP.
Thanks In Advance
Qinglee
View 1 Replies
View Related
Mar 5, 2001
Has anyone had a problem when installing service pack 2 or 3 on SQL Server 7.0? I'm stuck at MDAC upgrade every time, had to 'end task'. Did select @@version afterwards, still on the old version. I didn't try service pack 1 yet.
I found the following page titled "Can't install SQL server service pack 1", but I'm unable to access.
http://www.swynk.com/archive3/4500/45001235457.asp
Any help will be appreciated. Please email me directly. Thanks in advance.
Phyllis
View 1 Replies
View Related
Apr 21, 1999
Can someone help me out to uninstall service pack 5a on SQL server 6.5? We have few problems with this new service pack. Stored procedures could not delete temporary tables created in them.
Can I load the backup databases from this service pack(5a) to service pack 4 servers?
Thanks in advance,
Mohan
View 1 Replies
View Related
Jul 13, 1998
I wanted to find out more about Service Pack 5. I have heard that the purpose of this service pack is to make SQL Server 6.5 Y2K compliant.
Does anyone know anything about this Service Pack (its contents, release date etc). I have checked the Microsoft SQL Server home page, MSDN Library, TechNet, Knowledge Base and have not had much luck.
Thanks!
View 2 Replies
View Related
Mar 12, 2001
Hi Everybody,
We have SQL Server 6.5. We planned to go for Service Pack 5a. Right now SP3 is running on SQL. I went through the "Microsoft Site", we also noted down
some information from the site. In our server we didn't set any password for 'sa'. In the Documentation they hv given some options for setup. I am not able to follow that. Can anybody explain to me what options I hv to give while I execute the setup.exe for "SP5a" and Can anybody please tell me what precautions we have to take before installing the SP5a?.
Vasu
View 1 Replies
View Related
Jan 31, 2008
Does anyone know an easy way to tell when a SQL Server service pack was installed?
CODO ERGO SUM
View 3 Replies
View Related
Sep 11, 2007
I participate in the SQL Server Integration Services and Reporting Services forums and I have seen many outstanding issues users would like to see fixed. Is there a SQL Server 2005 Service Pack 3 being developed and if so when would it become available?
View 3 Replies
View Related
Apr 19, 2006
Is there no "passive" install mode for SP1 (gui but no user input required)? I can run unattended using the /quiet switch but this gives me absolutely no feedback as to progress or success/failure of the install. It also returns to the command prompt immediately whilst kicking of msiexec in the background, meaning I can't trap any errorlevel. How are we supposed to check success or failure in applying the SP for unattended installs? For rolling this out across an enterprise we need something, usually hotfix.exe has a passive install mode.
thx, Simon.
View 4 Replies
View Related
Feb 20, 2007
SQL Server 2005 Service Pack 2 has been released to the web. Many of the questions asked on this forum will be solved by applying Service Pack 2. Please take the time to read about the many benefits this service pack provides.
SQL Server 2005 Service Pack 2:
http://www.microsoft.com/sql/sp2.mspx
SQL Server 2005 Service Pack 2 blogs:
http://blogs.msdn.com/sqlrem/archive/tags/SQL+Server+2005+-+SP2/default.aspx
Thanks,
Sam Lester (MSFT)
View 8 Replies
View Related
Jul 23, 2007
Hi,
I'm just installed the sqlserver 2005 sp2 without installing service pack 1. Can i install service pack 1 after installing sp2? or is it sp2 includes all the sp1 updates?
Thank you and Have a nice day.
Regards,
Ben
View 3 Replies
View Related
