I have a client that needs me to set up a website that pulls sql reports from a separate server. Currently the only way to access the url to the reports server is to first rdp into that server. I tried creating a web services proxy class, but the url was unable to resolve due to the added protection.
Is there any way for me to pull the reports in my asp.net application from the other server without removing the rdp? This is my first time trying this, so im not sure if i am going about this the correct way or if it is even possible to access that server from the client web application with the rdp in place.
EDIT
All my application needs to do is display pre-made reports to specific clients/groups based on their login credentials. These clients/groups will not be creating or altering reports(at least not at this point in time).
I think you'll find its most likely not possible or probably very hard to do.
Perhaps you could obtain a copy of the database through replication or maybe a nightly bulk update and run the report against that, perhaps you could script a machine to remote desktop in and share the drives on it and get it to backup the db or similar.
In any case if you can't get a copy of the database I don't think you could feasibly generate any kind of report that allows user input to generate it.
EDIT:
It looks like this answer will get you started in connecting and triggering a file copy