Hi .... I don't know if this is an appropriate place to post a simple question like this (apologize if it's not), but here goes:

I'm implementing a shared hosted website with DNN .... There is the DNN SQL Server database and a second SQL Server db that I've imported named "Manuscripts" that has its own ID string on the hosting provider's server.

I'm trying to test reporting out of the Manuscripts db using the DNN Reporting module (sample query: Select * from tblAuthors) and I keep getting an error.  No problem running a report on the DNN DB ((e.g. Select * from aspnet_users).   I've tried qualifying the sql every way I can think of (e.g. Select * from [Manuscripts].[tblAuthors] or qualifying with the ID string) and no go.  The website host uses the Metropolis install of DNN. 

Is there something I'm missing, reference to a DSN.  Unfortunately the host's documentation and support aren't getting me anywhere.  I should be able to query another sql server db on the same server, right?

Thanks in advance ....Marc

Hi Andrew,

Thank you very much.

I actually had tried your second idea  (SELECT * FROM [Manuscripts].[dbo].[tblAuthors]) and it hadn't worked. 

I just now tried your first idea and it didn't fly, unfortunately.  When I try to run it on the provider's Query Analyzer, I get a slightly more revealing error message - something along the lines of the second db not being available in the current 'security context' - this seemed to be the host's language.   I think my options at present are to somehow penetrate their user tools' (or support staff's) obstacles  ...or .... import the objects in the second database into the DNN database.   It just seems like poor housekeeping to throw them all together.   Or I can do it in asp.net or wait till they adopt your new release.   So I have lots of options.

Thanks again!

Marc

Hi Dave,

Thanks for the tip .... I will try it when I get in tomorrow  (+/-) and let you know.

Cheers!

Marc