January 13, 2009 at 11:31 am
I am installing reporting services on a separate machine than that which has the database engine. In the configuration I am attempting to set up the database, but am running into an error 'An error has occurred while establishing a connection to the server... (provider: SQL Network Interfaces, error: 25 - Connection string is not valid)'.
Any ideas?
Thanks
January 13, 2009 at 12:34 pm
Where exactly are you getting the error? In the the reporting services configuration manager?
a couple things to check:
-possibly the data source connection string is wrong
-windows firewall may be enabled.
January 13, 2009 at 12:45 pm
I am receiving the error in the reporting services configuration at the Database Setup stage.
January 13, 2009 at 1:26 pm
Reporting services for 2005 needs to have a separate SQL license to run on a machine other than the machine it is deployed on. If you are trying to remotely connect to a machine using the same license I think I recall it rejecting the new install.
I also believe there is a separate install disk for installing Reporting services to run on a different server. If I find another reference I will post it.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply