failure installing SP3 in Database Services

Last Post 11 Aug 2009 06:16 AM by ogruizr. 6 Replies.
AddThis - Bookmarking and Sharing Button Printer Friendly
  •  
  •  
  •  
  •  
  •  
Sort:
PrevPrev NextNext
You are not authorized to post a reply.
Author Messages
ogruizr
New Member
New Member

--
10 Aug 2009 10:48 AM
Hi all,

We have a x64 Server with SQL Server 2005 Database Services (MSSQLSERVER), SQL Server 2005 Integration Service and Analysis Service. We installed SP3 last night but It failured in SQL Server Database Services (MSSQLSERVER) the rest finished fine.

What can I do to fix this?


Additional, some users get "internal error" when they try to process a cube.
ogruizr
New Member
New Member

--
11 Aug 2009 04:28 AM
Error Description : MSP Error: 29537 SQL Server Setup has encountered the following problem: [Microsoft][SQL Native Client][SQL Server]The server principal "sa" is not able to access the database "master" under the current security context.. To continue, correct the problem, and then run SQL Server Setup again.


I don't know why this generate this error. I use my account first and after that I used accoont sa but It always shows the same error.


Additionaly, some user are calling me by phone to tell me that they don't have permissions. Some of then have lost permissions, why?
ogruizr
New Member
New Member

--
11 Aug 2009 06:16 AM
It has SQL Server and Windows Authentication mode enabled.
ogruizr
New Member
New Member

--
11 Aug 2009 02:23 PM
sa is the owner of the database master.
ogruizr
New Member
New Member

--
12 Aug 2009 06:21 AM
I found the following error but I don't know how to fix it:

Property(S): SQL200564Hotfix4035 = C:\WINDOWS\Installer\589db51.msp
MSI (s) (60:48) [21:29:03:394]: Product: Microsoft SQL Server 2005 (64-bit) - Update 'Service Pack 3 for SQL Server Database Services 2005 (64-bit) ENU (KB955706)' could not be installed. Error code 1603. Additional information is available in the log file C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Hotfix\SQL9_Hotfix_KB955706_sqlrun_sql.msp.log.

MSI (s) (60:48) [21:29:03:394]: Windows Installer installed an update. Product Name: Microsoft SQL Server 2005 (64-bit). Product Version: 9.3.4035.00. Product Language: 1033. Update Name: Service Pack 3 for SQL Server Database Services 2005 (64-bit) ENU (KB955706). Installation success or error status: 1603.
ogruizr
New Member
New Member

--
13 Aug 2009 04:02 AM
At the end of file is:

MSI (s) (C4:40) [14:06:51:758]: Product: Microsoft SQL Server 2005 (64-bit) -- Configuration completed successfully.

MSI (s) (C4:40) [14:06:51:758]: Windows Installer reconfigured the product. Product Name: Microsoft SQL Server 2005 (64-bit). Product Version: 9.3.4035.00. Product Language: 1033. Reconfiguration success or error status: 0.

MSI (s) (C4:40) [14:06:51:773]: Attempting to delete file C:\WINDOWS\Installer\8d0f1e4.msp
MSI (s) (C4:40) [14:06:51:789]: Cleaning up uninstalled install packages, if any exist
MSI (s) (C4:40) [14:06:51:789]: Post-install cleanup: removing installer file 'C:\WINDOWS\Installer\8d0f1e4.msp'
MSI (s) (C4:40) [14:06:51:805]: Attempting to delete file C:\WINDOWS\Installer\8d0f1e4.msp
MSI (s) (C4:40) [14:06:51:805]: Unable to delete the file outside of the engine. LastError = 2
MSI (s) (C4:40) [14:06:51:805]: MainEngineThread is returning 0
MSI (s) (C4:CC) [14:06:51:805]: No System Restore sequence number for this installation.
ogruizr
New Member
New Member

--
13 Aug 2009 07:40 AM
Not, I used a domain account (my domain account)
You are not authorized to post a reply.

Acceptable Use Policy