Monday, February 20, 2012

Microsoft SQL Server Management Studio SP2 upgrade

Hi
Having an issue after sp2 install on SQl 2005. The problem I am having is
when I try to open the Maintenance Plans applet in system manager. I get th
e
following error:
TITLE: Microsoft SQL Server Management Studio
--
Failed to retrieve data for this request. (Microsoft.SqlServer.SmoEnum)
For help, click:
http://go.microsoft.com/fwlink?Prod...er&LinkId=20476
ADDITIONAL INFORMATION:
An exception occurred while executing a Transact-SQL statement or batch.
(Microsoft.SqlServer.ConnectionInfo)
Invalid column name 'from_msx'.
Invalid column name 'has_targets'. (Microsoft SQL Server, Error: 207)
For help, click:
http://go.microsoft.com/fwlink?Prod...07&LinkId=20476
BUTTONS:
OK
--
I do not see any of the previse jobs the only thing I get is this error.
Any help is appreciated.
Dell Poweredge 1950
Windows 2003 STD sp2
Intel Xeon 3.2
4.0 gb Ram
--
Joel Cavazos
Network Administrator
MCSE, MCSA, MCPDid you upgrade the client tools but not the server instance (database
services)?
Aaron Bertrand
SQL Server MVP
"jcavazos" <jcavazos@.discussions.microsoft.com> wrote in message
news:DE12769F-1002-48C7-8487-89753A36CC84@.microsoft.com...
> Hi
> Having an issue after sp2 install on SQl 2005. The problem I am having is
> when I try to open the Maintenance Plans applet in system manager. I get
> the
> following error:
> TITLE: Microsoft SQL Server Management Studio
> --
> Failed to retrieve data for this request. (Microsoft.SqlServer.SmoEnum)
> For help, click:
> http://go.microsoft.com/fwlink?Prod...er&LinkId=20476
> --
> ADDITIONAL INFORMATION:
> An exception occurred while executing a Transact-SQL statement or batch.
> (Microsoft.SqlServer.ConnectionInfo)
> --
> Invalid column name 'from_msx'.
> Invalid column name 'has_targets'. (Microsoft SQL Server, Error: 207)
> For help, click:
> http://go.microsoft.com/fwlink?Prod...07&LinkId=20476
> --
> BUTTONS:
> OK
> --
> I do not see any of the previse jobs the only thing I get is this error.
> Any help is appreciated.
> Dell Poweredge 1950
> Windows 2003 STD sp2
> Intel Xeon 3.2
> 4.0 gb Ram
> --
> Joel Cavazos
> Network Administrator
> MCSE, MCSA, MCP|||Aaron
Going back thur the update summary log I did find that thier was a error in
the update process regarding the database services the error is:
----
--
Product : Database Services (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_KB92189
6_sqlrun_sql.msp.log
Error Number : 29534
Error Description : MSP Error: 29534 Service 'MSSQLSERVER' could
not be started. Verify that you have sufficient privileges to start system
services. The error code is (1067) The process terminated unexpectedly.
----
--
Sorry I totally missed this.
--
Joel Cavazos
Network Administrator
MCSE, MCSA, MCP
"Aaron Bertrand [SQL Server MVP]" wrote:

> Did you upgrade the client tools but not the server instance (database
> services)?
> --
> Aaron Bertrand
> SQL Server MVP
>
>
> "jcavazos" <jcavazos@.discussions.microsoft.com> wrote in message
> news:DE12769F-1002-48C7-8487-89753A36CC84@.microsoft.com...
>
>

No comments:

Post a Comment