Hi,
I have successfully upgraded a server with both the new SP2 and the 3050
hotfix. I am now trying to do this to my client workstation. It selected the
following components on my SQL2005 SP1 client to upgrade.
Setup Support Files
SQL Server Native Client
Client Components
MSXML 6.0 Parser
SQLXML4
Backward Compatibility
The client component upgrade failed on
Microsoft.sqlserver.notificationservices.dll. I had an error code 1603 and
this in the hotfix.log
MSP Error: 29549 Failed to install and configure assemblies c:\Program
Files\Microsoft SQL
Server\90\NotificationServices\9.0.242\Bin\microso ft.sqlserver.notificationservices.dll
in the COM+ catalog. Error: -2146233087
Error message: Unknown error 0x80131501
Error description: The Transaction Manager is not available. (Exception from
HRESULT: 0x8004D01B)
Any ideas?
Thanks
Chris
I found the answer on Connect. You need to have DTC running for the update
to finish.
Chris
"Chris Wood" <anonymous@.discussions.microsoft.com> wrote in message
news:evoMCLaYHHA.2556@.TK2MSFTNGP02.phx.gbl...
> Hi,
> I have successfully upgraded a server with both the new SP2 and the 3050
> hotfix. I am now trying to do this to my client workstation. It selected
> the following components on my SQL2005 SP1 client to upgrade.
> Setup Support Files
> SQL Server Native Client
> Client Components
> MSXML 6.0 Parser
> SQLXML4
> Backward Compatibility
> The client component upgrade failed on
> Microsoft.sqlserver.notificationservices.dll. I had an error code 1603 and
> this in the hotfix.log
> MSP Error: 29549 Failed to install and configure assemblies c:\Program
> Files\Microsoft SQL
> Server\90\NotificationServices\9.0.242\Bin\microso ft.sqlserver.notificationservices.dll
> in the COM+ catalog. Error: -2146233087
> Error message: Unknown error 0x80131501
> Error description: The Transaction Manager is not available. (Exception
> from HRESULT: 0x8004D01B)
> Any ideas?
> Thanks
> Chris
>
|||Try starting MSDTC if it's not already started and double check your event
logs for any COM+ errors.
HTH,
Jasper Smith (SQL Server MVP)
http://www.sqldbatips.com
"Chris Wood" <anonymous@.discussions.microsoft.com> wrote in message
news:evoMCLaYHHA.2556@.TK2MSFTNGP02.phx.gbl...
> Hi,
> I have successfully upgraded a server with both the new SP2 and the 3050
> hotfix. I am now trying to do this to my client workstation. It selected
> the following components on my SQL2005 SP1 client to upgrade.
> Setup Support Files
> SQL Server Native Client
> Client Components
> MSXML 6.0 Parser
> SQLXML4
> Backward Compatibility
> The client component upgrade failed on
> Microsoft.sqlserver.notificationservices.dll. I had an error code 1603 and
> this in the hotfix.log
> MSP Error: 29549 Failed to install and configure assemblies c:\Program
> Files\Microsoft SQL
> Server\90\NotificationServices\9.0.242\Bin\microso ft.sqlserver.notificationservices.dll
> in the COM+ catalog. Error: -2146233087
> Error message: Unknown error 0x80131501
> Error description: The Transaction Manager is not available. (Exception
> from HRESULT: 0x8004D01B)
> Any ideas?
> Thanks
> Chris
>
Showing posts with label selected. Show all posts
Showing posts with label selected. Show all posts
Wednesday, March 21, 2012
New SP2 Client Install Failure
Hi,
I have successfully upgraded a server with both the new SP2 and the 3050
hotfix. I am now trying to do this to my client workstation. It selected the
following components on my SQL2005 SP1 client to upgrade.
Setup Support Files
SQL Server Native Client
Client Components
MSXML 6.0 Parser
SQLXML4
Backward Compatibility
The client component upgrade failed on
Microsoft.sqlserver.notificationservices.dll. I had an error code 1603 and
this in the hotfix.log
MSP Error: 29549 Failed to install and configure assemblies c:\Program
Files\Microsoft SQL
Server\90\NotificationServices\9.0.242\Bin\microsoft.sqlserver.notificationservices.dll
in the COM+ catalog. Error: -2146233087
Error message: Unknown error 0x80131501
Error description: The Transaction Manager is not available. (Exception from
HRESULT: 0x8004D01B)
Any ideas?
Thanks
ChrisI found the answer on Connect. You need to have DTC running for the update
to finish.
Chris
"Chris Wood" <anonymous@.discussions.microsoft.com> wrote in message
news:evoMCLaYHHA.2556@.TK2MSFTNGP02.phx.gbl...
> Hi,
> I have successfully upgraded a server with both the new SP2 and the 3050
> hotfix. I am now trying to do this to my client workstation. It selected
> the following components on my SQL2005 SP1 client to upgrade.
> Setup Support Files
> SQL Server Native Client
> Client Components
> MSXML 6.0 Parser
> SQLXML4
> Backward Compatibility
> The client component upgrade failed on
> Microsoft.sqlserver.notificationservices.dll. I had an error code 1603 and
> this in the hotfix.log
> MSP Error: 29549 Failed to install and configure assemblies c:\Program
> Files\Microsoft SQL
> Server\90\NotificationServices\9.0.242\Bin\microsoft.sqlserver.notificationservices.dll
> in the COM+ catalog. Error: -2146233087
> Error message: Unknown error 0x80131501
> Error description: The Transaction Manager is not available. (Exception
> from HRESULT: 0x8004D01B)
> Any ideas?
> Thanks
> Chris
>|||Try starting MSDTC if it's not already started and double check your event
logs for any COM+ errors.
--
HTH,
Jasper Smith (SQL Server MVP)
http://www.sqldbatips.com
"Chris Wood" <anonymous@.discussions.microsoft.com> wrote in message
news:evoMCLaYHHA.2556@.TK2MSFTNGP02.phx.gbl...
> Hi,
> I have successfully upgraded a server with both the new SP2 and the 3050
> hotfix. I am now trying to do this to my client workstation. It selected
> the following components on my SQL2005 SP1 client to upgrade.
> Setup Support Files
> SQL Server Native Client
> Client Components
> MSXML 6.0 Parser
> SQLXML4
> Backward Compatibility
> The client component upgrade failed on
> Microsoft.sqlserver.notificationservices.dll. I had an error code 1603 and
> this in the hotfix.log
> MSP Error: 29549 Failed to install and configure assemblies c:\Program
> Files\Microsoft SQL
> Server\90\NotificationServices\9.0.242\Bin\microsoft.sqlserver.notificationservices.dll
> in the COM+ catalog. Error: -2146233087
> Error message: Unknown error 0x80131501
> Error description: The Transaction Manager is not available. (Exception
> from HRESULT: 0x8004D01B)
> Any ideas?
> Thanks
> Chris
>
I have successfully upgraded a server with both the new SP2 and the 3050
hotfix. I am now trying to do this to my client workstation. It selected the
following components on my SQL2005 SP1 client to upgrade.
Setup Support Files
SQL Server Native Client
Client Components
MSXML 6.0 Parser
SQLXML4
Backward Compatibility
The client component upgrade failed on
Microsoft.sqlserver.notificationservices.dll. I had an error code 1603 and
this in the hotfix.log
MSP Error: 29549 Failed to install and configure assemblies c:\Program
Files\Microsoft SQL
Server\90\NotificationServices\9.0.242\Bin\microsoft.sqlserver.notificationservices.dll
in the COM+ catalog. Error: -2146233087
Error message: Unknown error 0x80131501
Error description: The Transaction Manager is not available. (Exception from
HRESULT: 0x8004D01B)
Any ideas?
Thanks
ChrisI found the answer on Connect. You need to have DTC running for the update
to finish.
Chris
"Chris Wood" <anonymous@.discussions.microsoft.com> wrote in message
news:evoMCLaYHHA.2556@.TK2MSFTNGP02.phx.gbl...
> Hi,
> I have successfully upgraded a server with both the new SP2 and the 3050
> hotfix. I am now trying to do this to my client workstation. It selected
> the following components on my SQL2005 SP1 client to upgrade.
> Setup Support Files
> SQL Server Native Client
> Client Components
> MSXML 6.0 Parser
> SQLXML4
> Backward Compatibility
> The client component upgrade failed on
> Microsoft.sqlserver.notificationservices.dll. I had an error code 1603 and
> this in the hotfix.log
> MSP Error: 29549 Failed to install and configure assemblies c:\Program
> Files\Microsoft SQL
> Server\90\NotificationServices\9.0.242\Bin\microsoft.sqlserver.notificationservices.dll
> in the COM+ catalog. Error: -2146233087
> Error message: Unknown error 0x80131501
> Error description: The Transaction Manager is not available. (Exception
> from HRESULT: 0x8004D01B)
> Any ideas?
> Thanks
> Chris
>|||Try starting MSDTC if it's not already started and double check your event
logs for any COM+ errors.
--
HTH,
Jasper Smith (SQL Server MVP)
http://www.sqldbatips.com
"Chris Wood" <anonymous@.discussions.microsoft.com> wrote in message
news:evoMCLaYHHA.2556@.TK2MSFTNGP02.phx.gbl...
> Hi,
> I have successfully upgraded a server with both the new SP2 and the 3050
> hotfix. I am now trying to do this to my client workstation. It selected
> the following components on my SQL2005 SP1 client to upgrade.
> Setup Support Files
> SQL Server Native Client
> Client Components
> MSXML 6.0 Parser
> SQLXML4
> Backward Compatibility
> The client component upgrade failed on
> Microsoft.sqlserver.notificationservices.dll. I had an error code 1603 and
> this in the hotfix.log
> MSP Error: 29549 Failed to install and configure assemblies c:\Program
> Files\Microsoft SQL
> Server\90\NotificationServices\9.0.242\Bin\microsoft.sqlserver.notificationservices.dll
> in the COM+ catalog. Error: -2146233087
> Error message: Unknown error 0x80131501
> Error description: The Transaction Manager is not available. (Exception
> from HRESULT: 0x8004D01B)
> Any ideas?
> Thanks
> Chris
>
New SP2 Client Install Failure
Hi,
I have successfully upgraded a server with both the new SP2 and the 3050
hotfix. I am now trying to do this to my client workstation. It selected the
following components on my SQL2005 SP1 client to upgrade.
Setup Support Files
SQL Server Native Client
Client Components
MSXML 6.0 Parser
SQLXML4
Backward Compatibility
The client component upgrade failed on
Microsoft.sqlserver.notificationservices.dll. I had an error code 1603 and
this in the hotfix.log
MSP Error: 29549 Failed to install and configure assemblies c:\Program
Files\Microsoft SQL
Server\90\NotificationServices\9.0.242\Bin\microsoft.sqlserver.notifications
ervices.dll
in the COM+ catalog. Error: -2146233087
Error message: Unknown error 0x80131501
Error description: The Transaction Manager is not available. (Exception from
HRESULT: 0x8004D01B)
Any ideas?
Thanks
ChrisI found the answer on Connect. You need to have DTC running for the update
to finish.
Chris
"Chris Wood" <anonymous@.discussions.microsoft.com> wrote in message
news:evoMCLaYHHA.2556@.TK2MSFTNGP02.phx.gbl...
> Hi,
> I have successfully upgraded a server with both the new SP2 and the 3050
> hotfix. I am now trying to do this to my client workstation. It selected
> the following components on my SQL2005 SP1 client to upgrade.
> Setup Support Files
> SQL Server Native Client
> Client Components
> MSXML 6.0 Parser
> SQLXML4
> Backward Compatibility
> The client component upgrade failed on
> Microsoft.sqlserver.notificationservices.dll. I had an error code 1603 and
> this in the hotfix.log
> MSP Error: 29549 Failed to install and configure assemblies c:\Program
> Files\Microsoft SQL
> Server\90\NotificationServices\9.0.242\Bin\microsoft.sqlserver.notificatio
nservices.dll
> in the COM+ catalog. Error: -2146233087
> Error message: Unknown error 0x80131501
> Error description: The Transaction Manager is not available. (Exception
> from HRESULT: 0x8004D01B)
> Any ideas?
> Thanks
> Chris
>|||Try starting MSDTC if it's not already started and double check your event
logs for any COM+ errors.
HTH,
Jasper Smith (SQL Server MVP)
http://www.sqldbatips.com
"Chris Wood" <anonymous@.discussions.microsoft.com> wrote in message
news:evoMCLaYHHA.2556@.TK2MSFTNGP02.phx.gbl...
> Hi,
> I have successfully upgraded a server with both the new SP2 and the 3050
> hotfix. I am now trying to do this to my client workstation. It selected
> the following components on my SQL2005 SP1 client to upgrade.
> Setup Support Files
> SQL Server Native Client
> Client Components
> MSXML 6.0 Parser
> SQLXML4
> Backward Compatibility
> The client component upgrade failed on
> Microsoft.sqlserver.notificationservices.dll. I had an error code 1603 and
> this in the hotfix.log
> MSP Error: 29549 Failed to install and configure assemblies c:\Program
> Files\Microsoft SQL
> Server\90\NotificationServices\9.0.242\Bin\microsoft.sqlserver.notificatio
nservices.dll
> in the COM+ catalog. Error: -2146233087
> Error message: Unknown error 0x80131501
> Error description: The Transaction Manager is not available. (Exception
> from HRESULT: 0x8004D01B)
> Any ideas?
> Thanks
> Chris
>sql
I have successfully upgraded a server with both the new SP2 and the 3050
hotfix. I am now trying to do this to my client workstation. It selected the
following components on my SQL2005 SP1 client to upgrade.
Setup Support Files
SQL Server Native Client
Client Components
MSXML 6.0 Parser
SQLXML4
Backward Compatibility
The client component upgrade failed on
Microsoft.sqlserver.notificationservices.dll. I had an error code 1603 and
this in the hotfix.log
MSP Error: 29549 Failed to install and configure assemblies c:\Program
Files\Microsoft SQL
Server\90\NotificationServices\9.0.242\Bin\microsoft.sqlserver.notifications
ervices.dll
in the COM+ catalog. Error: -2146233087
Error message: Unknown error 0x80131501
Error description: The Transaction Manager is not available. (Exception from
HRESULT: 0x8004D01B)
Any ideas?
Thanks
ChrisI found the answer on Connect. You need to have DTC running for the update
to finish.
Chris
"Chris Wood" <anonymous@.discussions.microsoft.com> wrote in message
news:evoMCLaYHHA.2556@.TK2MSFTNGP02.phx.gbl...
> Hi,
> I have successfully upgraded a server with both the new SP2 and the 3050
> hotfix. I am now trying to do this to my client workstation. It selected
> the following components on my SQL2005 SP1 client to upgrade.
> Setup Support Files
> SQL Server Native Client
> Client Components
> MSXML 6.0 Parser
> SQLXML4
> Backward Compatibility
> The client component upgrade failed on
> Microsoft.sqlserver.notificationservices.dll. I had an error code 1603 and
> this in the hotfix.log
> MSP Error: 29549 Failed to install and configure assemblies c:\Program
> Files\Microsoft SQL
> Server\90\NotificationServices\9.0.242\Bin\microsoft.sqlserver.notificatio
nservices.dll
> in the COM+ catalog. Error: -2146233087
> Error message: Unknown error 0x80131501
> Error description: The Transaction Manager is not available. (Exception
> from HRESULT: 0x8004D01B)
> Any ideas?
> Thanks
> Chris
>|||Try starting MSDTC if it's not already started and double check your event
logs for any COM+ errors.
HTH,
Jasper Smith (SQL Server MVP)
http://www.sqldbatips.com
"Chris Wood" <anonymous@.discussions.microsoft.com> wrote in message
news:evoMCLaYHHA.2556@.TK2MSFTNGP02.phx.gbl...
> Hi,
> I have successfully upgraded a server with both the new SP2 and the 3050
> hotfix. I am now trying to do this to my client workstation. It selected
> the following components on my SQL2005 SP1 client to upgrade.
> Setup Support Files
> SQL Server Native Client
> Client Components
> MSXML 6.0 Parser
> SQLXML4
> Backward Compatibility
> The client component upgrade failed on
> Microsoft.sqlserver.notificationservices.dll. I had an error code 1603 and
> this in the hotfix.log
> MSP Error: 29549 Failed to install and configure assemblies c:\Program
> Files\Microsoft SQL
> Server\90\NotificationServices\9.0.242\Bin\microsoft.sqlserver.notificatio
nservices.dll
> in the COM+ catalog. Error: -2146233087
> Error message: Unknown error 0x80131501
> Error description: The Transaction Manager is not available. (Exception
> from HRESULT: 0x8004D01B)
> Any ideas?
> Thanks
> Chris
>sql
Friday, March 9, 2012
New login problem
Hi,
When i create a new login on my sql server 2005, i have a default database role selected. Is there a way to remove it or to modify it ?Thanks
Zahir
Hi,
do you mean the public role ? This role cannot be removed or disabled.
Try to make the role secure an grant not that many rights to it.
HTH, Jens Suessmeyer.
http://www.sqlserver2005.de
-
Subscribe to:
Posts (Atom)