service pack updation

Question

hello

I have sql server 2005 version 9.0.2047 with sp1 I am trying to install sp2 or sp3 in it . I have tried with stopping all the services and while they are running also but It is not updating the sql server. so for the same kindly help in the same.


Regards

Puneet Sud 

Answer 1

You need to describe the problem so that we can understand what's going on. Simply saying "it doesn't work" does not give any clue.

Is there any error message? Does the SP2 \ SP3 upgrade Setup work or it does not show up at all? Do you see any clue in the Application \ System Event Logs?

---

Ekrem Önsoy - MCDBA, MCITP:DBA & DBD, MCSD.Net, SQL Server MVP

Answer 2

Hello

It is right that the SP2 \ SP3 upgrade Setup work but the updation doesn't work.  Sorry I could not upload the log file since there are limitations in the technet. That is characters length 4 to 60000.

Regards

Puneet

Answer 3

Hi Puneet,

You can divide and post the logs file in multi posts, or, you can upload the logs file in the Sky Drive and share link with us.

---

Please remember to mark the replies as answers if they help and unmark them if they provide no help.
Welcome to the All-In-One Code Framework! If you have any feedback, please tell us.

Answer 4

What is the error message you are getting while upgrading to SP2 or SP3?

Answer 5

Hello

I have uploaded the file with the following names :

1. Hotfix ( SQL PATCH FILE )

2. Redist9_Hotfix_KB921896 ( SQL Service Pack )

3. Summary ( Sql Patch Summary)

above files are uploaded in the SKY drive whoes url is  http://cid-c5c71f2359c78016.skydrive.live.com/browse.aspx/.Public?uc=1 , please see.


Regards

Puneet Sud

Answer 6

Hi,

I get the files, I will response here if I have any headway.

Have a nice day,

---

Please remember to mark the replies as answers if they help and unmark them if they provide no help.
Welcome to the All-In-One Code Framework! If you have any feedback, please tell us.

Answer 7

Hi,

There was/were no error(s) during the installation from the summary.txt, also, I found there are more than one isntances (X64/X86) installed on your OS, some of the instances have been upgraded to SP1,  some to SP2 and also some to SP3.

If you want to upgrade 32-bit version, you need to use 32-bit version upgradationsource files, and 64-bit will only be applied to 64-bit instances.

If you continue to have any questions about this, please contact us directly.

Have a nice day,

---

Please remember to mark the replies as answers if they help and unmark them if they provide no help.
Welcome to the All-In-One Code Framework! If you have any feedback, please tell us.

Answer 8

thanks for the reply. can you guide me how to find all the instance in sql server also please tell me how to contact you directly.

Answer 9

When we installed 64 bit patch at that time 32 bit sql instances services was off. After that patch installation completed sucessfully with 64 bit instance. After that also it is not showing patch updates.

Answer 10

To find the installed MSSQL Server in your server is simply by below mentioned steps;

STEP 1-

-Start >Programs > MSSQL Server 2005>Configuration tools>SQL Server configuration Manager>Under SQL Server Service. On the right side you will find the Installed Services ,SQL SERVER (MSSQLSERVER).

(MSSQLSERVER)is the instance name, Which is by default MSSQLSERVER, If it’s a name instance you might find with the name.

Count the Services SQL SERVER (……) shows the installed instances.

STEP 2-

You can find the same services name in Services.msc. To check go to run Type Services.msc will open the services details where you can sort and find the installed MSSQL Server services.

Step 3-

Go to Management Studio. Connect tab displays. Drop Down the SERVER NAME tab and click <browse for more >GO to local Server then expand the Database Engine.

BR
Praveen Barath

Mark as helpful if it helps

Answer 11

Thanks for the reply I am able to chck the sql instances. Now If you can help in one more thing that is :

1. One instance OAK-IPLAB-DM is of 64 bit amd I want to install Performance point server in it , since my o/s windows server 2003 EE also of 64 bit and PPS is also of 64 bit. So When I am trying to install SP2 on it , It is not showing me any error messages and also not updating the sql instance from SP1 to SP2. My sharepoint is also installed in this instance only.

2. Second instance OAK-IPLAB-DM\EXPRESS is of 32 bit , and When  I give this instance in PPS it is not giving me any error because it is already updated  with 32 bit sp2 .


So my  question is how to upgrade OAK-IPLAB-DM from sp1 to sp2  , though I have tried with stoping the services from service.msc and also when they are running. I have done it with selecting few modules and selecting all the modules.  I have done lots of R and D in but didn't get any success. So pls help in it.

Regards

Puneet Sud 

Answer 12

Hi,

Follow the steps below to upgrade a specify SQL Server instance:

1. Run the service pack.

2. Select features you want to upgrade (screenshot).

3. When you come to Authentication Panel, Uncheck Apply selection to all isntances, then you can select specify instance in the instance name dropdown list ( screenshot).

4. Click Next, this service pack will upgrade the isntance you specify.

Besides, you don't need to stop services when applying service pack.

Have a nice day,

---

Please remember to mark the replies as answers if they help and unmark them if they provide no help.
Welcome to the All-In-One Code Framework! If you have any feedback, please tell us.

Answer 13

Hello

Thanks for the reply, I am giving you the url, In this url I have uploaded the screen shots of the service pack . I am able to install the features which are "marked" in the  screen shot named "Service Pack"  and the features which are "unmarked" cannot be installed, since "unmarked" cannot be "marked " because sql service pack is not allowing it. And the in the screen shot named "Second Service pack" , it is of Authentication step, in it only one Instance Name is coming i.e. "Database Services (MSSQLSERVER)".

I am running service pack 2 of sql server x 64 service pack named " SQLServer 2005 SP2 - KB 921896 -x64-ENU.exe" . So my question is how to do the updation.


Url is :  http://cid-c5c71f2359c78016.skydrive.live.com/browse.aspx/.Public?uc=2

Regards

Puneet Sud 

Answer 14

Hello

Thanks for the reply, I am giving you the url, In this url I have uploaded the screen shots of the service pack . I am able to install the features which are "marked" in the  screen shot named "Service Pack"  and the features which are "unmarked" cannot be installed, since "unmarked" cannot be "marked " because sql service pack is not allowing it. And the in the screen shot named "Second Service pack" , it is of Authentication step, in it only one Instance Name is coming i.e. "Database Services (MSSQLSERVER)".

I am running service pack 2 of sql server x 64 service pack named " SQLServer 2005 SP2 - KB 921896 -x64-ENU.exe" . So my question is how to do the updation.


Url is :  http://cid-c5c71f2359c78016.skydrive.live.com/browse.aspx/.Public?uc=2

Regards

Puneet Sud 

Answer 15

Hi,

I will check it and response to you soon.

---

Please remember to mark the replies as answers if they help and unmark them if they provide no help.
Welcome to the All-In-One Code Framework! If you have any feedback, please tell us.

Answer 16

Hi,

It seems all are normal, could you run SELECT @@VERSION to check if you have upgraded your instance. If not, please send email to me at sqltnsp#microsoft.com (replace # with @), thanks.

---

Please remember to mark the replies as answers if they help and unmark them if they provide no help.
Welcome to the All-In-One Code Framework! If you have any feedback, please tell us.

Answer 17

Thanks for the reply , I would be greatful to you if you could suggest me some other alternative.

Answer 18

No reply from your side please reply.