Add database from another server
My reporting services is set up on a test server, sql04- i have a database that is 'live' on sql02, can i add a dataset reference to this other server so my report pulls data from that db on the other server?
Thx in advance
I tried to change the connection string from
Data Source=FTWSQL04;Initial Catalog=TestNav
Data Source=FTWSQL02;Initial Catalog=NAV_2009_SP1
May 25th, 2011 11:43am
Ah it was the security settings that was throwing the error........ Login creds.....
Free Windows Admin Tool Kit Click here and download it now
May 25th, 2011 11:56am
This topic is archived. No further replies will be accepted.
Other recent topics
