Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
cipriani1984
Constraint Violating Yak Guru
304 Posts |
 Posted - 2008-10-06 : 08:20:22
|
| Hi All,I have setup the report server and have deployed 2 reports. The reports work when I access the server locally on the server. But from external location the site loads up and i get to the report and the error is presented.'An error has occurred during report processing. (rsProcessingAborted)Cannot create a connection to data source 'qlsdat'. (rsErrorOpeningConnection)For more information about this error navigate to the report server on the local server machine, or enable remote errors 'When this works perfectly fine locally.Cipriani |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-10-06 : 08:24:42
|
| do you have given access to datasource from outside? are you using windows integrated authentication? |
 |
|
|
cipriani1984
Constraint Violating Yak Guru
304 Posts |
Posted - 2008-10-06 : 08:31:19
|
| I am using windows integrated authentication. How do I make access to the DS public? |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-10-06 : 08:34:21
|
quote:
Originally posted by cipriani1984
I am using windows integrated authentication. How do I make access to the DS public?
whats the account you're using to connect to server from outside? |
|
|
|
cipriani1984
Constraint Violating Yak Guru
304 Posts |
Posted - 2008-10-06 : 08:37:46
|
| its same account, support guys here setup exactly same environment. Ive just deployed another report on there locally on the remote server and the report loads. I jumped out of the server and on my local machine im trying to view the report and its giving same error. |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-10-06 : 09:33:31
|
quote:
Originally posted by cipriani1984
its same account, support guys here setup exactly same environment. Ive just deployed another report on there locally on the remote server and the report loads. I jumped out of the server and on my local machine im trying to view the report and its giving same error.
is the local machine also in same domain? |
|
|
|
cipriani1984
Constraint Violating Yak Guru
304 Posts |
Posted - 2008-10-06 : 09:34:56
|
| no. Reports work fine in remote machine but on local machine not. |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-10-06 : 09:43:42
|
quote:
Originally posted by cipriani1984
no. Reports work fine in remote machine but on local machine not.
if machine is not in domain, you wont be able to connect to report using domain account. |
|
|
|
|
|
|
Setting up Report Server