Showing posts with label reinstalled. Show all posts
Showing posts with label reinstalled. Show all posts

Friday, March 23, 2012

Reinstalling sql 2005

please ... really need some guidance...
I have removed the old and reinstalled SQL server 2005 standard...
Getting the following message:
Your OS doesn't meet Service pack levels requirements
for this SQL server releaseSo I installed Microsoft SQL Server 2005 Service Pack 1 (SP1)
Getting the following message: This machine does not have a product that matches this installation package.

I have Windows XP Professional 2002 32-bit (Dell), Windows XP Service Pack 2, IIS, NET Framework 2.0., 13GB , processor intel 1,5 GHz, 256MB RAM

1. What is the SKU of SQL Server 2005 are you installing? On Windows XP SP2, SQL Server Enterprise edition cannot be installed.

2. SP1 cannot be installed directly except SQL Express, which is rebuilt in SP1. SP1 should be applied after RTM is installed.

|||

I posted this question to your other thread, but I'll post it here as well to try to get you going again. The error you are getting is a result of trying to instal a version of SQL 2005 on an OS that does not contain the appropriate OS SP, not a SQL service pack. If you can supply us with the exact OS & service pack level and the version of SQL you are trying to install, we can help out.

I'm a little confused on your OS. Can you do start -> Run and type in "winver". This will tell you your OS and SP level. Can you let me know what that shows? That way we'll be able to figure out what you need to install to get going.

Thanks,
Sam

|||Thank you so much! Actually I need SQL standard or develope, but it didn't work yet. So the trial version will not work, or?
Windows XP Professional
Version 5.1 (Build 2600.xpsp_sp2_gdr.050301-1519: Service Pack 2)
(Windows XP Professional version 2002 32-bit, Windows XP
Service Pack 2, IIS, .NET Framework 2.0., 13GB free space,
processor intel 1,5 GHz, 256MB RAM)

Tuesday, March 20, 2012

Reinstall 2nd Node - SQLServer

Cluster active-active. The installation in one server was lost and the S.O.
was reinstalled. Now in one node there are two instances. How can I reinstall
de second node and move the instance to it ?
Look up Maintaining a Failover Cluster in SQL Books-Online. It has step by
step instructions on how to replace a failed cluster node.
Geoff N. Hiten
Microsoft SQL Server MVP
"Shima" <Shima@.discussions.microsoft.com> wrote in message
news:E612484F-C23F-4EAA-ADEA-3144C3247EE4@.microsoft.com...
> Cluster active-active. The installation in one server was lost and the
> S.O.
> was reinstalled. Now in one node there are two instances. How can I
> reinstall
> de second node and move the instance to it ?
>
|||I found on Technet a guideline about "Restoring a Node After a Catastrophic
Failure"
In one of the steps is necessary Remove the node from a virtual server (SQL
Server). My doubt is if in this moment the instance will be unavailable.
The last step is install SQL Server. Is it possible rebuild node to the
virtual server before install SQL Server ?
"Geoff N. Hiten" wrote:

> Look up Maintaining a Failover Cluster in SQL Books-Online. It has step by
> step instructions on how to replace a failed cluster node.
> Geoff N. Hiten
> Microsoft SQL Server MVP
> "Shima" <Shima@.discussions.microsoft.com> wrote in message
> news:E612484F-C23F-4EAA-ADEA-3144C3247EE4@.microsoft.com...
>
>
|||Again, Books-On-line has specific step-by step instructions on how to
restore a node under these exact circumstances. If you do the installation
according to the instructions, the instance will not need to go offline. If
you do not follow the instructions, you may damage your installation.
Geoff N. Hiten
Microsoft SQL Server MVP
"Shima" <Shima@.discussions.microsoft.com> wrote in message
news:EDBEA1E4-87FA-496A-893D-C8A354D57B37@.microsoft.com...[vbcol=seagreen]
>I found on Technet a guideline about "Restoring a Node After a Catastrophic
> Failure"
> In one of the steps is necessary Remove the node from a virtual server
> (SQL
> Server). My doubt is if in this moment the instance will be unavailable.
> The last step is install SQL Server. Is it possible rebuild node to the
> virtual server before install SQL Server ?
> "Geoff N. Hiten" wrote:
|||Thanks for your informations.
I tried to follow the instructions and the setup asked me to Uninstall the
Instance. What does it mean ? The instance will be removed physically ? My
doubt is in this moment. I'm not sure what SQL Setup will do. If the 2
instances will keep available or not. I'm in production environment and the
instances can't be unavailable.
thanks,
Simone
"Geoff N. Hiten" wrote:

> Again, Books-On-line has specific step-by step instructions on how to
> restore a node under these exact circumstances. If you do the installation
> according to the instructions, the instance will not need to go offline. If
> you do not follow the instructions, you may damage your installation.
> Geoff N. Hiten
> Microsoft SQL Server MVP
>
> "Shima" <Shima@.discussions.microsoft.com> wrote in message
> news:EDBEA1E4-87FA-496A-893D-C8A354D57B37@.microsoft.com...
>
>
|||The SQL installer needs to modify the remaining bits on Node 1 to remove all
references to Node 2. In essence, it is erasing all traces of Node 2 from
the SQL instance. It will not completely remove your SQL instance. If this
is done correctly, the SQL instance currently running on Node 1 will not be
affected.
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
"Shima" <Shima@.discussions.microsoft.com> wrote in message
news:64C2F5EB-54A1-4233-87FA-122081210718@.microsoft.com...[vbcol=seagreen]
> Thanks for your informations.
> I tried to follow the instructions and the setup asked me to Uninstall the
> Instance. What does it mean ? The instance will be removed physically ? My
> doubt is in this moment. I'm not sure what SQL Setup will do. If the 2
> instances will keep available or not. I'm in production environment and
> the
> instances can't be unavailable.
> thanks,
> Simone
> "Geoff N. Hiten" wrote: