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\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
>

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
>

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

New Role Permissions

Hi,
I have installed RS in a production environment successfully. I then added a
user into the windows registry. I can access all 'tool bar' options like
'Upload Report' as an administrator on the localhost, but when I access RS by
the new role I have created I only get the almost blank 'home' page. I have
given the new role user every permission in RS via site wide configuration
settings ect., but I still don't get the upload option and other two options
on the 'tool bar'. What do Ineed to do to give the new user adminstration
wide access in RS, but not an administrator in windows.
ThanksYou need to set item-level permissions for that user.
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"Quinton" <Quinton@.discussions.microsoft.com> wrote in message
news:3BCBB0BF-D591-4189-9FB1-877599C85422@.microsoft.com...
> Hi,
> I have installed RS in a production environment successfully. I then added
> a
> user into the windows registry. I can access all 'tool bar' options like
> 'Upload Report' as an administrator on the localhost, but when I access RS
> by
> the new role I have created I only get the almost blank 'home' page. I
> have
> given the new role user every permission in RS via site wide configuration
> settings ect., but I still don't get the upload option and other two
> options
> on the 'tool bar'. What do Ineed to do to give the new user adminstration
> wide access in RS, but not an administrator in windows.
> Thanks|||Hi,
Thanks - but I must be a thick head, as the new user does not have any items
to set permissions on. Do you mean that as administrator I create a directory
and then set item level permissions on that for the new user?
Thnks,
Quinton
"Lev Semenets [MSFT]" wrote:
> You need to set item-level permissions for that user.
> --
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
> "Quinton" <Quinton@.discussions.microsoft.com> wrote in message
> news:3BCBB0BF-D591-4189-9FB1-877599C85422@.microsoft.com...
> > Hi,
> > I have installed RS in a production environment successfully. I then added
> > a
> > user into the windows registry. I can access all 'tool bar' options like
> > 'Upload Report' as an administrator on the localhost, but when I access RS
> > by
> > the new role I have created I only get the almost blank 'home' page. I
> > have
> > given the new role user every permission in RS via site wide configuration
> > settings ect., but I still don't get the upload option and other two
> > options
> > on the 'tool bar'. What do Ineed to do to give the new user adminstration
> > wide access in RS, but not an administrator in windows.
> >
> > Thanks
>
>|||Yes.
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"Quinton" <Quinton@.discussions.microsoft.com> wrote in message
news:902431F4-EBAE-4F44-A22A-4D33A68F2893@.microsoft.com...
> Hi,
> Thanks - but I must be a thick head, as the new user does not have any
> items
> to set permissions on. Do you mean that as administrator I create a
> directory
> and then set item level permissions on that for the new user?
> Thnks,
> Quinton
> "Lev Semenets [MSFT]" wrote:
>> You need to set item-level permissions for that user.
>> --
>> This posting is provided "AS IS" with no warranties, and confers no
>> rights.
>>
>> "Quinton" <Quinton@.discussions.microsoft.com> wrote in message
>> news:3BCBB0BF-D591-4189-9FB1-877599C85422@.microsoft.com...
>> > Hi,
>> > I have installed RS in a production environment successfully. I then
>> > added
>> > a
>> > user into the windows registry. I can access all 'tool bar' options
>> > like
>> > 'Upload Report' as an administrator on the localhost, but when I access
>> > RS
>> > by
>> > the new role I have created I only get the almost blank 'home' page. I
>> > have
>> > given the new role user every permission in RS via site wide
>> > configuration
>> > settings ect., but I still don't get the upload option and other two
>> > options
>> > on the 'tool bar'. What do Ineed to do to give the new user
>> > adminstration
>> > wide access in RS, but not an administrator in windows.
>> >
>> > Thanks
>>|||Thanks again Lev,
... but that didn't work, the new user that I added in the 'users' group in
windows still didn't get any tabs (content/properties) or any of the other
stuff needed to upload reports. I decided to cheat and just add my user into
the Administrators group. This worked, but, when I tried to add a data source
I get the error 'The underlying connection was closed: Could not establish
trust relationship with remote server.' I did try to create a connection with
every type of credentials.
This is my 4th installation of RS, the configurations of this installation
are:
Windows server 2003.
Reports/ReportServer are on a different drive to SQL instance.
SQL data on a different drive again.
Any ideas'
Quinton
"Lev Semenets [MSFT]" wrote:
> Yes.
> --
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
> "Quinton" <Quinton@.discussions.microsoft.com> wrote in message
> news:902431F4-EBAE-4F44-A22A-4D33A68F2893@.microsoft.com...
> > Hi,
> >
> > Thanks - but I must be a thick head, as the new user does not have any
> > items
> > to set permissions on. Do you mean that as administrator I create a
> > directory
> > and then set item level permissions on that for the new user?
> >
> > Thnks,
> > Quinton
> >
> > "Lev Semenets [MSFT]" wrote:
> >
> >> You need to set item-level permissions for that user.
> >>
> >> --
> >> This posting is provided "AS IS" with no warranties, and confers no
> >> rights.
> >>
> >>
> >> "Quinton" <Quinton@.discussions.microsoft.com> wrote in message
> >> news:3BCBB0BF-D591-4189-9FB1-877599C85422@.microsoft.com...
> >> > Hi,
> >> > I have installed RS in a production environment successfully. I then
> >> > added
> >> > a
> >> > user into the windows registry. I can access all 'tool bar' options
> >> > like
> >> > 'Upload Report' as an administrator on the localhost, but when I access
> >> > RS
> >> > by
> >> > the new role I have created I only get the almost blank 'home' page. I
> >> > have
> >> > given the new role user every permission in RS via site wide
> >> > configuration
> >> > settings ect., but I still don't get the upload option and other two
> >> > options
> >> > on the 'tool bar'. What do Ineed to do to give the new user
> >> > adminstration
> >> > wide access in RS, but not an administrator in windows.
> >> >
> >> > Thanks
> >>
> >>
> >>
>
>

new problem - RESTORE

I thought I have successfully restored a backup from another instance of
MSDE, however in my .NET program I am getting an error message about the
login failed. So what I did is create a login id using sp_grantlogin. I
assume that this allows my Windows login to be authenticated. Just in case,
I also added a new login account using sp_addlogin. Those both worked.
Now when I do...EXEC sp_grantaccess to the database, I get an error:
Database cannot be opened. It is in the middle of a restore.
When I was restoring, I did the RESTORE FILELISTONLY to get the names of the
files in the backup. I then did RESTORE DATABASE using WITH and MOVE which
announced it was successful, and the two files were placed into the
directory. I thought this was it, what did I miss?
Thanks,
Brad
Make sure you use WITH RECOVERY (the default) othewise the database will be
left in a state where it is expecting to continue the restore process using
additional backup sets. Also if you are moving databases from one server to
another you will need to synchronize the users using sp_change_users_login
(see the BOL for this one).
Jim
"AllcompPC" <allcomppc@.sbcglobal.net> wrote in message
news:%23LZHQ0HEFHA.624@.TK2MSFTNGP09.phx.gbl...
>I thought I have successfully restored a backup from another instance of
> MSDE, however in my .NET program I am getting an error message about the
> login failed. So what I did is create a login id using sp_grantlogin. I
> assume that this allows my Windows login to be authenticated. Just in
> case,
> I also added a new login account using sp_addlogin. Those both worked.
> Now when I do...EXEC sp_grantaccess to the database, I get an error:
> Database cannot be opened. It is in the middle of a restore.
> When I was restoring, I did the RESTORE FILELISTONLY to get the names of
> the
> files in the backup. I then did RESTORE DATABASE using WITH and MOVE
> which
> announced it was successful, and the two files were placed into the
> directory. I thought this was it, what did I miss?
> Thanks,
> Brad
>
|||Thank you Jim. I got it and it seems to be working fine.
Brad
"Jim Young" <thorium48@.hotmail.com> wrote in message
news:eY58HwIEFHA.228@.tk2msftngp13.phx.gbl...
> Make sure you use WITH RECOVERY (the default) othewise the database will
be
> left in a state where it is expecting to continue the restore process
using
> additional backup sets. Also if you are moving databases from one server
to[vbcol=seagreen]
> another you will need to synchronize the users using sp_change_users_login
> (see the BOL for this one).
> Jim
> "AllcompPC" <allcomppc@.sbcglobal.net> wrote in message
> news:%23LZHQ0HEFHA.624@.TK2MSFTNGP09.phx.gbl...
I
>