SSRS --The server doenot exist

Question

SSRS --The server doenot exist

srilu_bannu

Hall of Fame

Points: 3100
More actions
November 12, 2010 at 1:10 pm

#226629

Hi all,
I have created a SSRS report and want to deploy it in our test server.
So i did select properties and specified the URL in the TargetServerURL and right clicked on the solution and selected deploy to deploy the report.
But i got this error:
The specified report server URL http://................ could not be found .verify the syntax of the URL and that the report server exists.
can anyone please tell me what i should do.

Viewing 12 posts - 1 through 11 (of 11 total)

You must be logged in to reply to this topic. Login to reply

getoffmyfoot Hall of Fame Points: 3338 More actions · Answer 1

We are going to have to wring more info out of you to figure out whats up.

1. Your url should be pointing to the report server's catalog, which is typically http://<servername>/ReportServer, in order to deploy a report.

2. You should be able to hit the SSRS website by going opening up a browser on the machine you are developing reports from, and going to http://<servername>/Reports

If you can't hit the website, then ssrs is either not running or you have some network/firewall/proxy issue to resolve.

If you can hit the website http://<servername>/ReportServer from the box you are developing a report from, then verify that you have publishing permissions on the report server.

Try that, and post back on what you find.

srilu_bannu Hall of Fame Points: 3100 More actions · Answer 2

Yes, my URL goes like this http://ServerName/ReportsTest.

And i can hit the URL on my machine ,but i was unable to find out why i am unable to deploy a report .

I will let you know if i find anything..

srilu_bannu Hall of Fame Points: 3100 More actions · Answer 3

My administrator just gave me permissions for my account ,but i am still seeing the error.

Is there anyway i could perform this using ssms.

If yes, can anyone please tell me.

Perry Whittle SSC Guru Points: 234013 More actions · Answer 4

you may upload the report via the report manager website!

-----------------------------------------------------------------------------------------------------------

"Ya can't make an omelette without breaking just a few eggs" 😉

srilu_bannu Hall of Fame Points: 3100 More actions · Answer 5

I have uploaded the report using report manager and clicked on the report to view it,i got this error.

The report server cannot process the report or shared dataset. The shared data source 'DataSource1' for the report server or SharePoint site is not valid. Browse to the server or site and select a shared data source. (rsInvalidDataSourceReference)

I have selected shared data source while creating the report in BIDS ,what else i need to do?

Can anyone please help me.

Perry Whittle SSC Guru Points: 234013 More actions · Answer 6

either the data source does not exist or it is in another folder on the SSRS instance. In report manager select the report and go to the data source option and point it to the correct data source! Or just upload the source to the path expected!

-----------------------------------------------------------------------------------------------------------

"Ya can't make an omelette without breaking just a few eggs" 😉

srilu_bannu Hall of Fame Points: 3100 More actions · Answer 7

Its my mistake the data source name in the server is not matching to the datasource in the BIDS ,so i have changed the data source name .

But i got another error when i clicked on the report :

An error has occurred during report processing. (rsProcessingAborted)

Cannot create a connection to data source 'SalesForecast'. (rsErrorOpeningConnection)

Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'.

The report server is on a different server and the data source i am using is pointing to different server .Is this the reason why i am getting an error.

the report runs good on BIDS.

Perry Whittle SSC Guru Points: 234013 More actions · Answer 8

BIDS executes under your windows user account so that will be golden 😉

Edit the data source properties in SSRS to execute in your preferred fashion (windows account, sql server account, etc)

-----------------------------------------------------------------------------------------------------------

"Ya can't make an omelette without breaking just a few eggs" 😉

srilu_bannu Hall of Fame Points: 3100 More actions · Answer 9

Perry Whittle (11/15/2010)
BIDS executes under your windows user account so that will be golden 😉
Edit the data source properties in SSRS to execute in your preferred fashion (windows account, sql server account, etc)

Do you want me to change the server in SSRS (datasource)where report server is on ?

Please correct me if i am wrong.

srilu_bannu Hall of Fame Points: 3100 More actions · Answer 10

I have changed the server in data source in report manager and BIDS and it worked .

now i want to schedule this report and send mail .

is it possible using ssms or in report manager?

could anyone tell me how to do that?

srilu_bannu Hall of Fame Points: 3100 More actions · Answer 11

I have changed the datasource and it worked,but the problem i am having right now is different.

I have scheduled and subscribed the report to send me a mail and in my subscriptions the status of my mail is saying that a mail has been sent to me but i am not seeing any mail in my mail box.

Can anyone tell me what could be the reason for that?

I am a system user for my reporting server instance .do i need to be an system administrator to send an email.