Re: Using XML Reports to write to a different db
I'm trying to use XML Reports to SELECT ... INTO ... a separate database I have created called NBNReporting. The database is on the same instance of MSSQL2005 as NBNData. When I try and run my report, it gives the following error:
'The server principal "DOMAIN\CharlesR" is not able to access the database "NBNReporting" under the current security context'
Is it possible to resolve this issue by changing the security settings? If so, what security settings do I need to change? The query runs fine in SQL Server Management Studio, so it's not my own security settings that are causing the problem but something within the Recorder layer.
Many thanks,
Charles
Digital Development Manager | Field Studies Council
http://www.field-studies-council.org | https://twitter.com/charlesroper | https://twitter.com/fsc_digital