Database Move

Hi
I am doing a test database migration for SQL Reporting Services (leaving
the front end as it is). I have successfully moved the database using
http://support.microsoft.com/?kbid=842425 as ref guide. I have also moved
the databases that the reports uses to collect data from. I have updated
the data source icon for the reports to point to new database location.
When i want to view the reports i now get the following error:
Login failed for user '(null)'. Reason: Not associated with a trusted SQL
Server connection
Have i missed a step to get this working (there is no mention on KB842425
about security settings)?
Your help will be appreciated.
--
Regards
James[MVP for MBS Great Plains]
Visit MBS Blog Central
http://mbscentral.blogs.comDoes SQL Reporting Services Datasource support named instanced server names?
--
Regards
James[MVP]
Visit MBS Blog Central
http://mbscentral.blogs.com
"James[MVP]" <hushdontspamme@.Hotmail.com> wrote in message
news:ONGULWCRFHA.2744@.TK2MSFTNGP10.phx.gbl...
> Hi
> I am doing a test database migration for SQL Reporting Services (leaving
> the front end as it is). I have successfully moved the database using
> http://support.microsoft.com/?kbid=842425 as ref guide. I have also
> moved the databases that the reports uses to collect data from. I have
> updated the data source icon for the reports to point to new database
> location.
> When i want to view the reports i now get the following error:
> Login failed for user '(null)'. Reason: Not associated with a trusted SQL
> Server connection
> Have i missed a step to get this working (there is no mention on KB842425
> about security settings)?
> Your help will be appreciated.
> --
> Regards
> James[MVP for MBS Great Plains]
> Visit MBS Blog Central
> http://mbscentral.blogs.com
>|||Yes.
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/rsinstall/htm/gs_installingrs_v1_8k82.asp
Jens Suessmeyer.
--
http://www.sqlserver2005.de
--
"James[MVP]" <hushdontspamme@.Hotmail.com> schrieb im Newsbeitrag
news:efJ0hmCRFHA.1396@.TK2MSFTNGP10.phx.gbl...
> Does SQL Reporting Services Datasource support named instanced server
> names?
> --
> Regards
> James[MVP]
> Visit MBS Blog Central
> http://mbscentral.blogs.com
> "James[MVP]" <hushdontspamme@.Hotmail.com> wrote in message
> news:ONGULWCRFHA.2744@.TK2MSFTNGP10.phx.gbl...
>> Hi
>> I am doing a test database migration for SQL Reporting Services (leaving
>> the front end as it is). I have successfully moved the database using
>> http://support.microsoft.com/?kbid=842425 as ref guide. I have also
>> moved the databases that the reports uses to collect data from. I have
>> updated the data source icon for the reports to point to new database
>> location.
>> When i want to view the reports i now get the following error:
>> Login failed for user '(null)'. Reason: Not associated with a trusted SQL
>> Server connection
>> Have i missed a step to get this working (there is no mention on
>> KB842425 about security settings)?
>> Your help will be appreciated.
>> --
>> Regards
>> James[MVP for MBS Great Plains]
>> Visit MBS Blog Central
>> http://mbscentral.blogs.com
>|||If SQL Server remains on a second machine, the SQL Server must handle
delegation.
http://pluralsight.com/blogs/keith/archive/2004/07/08/1586.aspx
HTH, Jens Suessmeyer.
--
http://www.sqlserver2005.de
--
"James[MVP]" <hushdontspamme@.Hotmail.com> schrieb im Newsbeitrag
news:ONGULWCRFHA.2744@.TK2MSFTNGP10.phx.gbl...
> Hi
> I am doing a test database migration for SQL Reporting Services (leaving
> the front end as it is). I have successfully moved the database using
> http://support.microsoft.com/?kbid=842425 as ref guide. I have also
> moved the databases that the reports uses to collect data from. I have
> updated the data source icon for the reports to point to new database
> location.
> When i want to view the reports i now get the following error:
> Login failed for user '(null)'. Reason: Not associated with a trusted SQL
> Server connection
> Have i missed a step to get this working (there is no mention on KB842425
> about security settings)?
> Your help will be appreciated.
> --
> Regards
> James[MVP for MBS Great Plains]
> Visit MBS Blog Central
> http://mbscentral.blogs.com
>