SQL Server - SP4 for SQL7

I need to upgrade my SQL 7 SP2 server to SP4.  Are there any known problems
with doing this?  Is this a fairly simple upgrade?  SQL7 is on the same
server as Exchange 5.5, is that an issue?

Thanks,

John

  John Bell replied...

Hi

SQL7 SP4 was a long long time ago! Why do you need to move up to this now?

I do not remember there being any problems with the upgrade, but then my
memory of SQL7 is not that great!

John

for SQL Server Express Instance SQL Server I notice that the following registries: HKLM \ SOFTWARE \ Microsoft \ Microsoft SQL Server \ MSSQL.2 \ MSSQLServer \ SuperSocketNeLib HKLM \ SOFTWARE \ Microsoft \ Microsoft SQL Server \ SQLEXPRESS \ MSSQLServer \ SuperSocketNeLib They seem to be for the same instance. But the Registry, for, SQL, Server, Express, Instance description: I notice that the following registries: HKLM \ SOFTWARE \ Microsoft \ Microsoft SQL Server \ MSSQL.2 \ MSSQLServer \ SuperSocketNeLib HKLM \ SOFTWARE \ Microsoft \ Micro

Server Hi Wei Lu, so it is not necessary to run the C: \ Program Files \ Microsoft Visual Studio 8 \ SDK \ v2.0 \ BootStrapper \ Packages \ ReportViewer \ ReportViewer.exe on any client? Thought that this redistributable-package installed correctly the following assemblies in the client's GAC: - Microsoft.ReportViewer.Common Microsoft.ReportViewer.ProcessingObjectModel - Microsoft.ReportViewer.WebForms - Microsoft.ReportViewer.WinForms Question: If it is NOT necessary to run the above mentioned setup, where do I put the two files on the client's PC? - Microsoft.ReportViewer.WinForms.dll - Microsoft.ReportViewer.Common.dll Into the c: \ windows \ system32 ? Thanks for your answer in advance SQL Server Reporting Services Discussions Files (1) Viewer (1) Control (1) Program (1) Microsoft (1) Visual (1) Studio (1) BootStrapper (1) Hello Henry, First, to run a .NET WinForm

Microsoft SQL Server 2005 disappears on one node. SQL Server Hi, Our production database set on Server 2005 (SP1). I installed client tools for all 4 nodes. Every node should show Microsoft SQL Server 2005 and Microsoft Visual Studio 2005 after click All Programs, but in one node the Microsoft SQL Server 2005 disappeared. While I go to Add or Remove Programs, I saw following items: Microsoft SQL Server 2005 (64 bit) Microsoft SQL Server Backward compatibility Microsoft SQL Server Books online (English) Microsoft SQL Server Native Client Microsoft SQL Server Setup Support Files (English) Microsoft SQL Server VSS

MSSQLSERVER) Product Version (Previous): 1399 Product Version (Final) : Status : Failure Log File : C: \ Program Files \ Microsoft SQL Server \ 90 \ Setup Bootstrap \ LOG \ Hotfix \ SQL9_Hotfix_KB921896_sqlrun_sql.msp.log Error Number : 29537 Error Description : MSP Error: 29537 SQL Server Setup has encountered the following problem: [Microsoft][SQL Native Client][SQL Server]Directory lookup for the file operating system error 3(The you send me the values for the following keys in your registry please: HKEY_LOCAL_MACHINE \ SOFTWARE \ Microsoft \ Microsoft SQL Server \ MSSQL.1 \ Setup \ SQLDataRoot HKEY_LOCAL_MACHINE \ SOFTWARE \ Microsoft \ Microsoft SQL Server \ MSSQL.1 \ MSSQLSERVER \ DefaultData HKEY_LOCAL_MACHINE \ SOFTWARE \ Microsoft \ Microsoft SQL Server \ MSSQL.1 \ MSSQLSERVER \ DefaultLog keys Of course these keys assume that your instance

driver's sqlallochandle on sql_handle_env failed SQL Server i have just installed sql clinet (Microsoft SQL Enterprise Manager Microsoft Corporation Version: 8.0) on windows XP sp2 . whenever i try to reg new sql 1) XP (1) Try applying SQL Server 2000 SP4 + Cumulative Hotfix Build 2187. http: / / www.microsoft.com / downloads / details.aspx?FamilyID = 8e2dfc8d-c20e-4446-99a9-b7f0213f8bc5&DisplayLang = en http: / / www.microsoft.com / downloads / details.aspx?FamilyID = 9c9ab140-bdee-44df-b7a3-e6849297754a&displaylang = en http: / / www.microsoft.com / downloads / details.aspx?FamilyID = 1705bd2f-1fb8-4ec8-b3db-0935361308c7&displaylang = en http: / / www microsoft.com / downloads / details.aspx?familyid = A643980A-26A4-44C1-9B50-53E20E7210B5&displaylang = en http: / / www.microsoft.com / downloads / details.aspx?FamilyId = 243A8A89-74D6-48FD-933F-32FF9D8459C2&displaylang = en http: / / www.microsoft.com / downloads / details.aspx?FamilyId = 2BB62F35-D041-42AC-98DA-6EC97168BE21&displaylang = en Sincerely, Anthony Thomas